I have sql server 2005 and 2008 running on a server on my local (and very straightforward) network. Using sql management studio 2008 and visual studio 2008, I can connect over the network to the 2005 instance which is the default instance. I can't connect to the 08 instance (named MC08). I can connect to both when logged in to the server. Remote connections have been enabled for MC08 and dynamic ports is turned off (assigned to port 1045). The sql browser service is running as well. This used to work so I'm not sure what has changed. I can't connect using the IP address either. Nothing unusual in the event log either. Any ideas?
Windows – Can’t connect to sql server 2008 named instance
networkingsql serversql-server-2008windows
Related Topic
- Sql-server – SQL Server 2008 Management Studio Cannot Connect to Server Instance
- Sql-server – Can’t connect to Sql Server 2008 named instance
- Can’t connect to a remote SQL server 2008 instance
- Sql-server – SQL 2008 SSMS cannot connect to local default instance. Error 87
- Sql-server – Can’t connect to named SQL Server 2008 R2 instance remotely
- SQL Server 2008 R2 – Resolving Named Instance Connectivity Issues
Best Answer
Have you tried
your.sql.server.fqdn\MC08
.The port specification in SSMS is totally braindead though. For whatever reason they decided to use comma(
,
) as host and port delimeter instead of colon(:
). So if you want to use a port number use this connection string:your.sql.server.fqdn,1045
.