• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 407
  • Last Modified:

Error while trying to login to server

Hi All, I'm getting this error when I try to login to server

{error} STATE=28000, CODE=18456, MSG=[Informatica][ODBC SQL Server Driver][SQL Server]Error: 18456, Severity: -1, State: -1

Can some one plz tell me what does this error mean and any idea on how to resolve it?
Thanks!
0
msdba
Asked:
msdba
  • 3
  • 3
  • 2
2 Solutions
 
Aaron ShiloCommented:
make sure the login credentials exists in the server.
0
 
msdbaAuthor Commented:
Ashilo,  logins are there, it is sql login.
0
 
Aaron ShiloCommented:
well

Error: 18456, Severity:14, State: 11.

this means that there is no valid login in the server.

i would try to drop and recreate the login.

for the test give it full privileges like SYSADMIN and test it.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
msdbaAuthor Commented:
Thanks Ashilo,
Is it same for

Error:18456, Severity: -1, State: -1

?
0
 
Aaron ShiloCommented:
where do you get this error the number make no sense
0
 
Daniel_PLDB Expert/ArchitectCommented:
Hi,
Dear all Error:18456, Severity:14, State:11 (and 12 also) means that login is valid but server access failure.
So it seems your login is disabled or has deny connect on server, check it's server wide permissions by running following code:

--change <login> to your valid login, e.g. 'sql_user'
SELECT sp.name, sp.type_desc, sp.is_disabled, sp.modify_date, spp.permission_name,spp.state_desc FROM sys.server_principals sp 
JOIN sys.server_permissions spp ON sp.principal_id = spp.grantee_principal_id 
WHERE sp.name = '<login>'

Open in new window

0
 
Daniel_PLDB Expert/ArchitectCommented:
It's SQL Server 2000, right?

USE master
GO
--change <login> to your valid login, e.g. 'sql_user'
SELECT loginname, denylogin, hasaccess FROM syslogins
WHERE loginname='<login>'

Open in new window

0
 
msdbaAuthor Commented:
Thanks!
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now