<div>
make sure the login credentials exists in the server.
</div>


make sure the login credentials exists in the server.

<div>
Ashilo, &nbsp;logins are there, it is sql login.
</div>


Ashilo,  logins are there, it is sql login.

<div>
Thanks Ashilo, <br />
Is it same for <br />
<br />
Error:18456, Severity: -1, State: -1 <br />
<br />
?
</div>


Thanks Ashilo,
Is it same for

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

?

<div>
where do you get this error the number make no sense
</div>


where do you get this error the number make no sense

<div>
It's SQL Server 2000, right?<br />
<br />

<pre><code id="code-8145325">USE master
GO
--change &lt;login&gt; to your valid login, e.g. 'sql_user'
SELECT loginname, denylogin, hasaccess FROM syslogins
WHERE loginname='&lt;login&gt;'</code></pre>
</div>


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>'

<div>
<div class="content wysiwyg-content">
Hi All, I'm getting this error when I try to login to server<br />
<br />
{error} STATE=28000, CODE=18456, MSG=[Informatica][ODBC SQL Server Driver][SQL Server]Error: 18456, Severity: -1, State: -1<br />
<br />
Can some one plz tell me what does this error mean and any idea on how to resolve it?<br />
Thanks!<br />

</div>
</div>


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!


Error while trying to login to server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.