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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only