Monday, February 25, 2013 6:43 PM
Windows server 2008 R2 (64 bit)
SQL Server 2012 running on the same box.
SSMA for access.
Connect to SQL server cannot find any instances.
It seems obvious that any instance would be detectable to this SSMA.
Does it require an SQL server native client?
MS Server Management Studio 2012 can open the local instance.
Monday, February 25, 2013 8:37 PMModerator
Please make sure you have enable TCP/IP and Named Pipes on the SQL Server instance. Use the following article to enable these protocols:
Configure Windows Firewall for SQL Server access or disable it.
- Proposed As Answer by vr.babu Thursday, March 07, 2013 3:30 AM
Tuesday, February 26, 2013 3:53 PM
Thanks for your reply Alberto,
The named Pipes was disabled so I enabled this feature and restarted the server. This did not help.
I opened up the windows firewall for port 1433 on this computer. This did not help.
I use SSMA with pretty well the same configuration on a Windows 7 - 64bit development box and there is no problem.
Both environments use the BI version of SQL Server 2012 with the exception that the Windows 7 box was an update from SQL Server 2008R2 and the Windows 2008 server box was installed from scratch.
As I said previously, there is no issue connecting to this SQL Server with Management Studio of the Web Site on the same WS2008 box which uses it currently.