"Data Source=<IP>,1433;Network Library=DBMSSOCN;Initial Catalog=<dbname>;User ID=sa;Password=<pwd>;"
i use that to connect to the remote SQL server, which has status of port 1433 at "Stealth"... do i need to open the port complete, if yes how i do that ?
does the SQL Server must use SQL authentication ?
Your help is greatly appreciated.Try this:
server=<ip>;uid=sa;pwd=<pwd>;database=<dbname
Remove everything else from the connection string.|||thnx, btw, do i need to add the port # after the IP ?|||yes, if it is not default (not 1433)
if it is 1433, there is no need to specify it
