Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kh_wpl
Starting Member
7 Posts |
 Posted - 2011-10-05 : 04:31:10
|
| hiis there any way to install sql server with only sql server athentication mode. that's mean only sql server users login to sql service. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-10-05 : 04:38:14
|
| nope. you can install only in either of Windows Authentication mode or SQL Server and Windows Authentication mode not SQL Server authentication alone------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-05 : 06:01:17
|
quote:
Originally posted by kh_wpl
hiis there any way to install sql server with only sql server athentication mode. that's mean only sql server users login to sql service.
Even if it does allow how are you going to authenticate the sql service after the installation ?PBUH |
|
|
|
kh_wpl
Starting Member
7 Posts |
Posted - 2011-10-05 : 06:41:20
|
| I want restrict windows administrator login to sql server service and access to databases.only sa user and sql server users can login to sql server and databases. |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-10-05 : 07:41:41
|
| Then explicitly deny connect access to the windows login.But make sure you save the sa username password somewhere with high security because if you loose it there is no way you can then be able to login to the sql server or have any admin rights to the server.PBUH |
|
|
|
|
|
|
how to install sql in sql user athentication mode