Re: not associated with a trusted sql server connection

From: Russell Fields (rlfields_at_sprynet.com)
Date: 06/16/03 

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
system.

Look up Authentication Modes in the BOL or:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_security_47u6.asp

Russell Fields

"buran" <buran@buran.com> wrote in message
news:Oi3aHfBNDHA.3020@TK2MSFTNGP10.phx.gbl...
> Thanks, but how can I change it from Windows Authentication to Mixed Mode
> Authentication?
>
> "Silmar" <silmar@talex.pl> wrote in message
> news:uF96X19MDHA.452@TK2MSFTNGP11.phx.gbl...
> > > 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
> >
> >
>
>

Relevant Pages

  • Re: Need help configuring Wireless Connection profile
    ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless ... Vaillancourt,4155,1,4154,Use Windows authentication for all ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)
  • Re: Kerberos machine authentication - apparent authentication fail
    ... > until logon), the wireless connection can kick off when it is ready. ... > was confirmed in the server event logs with IAS (i set that up as the radius ... > as an ordinary user kicks in and takes over from the machine authentication. ... > while the network sorts itself out and a double click on a network link of ...
    (microsoft.public.windows.server.security)
  • Re: Basic Authentication + IIS 5 + Windows 2000 + Frontpage 2002 = failure?
    ... SYSTEM account. ... In IIS I took the virtual server that I was testing, ... Authentication premise. ... From a website perspective, I ...
    (microsoft.public.inetserver.iis.security)
  • Need help configuring Wireless Connection profile
    ... I have an SBS 2003 server and a Server 2003 member server set up using RADIUS ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 PEAP ... Certificate Services ...
    (microsoft.public.windowsxp.general)
  • Re: Remote Web Workplace Issues-Please help!
    ... Open the Server Management Console, ... client after Authentication" right. ... permissions, and Microsoft Windows user rights according to the KB 812614. ... Download the IIS Resource Kit tools from the following page: ...
    (microsoft.public.windows.server.sbs)
Quantcast