[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