Is it possible for ASP to connect to SQL Server via ODBC without a password

[EricBCA]

Hi there,
I've just started in a new company, and on the intranet every time an ASP page connects to SQL Server, it does so through ODBC. Problem is, it always uses the SA password.
Now, I was thinking of changing it from SA to a new account with far fewer permissions. But, is there a way for the ODBC to connect without a password? Can it be authenticated by coming from the intranet or something?

Eric

 

[ChrisHirst]

Set access for that user ID to be from localhost only, or the IP of the server that the script runs on if they are not on the same machine.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum