all groups > sql server msde > october 2004 >
You're in the

sql server msde

group:

trusted SQL connection problem


trusted SQL connection problem Brad
10/6/2004 9:42:05 AM
sql server msde:
Okay, I know this subject has probably been beat to death, but here is my
situation:

I have an instance of MSDE over a network. I created a VB program that uses
the MSDE instance as the data store. On installing the program on a couple
of PCs the program works just fine and I do not get any errors. On the
remaining PCs I am getting the dreaded "Not associated witha trusted SQL
Server connection <null> user".

Now in a matter of deduction, I don't think it is the connection string used
in the program because this is working on the first four PCs I installed the
program to. Every PC shares the same domain, by the way. We are a small
company with under 100 PCs. But why would this come up on only a couple of
PCs?

I have set these users up on the actual PC that has MSDE and assigned
Administrative rights to these users. Thinking this would grant them access
to the data store. Still have the same problem.

Thanks for any insight into what else I might try or what I am doing wrong.

Brad

Re: trusted SQL connection problem William (Bill) Vaughn
10/6/2004 9:55:19 AM
So, would you care to share it with the group?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

[quoted text, click to view]

Re: trusted SQL connection problem Brad
10/6/2004 12:18:38 PM
Found the problem!


[quoted text, click to view]

Re: trusted SQL connection problem Brad
10/7/2004 7:35:40 AM
It wasn't a problem inherent to the coding of the program. I believe it was
a permission issue (obviously) with the workstation id connecting to the PC
that contains MSDE.

I set up a user on the MSDE server that I knew worked and just used that id
on each PC.

Brad


[quoted text, click to view]

AddThis Social Bookmark Button