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
 General SQL Server Forums
 New to SQL Server Programming
 ODBC conection problem

Author  Topic 

rtr1900
Starting Member

48 Posts

Posted - 2008-05-16 : 05:37:27
Hi,

I am trying to connect some users to the server using ODBC.
But when I do that I get an error that the user is not asociated as a concexcion of confidence of SQL Server.
From my PC it works fine as I am the administrator.

Where do I have to change it?

Thx

Johny

rtr1900
Starting Member

48 Posts

Posted - 2008-05-16 : 05:57:49
I read thaa it has to do something with :
the Authentication Mode of the SQL server

But I have it set on "SQL SERVER AND WINDOWS", so it should work, no?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-17 : 18:15:49
Which authentication did you use? What's completed error message?
Go to Top of Page

rtr1900
Starting Member

48 Posts

Posted - 2008-05-19 : 07:22:19
I used SQL + Windows togethe (I believe it is called the Mixed one)
The error I get is:

Connection failed:
SQLState: '28000'
SQL Server Error: 18542
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'EGARCIA'. Reason: No associated with a trusted SQL Server connection.

Egarcia is registered on the server as:
a user of the domain

Any help is welcome.

BTW. I have no problem in the conection.....


Go to Top of Page

rtr1900
Starting Member

48 Posts

Posted - 2008-05-20 : 06:20:47
anybody? Please....... I can´t connect the people to the server.....

th

Go to Top of Page

rtr1900
Starting Member

48 Posts

Posted - 2008-05-20 : 07:00:01
I noticed if I add the user to the ADMINISTRATOR group it goes well.
But he can´t be a member of that group. What do I have to do? In which group should he be?
Do I have to create a group, and so if, how do I do that?


Thx
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-20 : 08:38:17
Is using trusted connection, you have to create a security group, add the user to that security group and finally add the security group to the SQL Server.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

rtr1900
Starting Member

48 Posts

Posted - 2008-05-20 : 09:01:46
I found it...... i forgot to add the user in the SQl server sessions......
thx to rmiao, atleast he tried to help me!

Cheerio




Go to Top of Page
   

- Advertisement -