By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,002 Members | 2,137 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,002 IT Pros & Developers. It's quick & easy.

SQL Server Express

P: n/a
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.

Jul 23 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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.

Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

P: n/a
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
Jul 23 '05 #4

P: n/a
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.

Jul 23 '05 #5

P: n/a
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
Jul 23 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.