|
Home > Archive > MS SQL Server > January 2006 > Sql Server 2005 Management Console Connect to Sql Server 2000?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sql Server 2005 Management Console Connect to Sql Server 2000?
|
|
| Selden 2006-01-18, 8:23 pm |
| 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
| |
| Mike Hodgson 2006-01-19, 3:23 am |
| 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.
--
mike hodgson
http://sqlnerd.blogspot.com
"Selden" <smccabe@community.nospam> wrote in message
news:5A8661DE-E122-4341-9B9E- 679D290F7F6D@microso
ft.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
| |
| Michael Cheng [MSFT] 2006-01-19, 3:23 am |
| 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.
| |
| Mike Hodgson 2006-01-19, 3:23 am |
| 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".
--
*mike hodgson*
http://sqlnerd.blogspot.com
Michael Cheng [MSFT] wrote:
>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.
>
>
>
| |
| Roger Wolter[MSFT] 2006-01-19, 11:23 am |
| 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.
--
This 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@microso
ft.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
|
|
|
|
|