Tuesday, February 10, 2009

How to connect SQL via Internet

How to connect SQL via Internet

Open SQL server 2005 ---configration Maneger – sql server 2005 Surface Area configuration ------ double click  surface Area Configration for services & connection

Click on DATABASE & Remote Connections  select Local & remote Connections  Apply & ok

How to Connect sql server on different port servername,port number exp.(74.76.154.7\MSSQL2K5WG,8486)

How to change MSSQL port

Open SQL server configration maneger go to sql server network configration server click on server right side TCP IP properties

& change dydnamic port & TCP IP port & change Alies New port also

 
 

0 comments:

Post a Comment