[thelist] 2 MS SQL (in ASP) Questions
Joshua Olson
joshua at waetech.com
Thu Jan 10 17:43:16 CST 2008
> -----Original Message-----
> From: L L
> Sent: Thursday, January 10, 2008 5:04 PM
>
> Hi,
> I'm working with MS SQL server 2000 and have installed it
> locally and imported a db to the local machine for local dev
> with ASP in IIS. I have the connection string used for the
> db on the remote server. Below is the current string - I've
> altered it to include 'localhost' and the name of the
> database, but it still is not connecting. The pages will
> connect when the string is altered back to map to the remote
> server. Any ideas as to what might be the culprit?
Hi L L,
I subscribed to MicrosoftR's SuperDuperGiveItAGuessC newsletter. Ok, so
what error is it giving? Make sure the local machine's SQL Server has
TCP/IP enabled (not just named pipes, for example) as well as Mixed or SQL
Authentication enabled. If only Integrated is enabled, this may not work as
expected. Finally, use "netstat -a -n" and ensure that port 1433 is
LISTENING.
Joshua
<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
http://www.waetech.com/
Phone: 706.210.0168
Fax: 413.812.4864
Private Enterprise Number: 28752
Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/
More information about the thelist
mailing list