I have a remote SQL Sever 2008 DB which works flawlessly when using
Management Studio. However, whenever I try to reach the DB from a C#
app developed on Visual Studio 2008, I get "40 =96 could not open a
connection to SQL server" or something similar.
I guess it has nothing to do with the connection to the server, since
port 1433 is open on the server, and I can access the data, and
perform any operarion with it, using Management Studio. Is there any
other thing I should try?
Thanks is advance
|
|
0
|
|
|
|
Reply
|
jman0
|
11/23/2009 8:20:05 AM |
|
http://blogs.msdn.com/sql_protocols/archive/2006/09/30/SQL-Server-2005-Remote-Connectivity-Issue-TroubleShooting.aspx
"jman0" <jman0@zapo.net> wrote in message
news:80b01e8b-3dd2-43c6-b7b2-9a0aa9193d5d@e20g2000vbb.googlegroups.com...
I have a remote SQL Sever 2008 DB which works flawlessly when using
Management Studio. However, whenever I try to reach the DB from a C#
app developed on Visual Studio 2008, I get "40 � could not open a
connection to SQL server" or something similar.
I guess it has nothing to do with the connection to the server, since
port 1433 is open on the server, and I can access the data, and
perform any operarion with it, using Management Studio. Is there any
other thing I should try?
Thanks is advance
|
|
0
|
|
|
|
Reply
|
Abba
|
11/23/2009 8:27:11 AM
|
|