SQL Server Express

[RDV]

I have 2 SQL Server Express questions:

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?

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.

Thanks in advance for the help.

[joshsackett]

SQL Express is next-gen, so the previous SQL 2000 cannot be used to
connect to it. You must use the SQL Express Manager (available by a
separate download).

I'm not positive if SQL Express allows replication. I believe it is
only for desktop use. Check Books Online.

[joshsackett]

SQL Express is next-gen, so the previous SQL 2000 tools cannot be used
to connect to it. You must use the SQL Express Manager (available by a
separate download).

I'm not positive if SQL Express allows replication. I believe it is
only for desktop use. Check Books Online.

[Erland Sommarskog]

RDV (ro**********@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, es****@sommarskog.se

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

[joshsackett]

Holy Moly! I was not aware that Query Analyzer would connect to SQL
Express. That's fantastic! I really dislike the Express Manager
interface.

Thanks for the tip Erland.

[Erland Sommarskog]

joshsackett (jo*********@gmail.com) writes:

Holy Moly! I was not aware that Query Analyzer would connect to SQL
Express. That's fantastic! I really dislike the Express Manager
interface.

There is one thing that is nice with it: it comes at no cost. :-)

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

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