>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?
I haven't had a chance yet to play around with SQL Server Express but I imagine it's similar to SQL Server 2000. With the latter, broadly speaking you need to:
- configure SQL Server to allow remote connections via TCP/IP
- if the machine the DB server is running on is also running a firewall (e.g. XP, Server 2003) that firewall also needs to be configured to allow incoming connections. By default it's port 1433, but this can be changed at both ends for added security
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up