Thanks Mark,

I had it set to allow Remote connections for both TCP/IP and Named Pipes. It was the XP Firewall needing the 1433 port allowed.

>I believe the default for SQL Server 2005 express is to allow local connections only. You can enable Remote Connections under programs>>Microsoft SQL Server 2005>>Configuration Tools>>SQL Server Surface Area Configuration.
>
>You might also make sure the Windows firewall is not blocking the port.
>
>
>
>>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.