Problem with login.asp

[ahmadrashid]

My asp login page is displaying this error....

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

--------------------------------------------------------------------------------

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

--------------------------------------------------------------------------------
Can someone assist me.

[Ocean10000]

Have you applied a service pack or installed a firewall in front of or on the SQL Server machine? What version of SQL Server are you running against? Is this production or development environment?

My first guess is named pipes are turned off or access to them are being blocked but without more information its my best guess.

FYI a little bit of advice.
Never use SA user login for a production or development website to use to access the database. It is an administrative account and should only be used for administrative purposes. Create a standard user account and grant it the proper rights to access your db. This will help protect you later on down the road if your site ever gets hacked they will not be able to do as much damage to other databases hosted on the same sql server.

[ahmadrashid]

Thanks alot.. I changed the user. but now its displaying this error

-----------------
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
-----------------

[ahmadrashid]

Its solved.... SQL Server was off.

thanks alot for quick assistance