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!
msdbaAsked:
Who is Participating?
 
Aaron ShiloChief Database ArchitectCommented:
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
 
Aaron ShiloChief Database ArchitectCommented:
make sure the login credentials exists in the server.
0
 
msdbaAuthor Commented:
Ashilo,  logins are there, it is sql login.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
msdbaAuthor Commented:
Thanks Ashilo,
Is it same for

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

?
0
 
Aaron ShiloChief Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.