I installed Northwind.dbo and have it connected to MS Management Studio 2008. I then established a connection to a web project in VS. Data is being returned in VS but when I view the data in the browser I get the error:
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)
I installed Northwind.dbo and have it connected to MS Management Studio 2008. I then established a connection to a web project in VS. Data is being returned in VS but when I view the data in the browser I get the error:
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)
Any suggestions what I should try to fix this.
Many thanks.
Plz try to create a connection in the VS's server explorer, and then copy the connection string from the property panel, That should be OK!!!!!!!!!!!
gotroots
Member
478 Points
277 Posts
Connected to server but data not being returned to webpage
Jan 10, 2012 09:25 AM|LINK
Hi
I installed Northwind.dbo and have it connected to MS Management Studio 2008. I then established a connection to a web project in VS. Data is being returned in VS but when I view the data in the browser I get the error:
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)
Any suggestions what I should try to fix this.
Many thanks.
sudhalaksh
Participant
815 Points
176 Posts
Re: Connected to server but data not being returned to webpage
Jan 10, 2012 09:54 AM|LINK
Hi Friend,
Please check the below site:
http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/
Thanks.
Chen Yu - MS...
All-Star
21825 Points
2513 Posts
Microsoft
Re: Connected to server but data not being returned to webpage
Jan 16, 2012 06:30 AM|LINK
Hi gotroots,
I found this blog which is talking about this issue.
Please see:http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx
Thanks.
Feedback to us
Develop and promote your apps in Windows Store
TimoYang
Contributor
3732 Points
1275 Posts
Re: Connected to server but data not being returned to webpage
Jan 16, 2012 07:34 AM|LINK
Plz try to create a connection in the VS's server explorer, and then copy the connection string from the property panel, That should be OK!!!!!!!!!!!
gotroots
Member
478 Points
277 Posts
Re: Connected to server but data not being returned to webpage
Jan 16, 2012 08:25 PM|LINK
Thank you for the link, it will be useful to have this information when i attempt to fix this problem again.