|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Sql Server 2005 Management Console Connect to Sql Server 2000?
I recently installed Sql Server 2005 on one of my computers.
I'm trying to copy a database to Sql Server 2000. I can click Connect, Database Engine, and find my sql server 2000 on the network, but the connection always fails. Is it possible to connect to Sql server 2000 databases from Sql Server 2005? Is there some trick or setting I need to make? Thanks, ----Selden Yes, it's possible.
No, there's no trick to it. One thing you cannot do, however, is administer a database in 6.5 compatibility mode (see sp_dbcmptlevel in BOL) with SQL Server Management Studio. But that doesn't explain why you cannot even connect to your SQL 2000 box. Have you checked all the standard things like: - am I using a trusted or standard connection? - does my SQL 2000 allow standard connections or is it NT auth only? - is my current windows account a trusted login on my SQL 2000 box? - can I ping the SQL 2000 box from here? - does DNS resolve the name to the right IP address? - is the SQL Server service currently running on my SQL 2000 box? - can I connect to my SQL 2000 box from any other machine? - can I connect to my SQL 2000 box with any other app (eg. odbcad32.exe or SQLEM or QA)? - what network protocols is my SQL 2000 box listening on? - what protocol am I trying to use when attempting a connection to it? Answering a few of these basic connectivity troubleshooting questions may get you a little closer to solving your connectivity problem. Show quoteHide quote "Selden" <smccabe@community.nospam> wrote in message news:5A8661DE-E122-4341-9B9E-679D290F7F6D@microsoft.com... >I recently installed Sql Server 2005 on one of my computers. > > I'm trying to copy a database to Sql Server 2000. > > I can click Connect, Database Engine, and find my sql server 2000 on the > network, but the connection always fails. Is it possible to connect to > Sql > server 2000 databases from Sql Server 2005? Is there some trick or > setting I > need to make? > > Thanks, > ----Selden Hi Selden,
Welcome to use MSDN Managed Newsgroup! From your descriptiosn, I understood you would like to connect SQL Server 2000 via SQL Server Management Studio. If I have misunderstood your concern, please feel free to point it out. We cannot use SQL Server Management Stuido to connect SQL Server 2000 instance. If you want to upgrade your SQL Server 2000 databases to SQL Server 2005, you may refer the articles below for more detailed information How to move databases between computers that are running SQL Server http://support.microsoft.com/kb/314546/en-us Upgrading to SQL Server 2005 ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/f7e79c63-875a-446c-9860- 439486928ba1.htm Thank you for your patience and cooperation. If you have any questions or concerns, don't hesitate to let me know. We are always here to be of assistance! Sincerely yours, Michael Cheng Microsoft Online Partner Support When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. I'm sorry Michael, but that's just not right (unless I've misunderstood
what you're trying to say). I regularly connect to and administer SQL 2000 databases with SQL Server Management Studio (and have since early SQL 2005 beta 2 days - for over a year now). I think there would be a major riot in the SQL Server community if this were not possible. To prove my point, have a look at the attached screen shot. Notice the version number of the server in the Object Explorer pane? 8.0.840 - that's SQL 2000. I think perhaps something got lost in translation here as this is a very simple case of "yes, you can connect to a SQL 2000 instance using SSMS". Show quoteHide quote >Hi Selden, > >Welcome to use MSDN Managed Newsgroup! > >From your descriptiosn, I understood you would like to connect SQL Server >2000 via SQL Server Management Studio. If I have misunderstood your >concern, please feel free to point it out. > >We cannot use SQL Server Management Stuido to connect SQL Server 2000 >instance. If you want to upgrade your SQL Server 2000 databases to SQL >Server 2005, you may refer the articles below for more detailed information > >How to move databases between computers that are running SQL Server >http://support.microsoft.com/kb/314546/en-us > >Upgrading to SQL Server 2005 >ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/f7e79c63-875a-446c-9860- >439486928ba1.htm > >Thank you for your patience and cooperation. If you have any questions or >concerns, don't hesitate to let me know. We are always here to be of >assistance! > > >Sincerely yours, > >Michael Cheng >Microsoft Online Partner Support > >When responding to posts, please "Reply to Group" via your newsreader so >that others may learn and benefit from your issue. >===================================================== >This posting is provided "AS IS" with no warranties, and confers no rights. > > > Do you have a login in the SQL Server 2000 database for the user you are
running management studio as? It might be good to look at the error message from the connect and the SQL Server 2000 error log to see if there are any clues there. -- Show quoteHide quoteThis posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm "Selden" <smccabe@community.nospam> wrote in message news:5A8661DE-E122-4341-9B9E-679D290F7F6D@microsoft.com... >I recently installed Sql Server 2005 on one of my computers. > > I'm trying to copy a database to Sql Server 2000. > > I can click Connect, Database Engine, and find my sql server 2000 on the > network, but the connection always fails. Is it possible to connect to > Sql > server 2000 databases from Sql Server 2005? Is there some trick or > setting I > need to make? > > Thanks, > ----Selden  
Other interesting topics
|
|||||||||||||||||||||||
