ADO.NET connection problem - not in trusted domain [Resolved]

[sbasak]

I'm simply trying to display some data from an SQL Server database. But I'm getting an error that 'User='aaa' is not in trusted domain'. What does that mean???

[Edneeis]

Sounds like your connectin string is bad. Try using a different User and Password and make sure that it has permission or a login for the SQL Server. Also make sure that the SQL Server isn't set for Windows Authentication only. If you aren't in Mixed Mode then you can't specify a User it uses your current Windows Account.

[Pirate]

I really fogot everything after I passed MCSE exams . I was trying to remember what trusted domain mean but.... . anywasy here's a link for trusted domains and that jazz !

[sbasak]

I think I'm in Windows authentication mode. Won't it work in that mode? What should I do? How?

[Edneeis]

In that mode your windows account has to have sql permissions in the same domain or to the sql server and you shouldn't be using a username and password just 'Integrated Security=SSPI' where the username and password would be.

[Mike Hildner]

What version of SQL Server? I use 2000 sp3, don't know where settings are in previous versions.

First, verify your authtication mode. In Enterprise Manger, right click your instance and choose properties. On the security tab, what is selected under "Authentication"?

[sbasak]

It worked! Thanks for all your help. Now I can connect with SQL Server. My present setting is mixed mode authentication.

[score]

Hello Folks,
I think I ran into similar problem and while I was searching for solution I came across this thread. Hope you guys help me out.

Here is the situation:

I have SQL Desktop Engine sitting on a Windows 2000 Workstation sitting on a Novel Netware enviornment.

The VB.Net application is installed on other Windows 2000 pc.

In order to access the SQL DB sitting on the dedicated Win2000 box, each user has to have user account with same login information (username and passoword) what they provide when they login into LAN (Novel Netware).

Once they change/update Network password, we have to update the password on the SQL Win2000 Box as well.

This is causing major problems now, and it is getting pain in the ass.

We had set up SQL Server to use SQL Server Authentication,
And under Properties, Security TAB it shows
SQL Server and Windows

While supplying the connection string I tried the following options
CONN = "data source=GCBEDM23\VSdotNET;initial catalog=CMOS;integrated security=SSPI;"

CONN = "data source=GCBEDM23\VSdotNET;initial catalog=CMOS;"

CONN = "data source=GCBEDM23\VSdotNET; user id=cmode;password=cmode;initial catalog=CMOS;"

They all work fine if I had user account setup on the SQL Win2000 box with same (Network) login info.

How could I setup that to access the SQL DB through VB.Net app, I do not need to setup the local user on SQL Win2000 machine?

Please advise.

Thanks in adavance.

[Pirate]

again and again and again , plz don't dig up old threads . Start your own .

[score]

Pirate,
I did started a new thread but after I posted this one. Sorry about that, but I founded this one close to my problem and that's the only reason, I posted a reply.

Anyways, do you have any ideas as how can I resolve my issue.


Here is the URL for my new thread:
http://www.vbforums.com/showthread.p...69#post1495069

Thanks

[Pirate]

DUNNO