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 |
|
msbolton
Starting Member
12 Posts |
 Posted - 2004-02-17 : 09:35:16
|
| I am trying to connect to a sql server database using an activex dts script that creates a recordset.I have set up a user but whenever I try and connect the message that I get back is NOT ASSOCIATED WITH A TRUST SQL CONNECTION.Is there a special way in which I need to setup my user or do i need to change any setting on the sql server itself.Any help would be much appreciated! |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2004-02-17 : 09:56:25
|
| Is this user account part of the NT domain or active directory?To use trusted connections the user account must be part of the NT domain and not just a sql server account.Are you able to connect via query analyzer as the user without typing the password for the account in query analyzer?Lance Harra |
 |
|
|
msbolton
Starting Member
12 Posts |
Posted - 2004-02-17 : 10:05:50
|
| Have managed to solve after getting in contact with a friend.It was due to the settings on the server. The security was set to WINDOWS ONLY. On advice I have changed to SQL SERVER AND WINDOWS and everything now works.Thanks for replies.Mark |
|
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2004-02-17 : 10:32:22
|
| Glad you got your problem solved.It sounds like you are not connecting via a trusted connection, but are using sql server security instead.Lance Harra |
|
|
|
|
|
|
User with Trusted SQL Connection