sql server error 18456, login failed for USER 'NTA

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

sql server error 18456, login failed for USER 'NTA

Author

Topic

sanjay kumar
Starting Member

7 Posts

Posted - 2011-05-29 : 03:41:53

Hi Folks,

1.sql server error 258, unable to complete login process due to delay in login response,[ SQL STATE 08001].

2.sql server error 4060, cannot open database '--'requested by login. The failed login [SQL STATE 42000]

3.sql server error 18456, login failed for USER 'NTAUTHORITY\SYSTEM'. [SQL STATE 28000]

Am facing the problem from yesterday plz. help me to fix this issue am in a critical position to fix this issue.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-29 : 05:46:12

The default database for that login is either not there, not online or the login has no permission to it.

--
Gail Shaw
SQL Server MVP

sanjay kumar
Starting Member

7 Posts

Posted - 2011-05-29 : 10:33:36

Hi Gail,

Thanks to see your reply..

But, the logins are there for the database, and they are having the appropriate permissions.

i tried to route cause this issue and i came across several observations like
1. Checked whether Builtin\Adminstrator account is there or not. i've seen the Builtin\Adminstrator Account.
2. TCP/IP connections are enabled.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-29 : 11:52:16

The second error message can only mean one of the three things I've said.

--
Gail Shaw
SQL Server MVP

sanjay kumar
Starting Member

7 Posts

Posted - 2011-05-30 : 00:59:13

Hi Gail,

There is login for the default database and having the appropriate permissions.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources