Trusted Connection

[Kherozen]

Hi,
I've got a Database and a SQL Server(MSDE2000 from Office XP CD) installed on my machine. I just installed MSDE 2000 onto the company server and try to move the Database but I get "Login Failed for user 'mtl-w01\jgrenier'. Reason : Not Associated with a trusted SQL server connection.

I uncheck "Use Trusted Connection" try my login, sa, my winXP login ... always the same message.

How do I setup the server?!?

I got no problem connect the database on my computer and I've been able to connect other people to it but now I want to move it to the server and that doesn't work ...

(that's my first database using adp and the first one for the company also so I need advice please)


jul ^_^
"Computer Science is no more about computers than astronomy is about telescopes"
E. W. Dijkstra.

 

[SQLBill]

What type of authentication is the DATABASE set for?

If it's not set for mixed mode authentication, then you are not going to be able to use SQL Authentication.

The options are Mixed Mode (SQL Server authentication and Windows authentication) or Windows Authentication Only.

It sounds like your server is set for Windows Authentication Only. Change it to Mixed Mode.

-SQLBill

 

[appi]

Hi,

I got the same problem if connecting from 3rd party product. But the db is set up in mixed mode. I imagine that because I installed it on myself.
locally connecting works fine, but remote connecting gave "not trusted".
What can I do to connect to that instance ?
rgds
Uwe

 

[SQLBill]

Uwe (aka APPI),

Any connection that does not use the WINDOWS authentication is NON-TRUSTED. All that means is that the operating system can't confirm who you are. All NON-TRUSTED logins have to have a SQL Server login and password. TRUSTED means the operating system authenticated the user. Remote connecting is rarely TRUSTED. Usually the only way to make a trusted connection is to be on the same network.

-SQLBill

 

[appi]

Hi Bill,

I am in the same network as our server and the user is still locally, on domain and on DB. So I have done anything I can, and if I look on the server properties it shows Windows-Authentication.
Any more suggestions how I can get onto this DB's ?? By now it's only naked installations with master-DB, but it should be a big database in some weeks
rgds
Uwe

 

[SQLBill]

Uwe,

Check your ODBC connection. The second window should say:
How should SQL Server verify the authenticity of the login ID? Make sure you selected "With Windows NT authentication using the network login."

-SQLBill

 

[appi]

Bill,

I checked the ODB-Source on the server. But it neither work on Windows-Auth nor on SQL-Auth. Both will send the same old message, but testconnection will work (locally)

Uwe

 

[SQLBill]

Uwe,

What is the error message you are getting?
Are you able to connect to the database using your SQL login and password?
Do you have an account on the domain (network)?
Do you have an account on SQL Server?

Trusted connection requires you to have an account on the domain and in SQL Server.

Non-trusted requires you to have an account in SQL Server.

-SQLBill

 

[appi]

Hi Bill,

the account is as well on the server (locally) as on the database. I try to use sa with password.
The domain is the local server. I could only take the Servername for domain in "Add User to DB".

the complete errormessage is:
Connection failed: Logon failed, Message 18452, Severity 14, state 1, Login failed for 'sa' Reason: Not associated with trusted SQL Server connection, Server, Procedure, Line 0

Uwe

 

[SQLBill]

Since you are getting that error, it means you are trying to connect as a trusted user. In the login box, make sure Use Trusted Connection (I think that's what it says) is unchecked.

Check the SQL Server registration, does it allow both SQL Server and Windows NT authentication?

-SQLBill

 

[appi]

As I check up the tag for SQL-Server registration i found both entries to chec in and Windows authentication is checked.
I tried both yesterday - changed it to SQL-Server Authentication - but the error was stil the same.

Uwe