Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 14th, 2006, 10:23 AM
Authorized User
 
Join Date: Mar 2005
Location: , , .
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


Reply With Quote
  #2 (permalink)  
Old September 14th, 2006, 12:39 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
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.

Reply With Quote
  #3 (permalink)  
Old September 14th, 2006, 12:51 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
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?

Reply With Quote
  #4 (permalink)  
Old September 14th, 2006, 01:00 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Location: Wellington, FL , USA.
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?

Reply With Quote
  #5 (permalink)  
Old September 14th, 2006, 01:03 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
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.

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:20 PM.


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