| Author |
 Topic  |
|
|
anchaljain
Starting Member
India
8 Posts |
 Posted - 06/13/2007 : 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
Flowing Fount of Yak Knowledge
2111 Posts |
|
|
rmiao
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 06/13/2007 : 10:56:16
|
| Did you specify correct instance name? Which netlib did you use to connect to sql2k? |
 |
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 06/13/2007 : 11:00:55
|
are you running the latest sql server service packs? sp2a for SQL 2K5 and SP4 for SQL2K?
-ec |
|
|
|
anchaljain
Starting Member
India
8 Posts |
Posted - 06/14/2007 : 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. |
|
|
|
harsh_athalye
Flowing Fount of Yak Knowledge
India
5509 Posts |
Posted - 06/14/2007 : 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" |
|
|
|
anchaljain
Starting Member
India
8 Posts |
Posted - 06/14/2007 : 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
Flowing Fount of Yak Knowledge
India
5509 Posts |
Posted - 06/14/2007 : 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" |
|
|
|
anchaljain
Starting Member
India
8 Posts |
Posted - 06/14/2007 : 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
Flowing Fount of Yak Knowledge
USA
7266 Posts |
Posted - 06/14/2007 : 13:29:08
|
| Those instances have to use different port. |
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 06/14/2007 : 13:31:57
|
| what service pack have you installed for SQL 2K? |
|
|
| |
Topic |
|
Issues - SQL 2K and SQL 2K5 on same box
