Versions des environnements
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement