Saturday, February 25, 2012

Registration access denied

Am I able to register SQL2005 server in Enterprise Manager of SQL2000, or SQL2000 server in SQL Server Management Studio?

You can use enterprise manager from sql 2005 to administer both sql 2000 and sql 2005 databases.

I doubt that the enterprise manager from sql 2000 would work with a sql 2005 database.

|||How should I use enterprise manager in SQL2005?|||

Its Management Studio.

From Management Studio, you can connect to both sql 2000 and sql 2005 databases.

http://www.aspfaq.com/sql2005/show.asp?id=3

|||this SQL Express, is there any stest I can use for SQL 2000?|||

Hi

Below is from previous link:

As for connecting to Express from application code, this should not be any different from connecting to a named instance of SQL Server 2000. Your connection string should look like this, assuming local machine and an instance name of SQLEXPRESS (you might need a different instance name, and you may have to use a machine name, rather than "." (which means local)).

No comments:

Post a Comment