Re: not associated with a trusted sql server connection
From: Russell Fields (rlfields_at_sprynet.com)
Date: Mon, 16 Jun 2003 11:41:16 -0400
If you connect to the server with Enterprise Manager and you have sysadmin
rights this is a server property that can be set.
>From the BOL:
To set up Mixed Mode security
1.. Expand a server group.
2.. Right-click a server, and then click Properties.
3.. Click the Security tab.
4.. Under Authentication, click SQL Server and Windows.
But if you can stick to Windows authentication you will have a more secure
Look up Authentication Modes in the BOL or:
"buran" <firstname.lastname@example.org> wrote in message
> Thanks, but how can I change it from Windows Authentication to Mixed Mode
> "Silmar" <email@example.com> wrote in message
> > > When I'm connection to my SQL Server database in Visual Studio.NET, I
> > > receive the following error:
> > > "not associated with a trusted sql server connection". I changed my
> > > connection string, tried sa user with password, but no luck. Whatever
> > > I enter in the data source login dialog box, I cannot proceed. What
> > > could be causing this error?
> > Your SQL is set to "Windows Authentication".
> > Change it to "SQL and Windows Authentication".
> > Or create SQL login for your Windows user.
> > Regards
> > Silmar