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.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
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? |
|
|
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 |
|
|
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 ServerNameREason: SQL Server doesnot exist or access deniedConnectionOpen(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. |
|
|
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 AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
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. |
|
|
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 AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
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. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-14 : 13:29:08
|
Those instances have to use different port. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-06-14 : 13:31:57
|
what service pack have you installed for SQL 2K? |
|
|
|