By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,377 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,377 IT Pros & Developers. It's quick & easy.

SQL Server Connectivity

P: 4
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
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
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

P: 4
@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
Expert 2.5K+
P: 2,878
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.