ODBC error in sql connection - SQL Server Forums

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 2000 Forums

SQL Server Administration (2000)

ODBC error in sql connection

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-03 : 09:00:25

Prakash writes "Hello
I am facing a problem in connecting to my sql server.
Windows-2000 server SP2
SQL-2000

We log in to server using Microsoft ODBC.

Earliet we were successfully logging in,but since last 24hrs.
Our clients are not able to login.
Even from server User cant login using sql authentication..

Error is as follows:
Connection Failed:
SQL State : 28000
SQL Server Error:18452
[Microsoft][ODBC SQL Server Driver][SQL Server]login failed for user 'world'.Reason not associated with trusted SQL server Connection.

Please do help me I am unable to figure out where exactly we
are missing.

Thanks & Regards
Prakash"

chadmat
The Chadinator

1974 Posts

Posted - 2002-07-03 : 14:36:05

You are trying to use a SQL Server login, and it is expecting an NT login.

Make sure your server is in mixed security mode.

-Chad

Herriot
Starting Member

2 Posts

Posted - 2002-07-11 : 06:48:43

SQL Server 200 SP2
Windows 2000

We are having a very similar problem to Prakash and I have checked Chadmats solution to ensure we are running in mixed security mode - we are. We think that The SQL Sever Login is trying to log into NT but we have the Login set to "with SQL server authentication...".

Error is as follows:
Connection Failed:
SQL State : 28000
SQL Server Error:18456
[Microsoft][ODBC SQL Server Driver][SQL Server]login failed for user 'Glencoll\peterleswell'

As you can see this is very very close to Prakesh's problem the main difference being the SQL Server error: 18456 in our case and 18452 in Prakeshs'

When we OK on the error a SQL Server login screen then pops up. We have to uncheck the Trusted Connected check mark and remove the username from the Log-in box replacing it with 'sa'. After pressing OK there is no more problems.

I would appreciate any help you can give me. Thanks

Peter.

If you choked a smurf what colour would it turn?

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-07-11 : 15:02:11

Peter,

What application are you using that is trying to login to the SQL Server? SQL Query Analyzer? Enterprise Manager? ASP page? VB app? Something else?

Whatever it is, the login is apparently set to login using Windows Authentication instead of SQL Authentication. If this is your Enterprise Manager, then right-click the server and choose Edit SQL Server Registration.

Herriot
Starting Member

2 Posts

Posted - 2002-07-12 : 04:43:58

AjarnMark - Thanks for that. We have checked and it is set for SQL Login. But I will check other avenues. IE Access.

If you choked a smurf what colour would it turn?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources