Connect to SQL server using the internet
what is the Connection string for SQL Server 2008 over the internet using ip address.
I had used the below string:
"Provider=SQLOLEDB.1;Persist Security Info=False;Data Source = XXx.xxx.xxx.xxx,1433;Network Library=DBMSSOCN;Initial Catalog=xxxx;User Id=xxxxxx; Password=xxxxx;"
It gives me error does not exist or access denied.
2 answers
Is the firewall open for connections on that port (1433) ?
Following are enabled and running.
- 1433 port enabled and working (inbound rule setting is done)
- SQL browser running (firewall setting enabled)