Re: Error 18456

Thanks for the help.....
We detached a database in order to copy the files. When I detached the
database it seemed to lock all users with access to that database out any
access to this SQL2005 server.

I was able to use SQLCMD to gain access and rebuild access for my database
admin account. I was then able to use this account to reattach the detached
database. When I did this the database and all user access to SQL2005 was
back to normal. I am not sure why this happened. We have about ten other
databases on this SQL server. The same users had access to these tables as
well as the detached table so the detached table was not the only table for
which they had access. The detached table was just a table of 'production'
data. I will try and see if I can recreate the problem but will wait for
the weekend to try that!
Thanks


"JimS" <noholycowsspam@xxxxxxxxxxxxxxxxx> wrote in message
news:%23EnC0mJSGHA.1576@xxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: ADP/SQL Server 2000 Security Problem
    ... The server is running Windows 2003. ... I'll also test using a SQL Server account and see what happens. ... it worked in MSDE 2000. ... I have not created any new accounts for the production database. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help with WSS 3.0 Server Farm Config - Backend SQL 2005
    ... I had to use only "sharepoint" to get the ... What interest me though is that the database get created but fails after ... Virtual Server with DBSVR ... an account local to the WEBSVR) to create and access the SQL server, ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Restored Server but SharePoint refusing admin access
    ... > SID/BID or remove the user from the database and add it again. ... >, In SQL Configuration Manager go to SQL> Server ... > you had) you cannot access the database from that account. ... > newly added administrator account (for me, since I added a new admin ...
    (microsoft.public.windows.server.sbs)
  • Re: Keep getting this error when trying to use Web Parts in VS2005 Beta 2. Why?
    ... > setup another database. ... >> operation or the server is not responding. ... This is necessary because the web server account will ... >> This is necessary because the web server account will attempt to ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Single Sign On Database Connection Issues
    ... SSOSrv, I'm having difficulty on the "Manage Server Settings for Single ... to define the necessary database. ... So after assigning the appropriate security to the user account, ...
    (microsoft.public.sharepoint.portalserver)