Win XP and SQL Server 2005
I have following settings:
1)SQL Server Service is running under local system
2)Protocols for MSSQLServer
Shared memory enabled
Named Pipes enabled
TCP/IP enabled
via disabled
SQL Native Client Configuration
Client Protocols
Shared Memory enabled
TCP/IP enabled
Named Pipes enabled
VIA enabled
3)Firewall is enabled
4)Exceptions to windows firewall
Add Program SqlServr.exe(MSSQL.1)
Add Program SqlServr.exe(MSSQL.3)
Add Port Sql server TCP/IP 1433
Add Port SQL server Browser UDP 1434
I tried two different Connecting strings in code to access database from remote machine, both are failing
L"Provider=SQLOLEDB.1;Data Source=XXX.XXX.X.X,1433;Network Library=DBMSSOCN;Initial Catalog=Test;User ID=sa;Password=XXXXXX;"
OpenFromInitializationString(L"Provider=SQLOLEDB.1;Integrated Security=SSPI;User Id=sa;Password=XXXXXX;Persist Security Info=False;Initial Catalog=Test;Data Source=XXX.XXX.X.X;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False");
What am I missing?
I have following settings:
1)SQL Server Service is running under local system
2)Protocols for MSSQLServer
Shared memory enabled
Named Pipes enabled
TCP/IP enabled
via disabled
SQL Native Client Configuration
Client Protocols
Shared Memory enabled
TCP/IP enabled
Named Pipes enabled
VIA enabled
3)Firewall is enabled
4)Exceptions to windows firewall
Add Program SqlServr.exe(MSSQL.1)
Add Program SqlServr.exe(MSSQL.3)
Add Port Sql server TCP/IP 1433
Add Port SQL server Browser UDP 1434
I tried two different Connecting strings in code to access database from remote machine, both are failing
L"Provider=SQLOLEDB.1;Data Source=XXX.XXX.X.X,1433;Network Library=DBMSSOCN;Initial Catalog=Test;User ID=sa;Password=XXXXXX;"
OpenFromInitializationString(L"Provider=SQLOLEDB.1;Integrated Security=SSPI;User Id=sa;Password=XXXXXX;Persist Security Info=False;Initial Catalog=Test;Data Source=XXX.XXX.X.X;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with column collation when possible=False");
What am I missing?