Well I got it working if I change from the default TCP/IP to using Named Pipes. The string that worked is:
DRIVER=SQL SERVER;SERVER=\\SAMAAN3\SQLEXPRESS;Trusted_Connection=Yes;Address=\\SAMAAN3\pipe\MSSQL$SQLEXPRESS\sql\query;APP=Microsoft Data Access Components;WSID=SAMAAN5;DATABASE=mist2006;
So I basically added in the Address=\\SAMAAN3...
Assuming TCP/IP is going to be the default connection type on most servers I would love to get it to work on that. Any ideas?
Thanks.
>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.