Re: Reconfiguring the data access authentication

Try using this code, which is supposed to change the Authentication Mode to Mixed Mode.

USE [master]
GO
EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2
GO

There is a GUI of SQL Server 2005 which is called SQL Server Management Studio and this tool ships with fee-paying editions of SQL Server. However there is a limited version of this tools which can be used for all editions of SQL Server and can be downloaded freely and it's called SQL Server Management Studio Express.

Using this tool, you can easily perform basic tasks against your SQL Server Instance.
http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796

--
Ekrem Önsoy



"King Coffee" <kcoffee@xxxxxxxxxxx> wrote in message news:00D917AB-C5EE-4A42-88DC-601A19C5B4A2@xxxxxxxxxxxxxxxx
Hi,

Went I initially installed SQLEXPRESS with Advance features, I selected Windows Authentication for connecting to SQL Server Express. Now I want to change it to "Mix" (Windows and SQL Authentication). I'm using SQL Server Management Studio Express... so, how can I run a query to reconfigure the security option to Mix?

Thanks,
King

.

Relevant Pages

  • Re: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL Express MDF file moved from 1 computer to another - auth f
    ... I try to attach the database which is located in MyDocuments\Visual ... Microsoft SQL Server Management Studio ... now it tells me that authentication has failed for my windows ...
    (microsoft.public.sqlserver.connect)
  • 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: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)