Error 18456
- From: "JimS" <noholycowsspam@xxxxxxxxxxxxxxxxx>
- Date: Wed, 15 Mar 2006 19:34:00 -0600
Hello I am getting:
"login failed" (Error 18456) error messages in SQL Server 2005 Error is
18456, Severity: 14, State: 8.
I have tried to logon to other databases and this isnt possible. I get the
same error message. Creating new logins, and triple-checking the passwords
did not help. The database engine will not allow any logons to any
database. The other engines seem to be fine.
This still means that I do not have permissions for any of the databases.
This is using any of the local or domain accounts. I cannot log onto any of
the databases. I have tried to attach using SQLCMD and I cannot get logged
in to the database.
The log files show success from earlier in the day and week for these same
accounts.
I created this problem by detaching one database running on the server. I
went to connect the datafiles and now I cannot get into the server at all.
I am using SQL2005, Sharepoint services and a Windows 2003 server.
I would appreciate any insight or suggestions.
.
- Follow-Ups:
- Re: Error 18456
- From: JimS
- Re: Error 18456
- From: Sue Hoegemeier
- Re: Error 18456
- Prev by Date: Add user to R\O Database
- Next by Date: Re: Linked Server Problems with all providers
- Previous by thread: Add user to R\O Database
- Next by thread: Re: Error 18456
- Index(es):
Relevant Pages
|
|
