Re: Converting to SQL authentication

From: Richard Waymire [MSFT] (rwaymi_at_online.microsoft.com)
Date: 12/07/03 

Date: Sun, 7 Dec 2003 12:19:01 -0800

Sounds like your server is still in windows-only authentication. Change
your connection back to windows auth, right click on your server, select
properties, security, and change to "Windows and SQL Server" authentication.

As an aside why would you switch? Windows auth is much
preferred/recommended.... 

-- 
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"Roy Goldhammer" <roygoldh@hotmail.com> wrote in message
news:ekcyTjOvDHA.2712@TK2MSFTNGP11.phx.gbl...
> Hello there
>
> When i started programming on sql server I started with windows
> authentication.
>
> Now my administrator told me to move to work with sql server
authentication.
> When i changed the authenticaion on Enterprise manager i got an error that
> (There is no trust connection)
>
> How can i move to work with Sql Authentication?
>
> any help would be useful
>
>
>

Relevant Pages

  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Need help configuring Wireless Connection profile
    ... and I can only use the intel OR windows utility, not both at the same time. ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)
  • Re: EAP-TLS with windows CE
    ... The AP was sending out an Identity Request every second, ... request to the identification server. ... When the server asks the Windows CE device to identify itself, ... I could easily steal your authentication information. ...
    (microsoft.public.windowsce.platbuilder)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)