SQL Server Performance Forum – Threads Archive

Connection Problem !

Hi, I had sql server 2000 client installed. At the same time had sql server 2005 express installed on the same machine. It was workin well nd fine. Later I upgraded the client version of 2000 to server (as named instance). I can connect to both my instances locally but am not able to connect to the 2000 named instance through the network. Tried many things like changing the settings, installing sp3 and all but in vain. Please help me out ! Thanks in Advance Santhosh

are u getting any error messages.if so what is it? You have to enable Remote connections from SQL Server surface area configuration —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Remote connection is enabled and it is listening over TCP/IP. The error message is as given below(It’s the normal error message).
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

http://support.microsoft.com/kb/914277 —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Try specifying the portnumber in your connection… Servername,portnumber
OR
SERVERNAMEINSTANCENAME,PORTNUMBER
MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided â€œAS ISâ€ with no warranties for accuracy.

Hey Thanks !<br /><br />The port number did the trick. Was plannin for a new installation of both sql server 2000 and 2005.<br /><br />Thanks a lot. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />]

]]>