Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Cannot access a database in SQL Server 2012 VM

Answered Cannot access a database in SQL Server 2012 VM

  • Thursday, October 04, 2012 2:03 AM
     
     
    Sign In to Vote
    0

    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.

    Any ideas?

    Cheers,

    Walter

     

All Replies

  • Thursday, October 04, 2012 3:38 AM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hello,

    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.

    Regards,
    Alberto Morillo
    SQLCoffee.com