Login Failed: Error 18456: Unable to login to run SP on local serv

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Don't know if this is the correct newsgroup. If not then I apologize in
advance.

New installation of SQL Server on local machine. All permissions to access
tables and execute stored procedures provided. Changed and reset password.
Same errors experienced with accounts other than sa. All permissions granted.

Calling SP from ASP page on same machine.

Here is the error I'm experiencing and retrieved:

"Source: .Net SqlClient Data Provider
Number: 18456
State: 1
Class: 14
Server:
Message: Login failed for user 'sa'.
Procedure:
Line: 0"

What am I missing/
 
have you tried running a string sql from your asp, instead of a stored
procedure.

login failed for 'sa' , the reason for this is that the supplied password
for user sa is incorrect.

also the correct newsgroup for your question is
"microsoft.public.sqlserver.server"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Login failed for user '(null)' 5
Connection issues between .Net framwok and SQl Express 2005 12
Getting SQL error on sp but still runs 2
"Failed to access IIS metabase" on XP 5
SQL logon: aspx fails, winform ok 1
Login failed for user ''. The user is not associated with a trusted SQL Server connection. 4
Error Number : 29521 Installing BcmBeta2TR.exe 4
ConnectionString For SQL Server 2005? 3

Back
Top