June 20, 2012 at 8:28 am
I am running SQL Server 2008 R2 on my local SBS 2011 server and I have legacy SQL Server 2000 databases running on a remote server.
I am currently using Enterprise Manager and Query Analyzer for access to the remote SQL Server 2000 databases.
My question is does Microsoft support the connection of SSMS 2008 R2 to a SQL Server 2000 database and if so, does anyone know of any problems with doing this?
Thanks
Howard
June 20, 2012 at 9:34 am
Yes you can, and I am not "aware" of any problems.
Jared
CE - Microsoft
June 20, 2012 at 9:50 am
Jared:
Thank you for your response to my question.
Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:
In SSMS Object Explorer
File
Connect Object Explorer
Enter the appropriate information.
Howard
June 20, 2012 at 10:59 am
hmbtx (6/20/2012)
Jared:Thank you for your response to my question.
Am I correct that in order to access the remote SQL Server 2000 databases I would perform the following steps:
In SSMS Object Explorer
File
Connect Object Explorer
Enter the appropriate information.
Howard
That's one way. I don't go to file-->connect object explorer. I just click on connect --> database engine in the object explorer window. However, they both do the same thing.
Jared
CE - Microsoft
June 20, 2012 at 12:33 pm
Jared:
Thank you for taking the time to help on this.
Howard
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply