CODEWITHSUNDEEP
sql-server-2005
Abid Ali
Abid Ali

Reputation:

Sql Server Management Studio Express

how do i convert my sql server management studio express to server authentication mode.. please help regarding this..

Upvotes: 1

Views: 178

Answers (2)

Amadiere
Amadiere

Reputation: 11416

You should be able to connect to it as normal via whatever method you already have (this requires sufficient Admin permissions).

Then to enable access via SQL Logins you can

  • Right click on the instance name in Management Studio (mine is localhost\SQLEXPRESS (SQLServer 10.0.1600)).
  • Go to the Security tab.
  • Then you should be able to enable SQL Logins by clicking SQL Server and Windows Authentication Mode.
  • Click ok and you're done!

You can now add SQL Logins as connect via them as you would normally.

Upvotes: 1

Chris McCall
Chris McCall

Reputation: 10397

I assume you mean SQL or Mixed-mode Authentication (the ability to login using your SA account). Follow the instructions in this link.

Upvotes: 1

Related Questions