|
|
Change authentication mode from windows to mixed mode in SQL Server 2005 (Express)
Sat, 08/07/2010 - 13:52
I am using SQL Server 2005 (Express) and not able to login using SQL Server authentication. I selecte Windows authetication mode at the time of installation how can i Change authentication mode from windows to mixed mode.
Similar entries
- No process is on the otherend of the pipe Microsoft SQL Server Error: 233
- Configuration error- authentication mode = "Windows" in web.config of ASP.NET
- SQL Server does not allow remote connections Error 26
- Transaction can not start while in firehose mode in Enterprise Manager
- Script action to job in Server Management Studio Express
- database restore from .bak file problem
- How to set Custom error pages in asp.net using web.config
- Windows Firewall cannot run because another program or service (Ipnat.sys)
- Outlook 2007 Sending error "None of the authentication methods supported by this client are supported by your server"
- How to boot the computer in Safe mode with Networking
GO TO "SQL Server Management Studio Express"
Right Click [MACHINE NAME]SQLEXPRESS
Go to properties
Select Security in left pane
Now in server authentication select "SQL Server and Windows Authentication mode"