Hi,
I've been using a connection string to access an SQL Server database that is running on the same PC that I have been developing on. I am now trying to ensure that I know how to configure remote PCs to access the database running on this PC and am having some difficulty.
My connection string is this:
DRIVER=SQL SERVER;SERVER=SAMAAN3\SQLEXPRESS;Trusted_Connection=Yes;APP=Microsoft Data Access Components;WSID=SAMAAN3;DATABASE=mist2006;
When I try from a remote PC, I change the WSID of the string to SAMAAN5 (as that is the PC name on the network), but that doesn't work.
So I tried using the ODBC applet to create and test a User DSN, but I get an error like this when trying to test the connection:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access is denied
Is there some access configuration that I need to do on SQL Server to allow access from a remote PC?
I've got Shared Memory, Named Pipes and TCP/IP Enabled and Via disabled.
Or any ideas what else I need to do?
Thanks.