How do I enable mixed mode authentication in MS SQL 2005
Rating: 0 user(s) have rated this article
Posted by: admin, on 6/22/2010, in category "SQL Server"
Views: this article has been read 513 times
Location: Crest Hill, IL, United States
Abstract: The following article explains how to enable mixed mode authentication in SQL. When enabled, mixed mode authentication allows you to log into a SQL server using either your Windows VPS username and password or your SQL database username and password. When logged in using your Windows VPS username and password, you have access to all the databases on the server.

  1. Log into your server through Remote Desktop Connection.
  2. Click Start, Programs, Microsoft SQL Server 2005 and select SQL Server Management Studio Express or SQL Server Management Studio, depending on your version of SQL Server.
  3. Enter the requested information: 
    • Server Type: select Database Engine 
    • Server Name: this field should be populated by default 
    • Authentication: select Windows Authentication
  4. Click Connect. 
  5. Right click the server name and select Properties. 
  6. Click Security. 
  7. Under Server authentication select SQL Server and Windows Authentication Mode. 
  8. Click OK. 
  9. Right click the server name and select Restart. Wait a few moments for the service to restart before proceeding.

How would you rate this article?

User Feedback

Post your comment
Name:
E-mail:
Comment:
Insert Cancel
Select Theme

Theme:

Account Login
 
 
 
Shopping Cart

Your cart is currently empty.

Order History
Announcements

Website is currently under construction. Please check back soon!


Maintenance Schedule
Advertisements
Newsletter
Register to the site for free, and subscribe to the newsletter. Every month you will receive new articles and special content not available elsewhere on the site, right into your e-mail box!

Archived Newsletters
Poll of the week

Archived Polls
Navigation Control
More Polls

Archived Polls