Thursday, October 04, 2012 2:03 AM
I have installed MS SQL Server 2012 into a Windows 2008 R2 64bit VMware VM and created a new database called "Pensions" by exporting, then importing it from my local PC's MS SQL Server 2008 database. I can connect to the VM's SQL Pensions database using the MS Management Studio (2008 on my PC), but when I use MS Excel (for example), I can only see the "master", "msdb" and "tempdb" databases (which are under "System Databases", but "Pensions" is not).
So far, I have followed the instructions in http://social.technet.microsoft.com/wiki/contents/articles/2102.how-to-troubleshoot-connecting-to-the-sql-server-database-engine.aspx and have opened ports 135, 1433, 1434 and 49182 (the latter allowed TCP connection, the others did nothing noticeable) on the firewall of the VM's Server. The SQL Server 2012 connection settings allow for remote connections. Not sure what else to do to enable me to "see" the "Pensions" database.
Thursday, October 04, 2012 3:38 AMModerator
Please try to create an ODBC DSN and test it. Then use it to access data of the SQL Server instance from an Excel worksheet.
Disable Windows Firewall on the virtual machine since it exists on your computer only.
Hope this helps.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Monday, October 15, 2012 10:20 AM