Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kjeld-jensen
Starting Member
2 Posts |
 Posted - 2011-01-28 : 03:38:43
|
| I am using Visual Studio 2010 and in Server Explorer I want to add a new connection to a SQL Server 2008 R2 named instance, which is not on the same PC. In the field "server name" I typed <IP Adress>\<Instance name> (IP Adress without port). I tryed both Windows authentification and SQL Server authentification, but it didn't work, I'm getting error message "provider: Named Pipes Provider, error: 40 - Connection to SQL Server could not be opened". Can you help me solving this problem? I tryed already a lot, including instructions under http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx . |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-01-28 : 03:45:39
|
What is the port number the SQL Server is listening to ?Is the SQL Server behind a firewall ? Is the pot number block by the firewall ?Is the TCP/IP protocol enabled on the SQL Server ?
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
kjeld-jensen
Starting Member
2 Posts |
Posted - 2011-01-28 : 04:38:02
|
quote:
Originally posted by khtan
What is the port number the SQL Server is listening to ?Is the SQL Server behind a firewall ? Is the pot number block by the firewall ?Is the TCP/IP protocol enabled on the SQL Server ?
KH[spoiler]Time is always against us[/spoiler]
The Port number the sql server ist listening to is 1434. I checked this sucessfully using the tool PortQry.The Port number isn't blocked by the firewall, I added an exception.TCP/IP protocol is enabled for concerning SQL Server instance. |
|
|
|
|
|
|
Remote Access from Visual Studio to SQL Server