ssma cannot find sql server instances

Question

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.

Answer 1

Hello,

Please make sure you have enable TCP/IP and Named Pipes on the SQL Server instance. Use the following article to enable these protocols:

http://msdn.microsoft.com/en-us/library/ms191294.aspx

Configure Windows Firewall for SQL Server access or disable it.

http://msdn.microsoft.com/en-us/library/cc646023(v=sql.105).aspx

The following post may be useful to migrate from Microsoft Access to SQL Server using SSMA:

http://blogs.msdn.com/b/ssma/archive/2011/01/28/access-to-sql-server-migration-how-to-use-ssma.aspx  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

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.

RobGMiller..