Currently i'm running visual studio 2010 and I'm having problems keeping my data connections alive.
After I've launched VS, I can create a data connection to my SQL server. I see all tables and everything works great.
When I close VS, and launch it again, the connection is still visible, but broken (red cross). I'm not able to retreive any table info.
After I delete the connection, I'm not able to recreate the connection again. I have to wait some time or reboot my machine.
It's very unpleasant to recreate the connection again everytime I close VS.
After I've launched VS, I can create a data connection to my SQL server. I see all tables and everything works great.
When I close VS, and launch it again, the connection is still visible, but broken (red cross).
Thanks for your feedback. Unfortunately this doesn't work. An message pops up:
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:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I also tried disabling my firewall on my local machine and on the remote server. This doesn't seem to work. However, a Telnet session can be created successfully.
I really want to solve this. It's driving me nuts.
tmelis
Member
3 Points
10 Posts
Problem keeping data connection in server explorer alive...
Dec 06, 2012 11:57 AM|LINK
Hi,
Currently i'm running visual studio 2010 and I'm having problems keeping my data connections alive.
After I've launched VS, I can create a data connection to my SQL server. I see all tables and everything works great.
When I close VS, and launch it again, the connection is still visible, but broken (red cross). I'm not able to retreive any table info.
After I delete the connection, I'm not able to recreate the connection again. I have to wait some time or reboot my machine.
It's very unpleasant to recreate the connection again everytime I close VS.
Does anyone know how i can fix this issue?
Thanx
Rajneesh Ver...
All-Star
36815 Points
6757 Posts
Re: Problem keeping data connection in server explorer alive...
Dec 06, 2012 12:44 PM|LINK
You have to right Click on this and Connect.
www.rajneeshverma.com
Keep Forums Clean || Use Alert Moderators.
tmelis
Member
3 Points
10 Posts
Re: Problem keeping data connection in server explorer alive...
Dec 07, 2012 09:27 AM|LINK
Hi,
Thanks for your feedback. Unfortunately this doesn't work. An message pops up:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I also tried disabling my firewall on my local machine and on the remote server. This doesn't seem to work. However, a Telnet session can be created successfully.
I really want to solve this. It's driving me nuts.
Angie xu - M...
All-Star
18045 Points
1550 Posts
Microsoft
Re: Problem keeping data connection in server explorer alive...
Dec 12, 2012 11:53 AM|LINK
Hi tmelis
You could have a try, and check whether helpful to solve this problem,
SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)
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/
Kind regards
Feedback to us
Develop and promote your apps in Windows Store