remote connection error 26

I receive an error 26 "Error locating server/instance specified" when trying
to connect to a named instance of sql2005 through sql server mgmt studio (i
can connect locally just not from a remote pc). I can also connect via the
old query analyzer to the remote sql2005 server.
I have enabled remote connections in SQL on the server and my firewall is
allowing traffic through the port specified in the asconfig\msmdredir.ini
since I was able to telnet to it.
Also, the sqlbrowser service is running.
Any suggestions?
Are you using dynamic ports?
Start SQL Server Configuration Manager->Protocols for
XX->TCP/IP->Properties->IP Addresses->IPAll dynamic ports
If you are try specifying the dynamic port number in the Server Name fileld
like this:
<server>\sqlexpress,<portnumber>
in mgmt studio
"matt" wrote:

> I receive an error 26 "Error locating server/instance specified" when trying
> to connect to a named instance of sql2005 through sql server mgmt studio (i
> can connect locally just not from a remote pc). I can also connect via the
> old query analyzer to the remote sql2005 server.
> I have enabled remote connections in SQL on the server and my firewall is
> allowing traffic through the port specified in the asconfig\msmdredir.ini
> since I was able to telnet to it.
> Also, the sqlbrowser service is running.
> Any suggestions?
|||Thanks for your suggestion. Yes I tried appending the port number to the
server\instance with no success.
What I ended up doing was to create another instance of SQL 2005 as a test
and I was able to connect to that without any problems.
I have a suspicion that one of the recent MS updates (security and/or
MSXML6) may have wrecked my orignal instance somehow since I have seen a
similar posting (although for older patches) elsewhere on the web and I did
not have any problems until after this past set of updates.
"Axel" wrote:
[vbcol=seagreen]
> Are you using dynamic ports?
> Start SQL Server Configuration Manager->Protocols for
> XX->TCP/IP->Properties->IP Addresses->IPAll dynamic ports
> If you are try specifying the dynamic port number in the Server Name fileld
> like this:
> <server>\sqlexpress,<portnumber>
> in mgmt studio
>
> "matt" wrote: