Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Issues - SQL 2K and SQL 2K5 on same box

Author  Topic 

anchaljain
Starting Member

8 Posts

Posted - 2007-06-13 : 00:50:33
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
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2007-06-13 : 07:38:01
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
Master Smack Fu Yak Hacker

7266 Posts

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

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-06-13 : 11:00:55
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

8 Posts

Posted - 2007-06-14 : 06:36:47
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
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-14 : 06:53:21
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

8 Posts

Posted - 2007-06-14 : 07:00:19
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
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-06-14 : 07:05:13
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

8 Posts

Posted - 2007-06-14 : 07:14:26
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
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-14 : 13:29:08
Those instances have to use different port.
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-06-14 : 13:31:57
what service pack have you installed for SQL 2K?
Go to Top of Page
   

- Advertisement -