Welcome to WebmasterWorld Guest from 3.226.251.205

Forum Moderators: ocean10000

Message Too Old, No Replies

Problem with login.asp

     
9:26 am on Dec 30, 2007 (gmt 0)

New User

10+ Year Member

joined:Dec 25, 2007
posts:4
votes: 0


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.

3:59 pm on Dec 30, 2007 (gmt 0)

Administrator

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month

joined:Jan 14, 2004
posts:864
votes: 3


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.

7:43 am on Dec 31, 2007 (gmt 0)

New User

10+ Year Member

joined:Dec 25, 2007
posts:4
votes: 0


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.
-----------------

7:45 am on Dec 31, 2007 (gmt 0)

New User

10+ Year Member

joined:Dec 25, 2007
posts:4
votes: 0


Its solved.... SQL Server was off.

thanks alot for quick assistance

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members