Re: Connecting to wrong SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

ok, since I changed the port number to the port number msde2000 uses everything works fine. Apparently if you add the port number the name of the
sqlserver/instance doesn't seem to matter.

Tosch

On Thu, 15 Jun 2006 08:05:26 -0700, "Rick Byham [MS]" <rickbyh@xxxxxxxxxxxxxxxxxxxx> wrote:

It looks like you are always connecting to the default port. Try starting
the SQL Server Browser Service on MyMachine. It is the browser service that
resolves the name to the correct port.

.

Relevant Pages

  • Re: Named Instance Connectivity SQL 2008/2000 Same box
    ... Allowing the remote connections is not your problems since you can connect using the port number. ... why care about the browser service when you can use the port number? ... Tibor Karaszi, SQL Server MVP ... Enterprise Manager and Quesry Analyzer won't work with 2005 and up. ...
    (microsoft.public.sqlserver.server)
  • Re: sql browser on active/active cluster
    ... Did you check if UDP port 1434 was already claimed by some other process? ... say the browser service is local and not part of the cluster install then ... If i try and start the sql browser service on ... SQLBrowser: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Server not appearing in Network Places
    ... See the link below on how to troubleshoot the browser service including how ... If a computer does not show up verify that netbios over tcp/ip is enabled on ... it and use the command net config server to see if it is configured to be ... Netbios over tcp/ip naming uses port 137 udp ...
    (microsoft.public.cert.exam.mcse)
  • Re: SQL Connection in Workgroup
    ... I will try and open UDP port 1434 ... Where can I get the SQL Server Client connectivity? ... SQL Server Browser Service on the XP computer uses UDP port 1434 to send ... but you might want to install the SQL Server 2005 client ...
    (microsoft.public.sqlserver.connect)
  • Re: Linksys port forwarding question
    ... > in the correct address and port number. ... > effect pinging the router unless you have a machine set up in the DMZ. ... >> and other servers sitting behind my router. ... And it works perfectly using the correct port and using the ...
    (comp.os.linux.networking)