SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Issues - SQL 2K and SQL 2K5 on same box
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

anchaljain
Starting Member

India
8 Posts

Posted - 06/13/2007 :  00:50:33  Show Profile  Reply with Quote
Hi,
I have installed SQL Server 2K and SQL Server 2K5 on same box. First,I installed SQL Server 2K5 and then 2K.
2K5 is working fine..I am able to connect my server from client. But while trying to connect to SQL 2K from client, it is giving me error and I am not able to connect to the SQL Servr 2K installed on server machine.

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 06/13/2007 :  07:38:01  Show Profile  Reply with Quote
I have 2k5 and 2k on the same box. I have no problems connecting to either one. There are too many things to count that could be wrong.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/13/2007 :  10:56:16  Show Profile  Reply with Quote
Did you specify correct instance name? Which netlib did you use to connect to sql2k?
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 06/13/2007 :  11:00:55  Show Profile  Reply with Quote
are you running the latest sql server service packs? sp2a for SQL 2K5 and SP4 for SQL2K?


-ec
Go to Top of Page

anchaljain
Starting Member

India
8 Posts

Posted - 06/14/2007 :  06:36:47  Show Profile  Reply with Quote
Hi,
I installed SQL Server 2K5 first and then SQL Server2K then.
On server machines both are running fine but on client machine, it is giving me following error:
A connection could not be established to the ServerName
REason: SQL Server doesnot exist or access denied
ConnectionOpen(Connect())..
Please verify SQL Server is running and check for SQL registration properties and try again.
.

I cannot uninstall SQL SErver2005 and then try installing SQL Server 2000 again.
I am in a urgent need.Any help is appreciated.
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5581 Posts

Posted - 06/14/2007 :  06:53:21  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
I think you are not getting the point here. Since you installed 2005 first, that became default instance and you have no problem connecting it. But 2000 is added as named instance, so while connecting, you need to specify server-name in the following format:

<Server-Name>\<Instance-Name>


Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

anchaljain
Starting Member

India
8 Posts

Posted - 06/14/2007 :  07:00:19  Show Profile  Reply with Quote
I did the same way.
Can the problem be : I found the following error logged in the log file:
SuperSocket Info: Bind failed on TCP port 1433.
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5581 Posts

Posted - 06/14/2007 :  07:05:13  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
Which authentication you are using to connect to SQL 2000? What authentication mode is set when installing SQL 2000?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

anchaljain
Starting Member

India
8 Posts

Posted - 06/14/2007 :  07:14:26  Show Profile  Reply with Quote
For both version I am using SQL Authentication.
For 2000, I am using sa username and password defined by me.
For 2005 version, I am using a different username and password.
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/14/2007 :  13:29:08  Show Profile  Reply with Quote
Those instances have to use different port.
Go to Top of Page

eyechart
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 06/14/2007 :  13:31:57  Show Profile  Reply with Quote
what service pack have you installed for SQL 2K?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.1 seconds. Powered By: Snitz Forums 2000