URGENT PLZ No Associated Trust Error 1

[CluelessJon]

Hello

I have a user with a XPHome machine with SQLserver installed on it.

He is setting up the ODBC but when he trys to go though the process he receives "No associated with Trusted SQL connection" error 18452.

He is using the SA account and SQL server Authentication.

Could someone please help as this is urgent.

thx

Regards

Jonno BrainDump Specialist
MCSE(NT) MCSA(2k) CCNA

 

[SQLBill]

Does the user have SQL Server installed on his machine or only the CLIENT TOOLS?

If SQL Server is installed, he doesn't need to create an ODBC connection.

You say he's using SA account and SQL Authentication. Okay, but what is the database set to accept? If it's set for Windows Authentication only, the SA account won't work.

-SQLBill

 

[CluelessJon]

Thanks Bill.

The options have been set to SQL authentication.

He is using ODBC because he is writing an application that will pull the data from one app then write it to the SQL database. I presume he needs to call an ODBC within the app which is why he is using it.

Could you explain why he would not need a ODBC.



Also one other point. I have SQL2000 on Win2003Svr and when I goto Enterprise manager I cannot add new users it is greyed out.. I am logged onto the MY PC as admin.. do I have to log onto Enterprisemanager as SA or something I cant see a logging

Thanks alot.

Regards

Jonno BrainDump Specialist
MCSE(NT) MCSA(2k) CCNA

 

[SQLBill]

First, now that you've provided more information, I understand why your user needs an ODBC connection. And yes he does need one. Your original post never said anything about a third-party application being used. Since you hadn't said anything about the 3rd-party app I assumed he was using Enterprise Manager or Query Analyzer.

So, let me start over...What is the SQL Server authentication set for? Go to Enterprise Manager, drill down to the server and right click on the server. Select Properties and go to the Security tab. What is the Authentication set for (SQL Server and Windows or Windows Only)? I'm guessing it's set for Windows only. If so, he will have to change that or use Windows Authentication in the ODBC connection.

Now for your question. Do you have an account (login) in SQL Server? What permissions do you have with that account? Use Enterprise Manager, drill down to Security, click on Logins. Find your login, right click and select Properties. Go to the Server Roles tab. Do you have Security Admin privileges? How about System Admin privileges? You need one of those to change/add/modify logins.

-SQLBill

 

[CluelessJon]

Thanks alot again Bill.

That information is very helpful.

what has happened is that on my SQL box in the office ..when i click on properties at the top level so I can change the security settings it quits out of Enterprise manager. Which is the reason I never saw those options.

And I cant fix it.

Thanks again mate!



Regards

Jonno BrainDump Specialist
MCSE(NT) MCSA(2k) CCNA

 

[CluelessJon]

The same thing happens If I right click on a Database and then select properties.. it just quits out of Enterprise manager.

Seen that before ?

Regards

Jonno BrainDump Specialist
MCSE(NT) MCSA(2k) CCNA

 

[SQLBill]

Sounds like a bad install of Enterprise Manager. Try reinstalling it. Load the CD, select INSTALL, and select CLIENT TOOLS ONLY when you get to that option.

-SQLBill