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 |
|
ElZak
Starting Member
1 Post |
 Posted - 2009-02-05 : 12:03:36
|
| I'm trying to change a user from windows authentication to SQL Server authentication once the account has already been created. Is this possible? It appears that the option has been greyed out.Many Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-05 : 12:43:25
|
| has sql login being created for user? you can select authentication mode in connect to window in management studio |
 |
|
|
tonymorell10
Yak Posting Veteran
90 Posts |
Posted - 2009-02-05 : 17:02:21
|
| You cannot change the authentication mode once the login has been created. You have to create a new login selecting SQL Server Authentication and select the roles and user mappings for the new login. |
|
|
|
chandu123
Starting Member
11 Posts |
Posted - 2009-02-07 : 07:14:26
|
| yes you can change your windows authentication to sql server by doing this login with windows authentication and right click on current authentication and go to properties and click on security node now change your authentication to sqlserver.**chandu** |
|
|
|
|
|
|
Can I change authentication after account is done