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.
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?ThxJohny |
|
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? |
|
|
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? |
|
|
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 domainAny help is welcome.BTW. I have no problem in the conection..... |
|
|
rtr1900
Starting Member
48 Posts |
Posted - 2008-05-20 : 06:20:47
|
anybody? Please....... I can´t connect the people to the server..... th |
|
|
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 |
|
|
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" |
|
|
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 |
|
|
|
|
|