June 10, 2013 at 8:22 am
Hi,
I have a PC running windows 8 and SQL server 2008 R2 express and a virtual machine with Windows XP. I cannot connect from virtual machine to SQL Server.
What I have done:
1) Allow remote connections on SQL Server o host machine.
2) Enable TCP on sql configuration manager on host machine
3) Create an inbound rule in Windows Firewall in Host machine to allow connections through port 1433 ( default port used for SQL server)
4) Set a Bridged nertwork connection on virtual machine.
When I set the firewall off ( for private networks ) I can connect to SQL server , I can see the databases , but I cannot access them. When I use the SQL Server Management Studio from the virtual machine I can connect to the server and I see the databases but when I try to open one of them to see the tables I get the following message:
The database ERP_DB is not accessible. (ObjectExplorer)
When the firewall is on I cannot even connect to SQL server on host.
and I get the following message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
I would be grateful if someone could help me.
Thank you very much.
June 11, 2013 at 12:51 am
Take a look at http://msdn.microsoft.com/en-us/library/cc646023.aspx for the required firewall settings.
The error message "database is not accessible" seems a SQL-related error. Does your account have all the needed rights on the database? Do you get the same error when connecting to the database with the 'sa' account?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply