Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 14th, 2006, 10:23 AM
Authorized User
 
Join Date: Mar 2005
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server 2000 and 2005

Our network guy first installed 2005 on our server. I created a database, we had some sort of issues and so decided to install 2000. I removed the db I created on 2005 and restored it on 2000 instead.

Here's my problem....When I log in to query analyzer(sql 2000) using my windows auth, I get a list of database that are on the 2005 server, not 2000.

I think 2005 is set as my default server. How can I change it to be 2000?

Any help is greatly appreciated.

Thanks,
Ninel


 
Old September 14th, 2006, 12:39 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

OK, maybe I am not completely understanding what happened. From what i gather, you installed SQL Server 2005, then installed SQL Server 2000 without uninstalling SQL Server 2005. Correct? If that is the case, when you installed SQL Server 2000, did you create a new instance of SQL Server 2000? It appears that for some reason SQL Server 2000 is using the same SQL Server 2005 instance. I have never had both installed on the same box, espcially in that order, but that is what it sounds like is happening.

I would remove SQL Server 2000, reinstall with a new instance, and try again.

 
Old September 14th, 2006, 12:51 PM
Authorized User
 
Join Date: Mar 2005
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Ok...I created a login on the 2000 server called timecontroluser. When I use
remote desktop to logon to the server I connect to query analyzer like this:
We have both servers running.

Ok...I created a login on the 2000 server called timecontroluser. When I use remote desktop to logon to the server I connect to query analyzer like this:

SQL Server: ITITPAIT04\SQL2K
SQL Authentication:
        Login: timecontroluser
        Pass: timecontroluser

This works. I get logged in.

When I am not directly on the server, but using my local query analyzer to logon doing the same as above, I get "SQL Server does not exist or Access is denied"

Why can't I connect?

 
Old September 14th, 2006, 01:00 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Try it like the following:

SQL Server: ITITPAIT04
SQL Authentication:
        Login: timecontroluser
        Pass: timecontroluser

What happens?

 
Old September 14th, 2006, 01:03 PM
Authorized User
 
Join Date: Mar 2005
Posts: 47
Thanks: 0
Thanked 0 Times in 0 Posts
Default

If I just use ITITPAIT04, it connects me to the 2005 server. ITITPAIT04\SQL2k is the instance of 2000.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Conflict in SQL Server 2000 and SQL Server 2005 ayan.mukherjee SQL Language 0 June 30th, 2008 03:34 AM
Upgrade to SQL Server 2005 from 2000 srotondo SQL Server 2005 2 February 14th, 2008 02:26 PM
Difference B/W sql server 2000 and 2005 bhasker_braj121 SQL Server 2005 1 January 19th, 2008 12:01 PM
mysql and sql server 2000/2005 Sheraz Khan MySQL 1 October 22nd, 2007 06:01 PM
migrating from sql server 2000 to sql server 2005 abinashpatra SQL Server 2005 2 December 1st, 2006 03:45 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.