Posted by Erland Sommarskog on 05/28/05 00:08

RDV (roger.vaught@ipaper.com) writes:
> 1) Can you manage a SQL Server Express installation from the regular
> SQL Server Enterprise Manager? I am getting a message that says "SQL
> Server does not exist or access is denied" when I try to register the
> SQL Server Express instance via Enterprise Manager.
>
> If this is possible, what kind of things should I be looking for to
> make this work?

Given the error message, EM does not even reach SQL Server Express. There
could be several reasons for this. A common error is to not observer
that by default SQL Express is installed as a named instance with the
name \SQLEXPRESS. If SQL Express runs on another machine, you will have
to enable TCP/IP or Named pipes for Express, since by default it listens
on shared memory only.

But as Josh said, EM is for SQL 2000, and SQL Express is for SQL 2005.
So even if you manage to make contact, you may be told that you cannot
enter. Or you will be let it, but a lot of things will not work well.

On the other hand, running queries from Query Analyzer against SQL
Express works fine.

> 2) Can you schedule replication from SQL Server 2000 to SQL Server
> Express? I want to replicate from a central place to several client
> machines on a scheduled basis.

I would guess that this would be possible, but I will have to admit
that I'm not entirely up to date on what SQL Express supports and not.

Overall, questions about SQL 2005 are best asked about in the
beta newsgroups, see here for connection info:
http://go.microsoft.com/fwlink/?linkid=31765.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]