SQL Server Connectivity

[dpksinghal]

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='dataBa se';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.

[ck9663]

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='dataBa se';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

[dpksinghal]

@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 ?

[ck9663]

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