May 17, 2011 at 6:43 am
Hi
I have installed 2 different SQLServer instance on a single box. One is SQL2008 Std Edition (Default Instance) and the another one is SQL2008 Ent Edition (server\instance)
My problem is when am trying to connect named instance from client side it's giving error server does'nt exist. But am able to connect Default instance. even i tried by adding alias name but still not able to connect
kindly help me out from this problem.
Regard,
Vinod K
May 17, 2011 at 7:01 am
You have to check whether SQLBrowser service is running and reachable from the client.
SQLBrowser uses UDP port 1434 IIRC, so you just have to check your firewall rules and include traffic from/to that port.
The default instance does not need SQLBrowser if it is set up to wait on the default port (1433), because clients already know where to attach.
Hope this helps
Gianluca
-- Gianluca Sartori
May 17, 2011 at 9:21 am
yourserver\instancename,port
check the second instance port
Default port is 1433 for default instance and 1434 is for browser service default service,change the second instance port restart the service and then try to connect
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 17, 2011 at 9:31 am
Syed Jahanzaib Bin hassan (5/17/2011)
yourserver\instancename,portcheck the second instance port
Default port is 1433 for default instance and 1434 is for browser service default service,change the second instance port restart the service and then try to connect
Could also work with yourserver,port.
However, this solves the problem just for the application(s) for which you change the connection string explicitly. If you solve it at firewall level, you do it just once.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply