I had similar issue, when I unistalled the SQL which had a Named Instance and Installed SQL with Default Instance.
The Error I got is:
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)
To resolve the issue - I had to change the VSTS Options; From Tools -> Options -> Data base Tools -> Design Time - Validation Data base -> Connection Options -> SQL Serevr Instance Name = Blank.
sivaram_ram
Member
2 Points
1 Post
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Feb 13, 2009 10:03 AM|LINK
I had similar issue, when I unistalled the SQL which had a Named Instance and Installed SQL with Default Instance.
The Error I got is:
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)
To resolve the issue - I had to change the VSTS Options; From Tools -> Options -> Data base Tools -> Design Time - Validation Data base -> Connection Options -> SQL Serevr Instance Name = Blank.
Hope this info will be helpful for some people.
VSTS 2008 Data base Projects