SQL Server And windows authentication

From: Ryan Ternier (rternier_at_icompasstech.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 14:30:09 -0800

I'm running SQL server 2000 on my laptop running win server 2003 ent.
edition.

I'm configuring dotnet Text on this (blog), for release on my live DB
server.

I'm running into an issue. I'm trying to set my Server Authentication mode
to SQL Server And windows, instead of just windows.
I make the change, click OK, and stop/start the server. The change doesn't
hold. So I make the change again, click ok, then go right into properties
and see that the change didn't take effect.

Am I missing a step in this process?

Right Click on the server - Properties
Security Tab - Security Frame
Authentication : SQL Server and Windows.
Click Ok.

Those are the steps.

Do I need to change anything for this to work? Is the platform I'm running
it on conflicting with it in any way? I'm no wiz on 2003, but on 2000 this
works fine.

Any help would be appreciated.

RTernier
C# ninja

Relevant Pages

  • Re: SQL Server 2005 Login Problem
    ... There are two authentication method in SQL Server. ... 1- Windows Authentication ... 2- Mixed Authentication (through SQL Server logins and Windows accounts) ...
    (microsoft.public.sqlserver.clients)
  • RE: My Documents Redirection error
    ... We can upgrade the instance SharePoint ... >> is no need to manually migrate data from MSDE to SQL server and all dada ... >> How to back up and restore http://companyweb data in Windows Small ...
    (microsoft.public.windows.server.sbs)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • RE: My Documents Redirection error
    ... > is no need to manually migrate data from MSDE to SQL server and all dada is ... > How to back up and restore http://companyweb data in Windows Small Business ... Insert the Microsoft Windows Small Business Server 2003 Premium ...
    (microsoft.public.windows.server.sbs)
  • Re: Sicherheitseinstellungen fehlen
    ... > ich habe bei einem Server das Problem, ... Microsoft Windows NT Server 4.0 and Microsoft Windows NT Workstation 4.0 ... This article describes how to hide the Security tab of a file or folder ...
    (microsoft.public.de.german.win2000.sonstiges)