469,946 Members | 1,784 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,946 developers. It's quick & easy.

SQL Server Connectivity

Hi I am using SQL Server 2005.

I tried to connect to the database stored at a remote server by c# with the following connection string :

"Data Source='server1';Initial Catalog='dataBase';Integrated Security='True'; Uid='user1'; Pwd='secret'"

I couldnt succedded unless I had to set the server's firewall off.. So I wanted to ask does it really make difference or there is any problem in the way I am trying to connect to the SQL server database.
Feb 11 '08 #1
3 963
ck9663
2,878 Expert 2GB
Hi I am using SQL Server 2005.

I tried to connect to the database stored at a remote server by c# with the following connection string :

"Data Source='server1';Initial Catalog='dataBase';Integrated Security='True'; Uid='user1'; Pwd='secret'"

I couldnt succedded unless I had to set the server's firewall off.. So I wanted to ask does it really make difference or there is any problem in the way I am trying to connect to the SQL server database.

firewall is what's blocking you, then. though it's related, i believe that's outside SQL Server.

-- ck
Feb 11 '08 #2
@CK
Yes The SQl server is located on the different machine, so is it right to turn off the firewall before you make the connection to a remote server to access SQL Server database ?
Feb 11 '08 #3
ck9663
2,878 Expert 2GB
it would depend on your infrastructure and your application. if this is an internal application, there might be less risk compare with an external application. you might also need to consult with your IT department regarding some security policy.

-- ck
Feb 11 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Todd Brewer | last post: by
reply views Thread by Gr8Ongole | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.