I have the following configuration:
- Windows Vista Home Premium SP2 host with SQL Server 2008 Express SP1 and SQL Server Management Studio.
- Virtual Machine 2007 with Windows Vista Ultimate, Visual Studio 2008 Express, and Visual Studio 2010 Beta 1.
With Service Pack 1 on the host computer and before installing Vista SP2 and SQL Server SP1, I can connect to the SQLEXPRESS instance from Visual Studio 2008 and 2010 from a virtual machine. Now I can’t.
The instance is configured to allow remote connections. Both machines, physical and virtual, can see each other on the network and respond to ping. The SQL Server Browser service is running and all protocols are enabled in SQL Server Configuration Manager.
I tried reinstalling SQL Server but cannot connect. In the Server name drop-down list in VS, now I can see only MACHINENAME, where I saw MACHINENAME \ SQLEXPRESS, and when I try to connect, I get the message:
A network-related or specific instance error occurred while establishing a connection to SQL Server. The server was not found or was not available. Verify the instance name is correct and configure SQL Server to connect remotely. (provider: SQL network interfaces, error: 26 - server / instance location error)
I don’t know what I am missing. Has anyone experienced this problem?
change
, , , . SO. Browser SQL Server . - 0, . UDP 1434.
- IIS . .