how do i convert my sql server management studio express to server authentication mode.. please help regarding this..
+1
A:
I assume you mean SQL or Mixed-mode Authentication (the ability to login using your SA account). Follow the instructions in this link.
Chris McCall
2010-03-11 16:55:11
I would upvote this if the link worked...
djeidot
2010-03-11 17:07:42
Now right click the [MyComputerName]/SQLExpress and select Properties then open the Security page, on Server Authentication section select SQL Server and Windows Authentication Mode.What does this step say.. :s please help..
Abid Ali
2010-03-11 17:29:35
there is no page of Security :s
Abid Ali
2010-03-11 17:30:11
+1
A:
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
Securitytab. - 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.
Amadiere
2010-03-11 16:56:18