General discussion

Locked

Changing SQL Server authenication

By hodkinss ·
We have a database which has always SQL authenication and has 300-400 named users. Upgrades to the database have always been done as 'sa'.

There is a new upgrade required. The new owners of the software now want use to change the authenication to Windows NT to complete the upgrade. They suggest changing the authenication to Windows to complete the upgrade then back again to SQL afterwards.

Can anyone see any difficulties with this? Has anyone got any advice on this?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by j.lupo In reply to Changing SQL Server authe ...

I am relatively new to SQL Server, but I know that we use Windows NT authentification with no problem, but our accounts are SA as far as the SQL Server is concerned anyway. Basically our windows account is an SA account to SQL Server. So we haven't had any problems with it.

Collapse -

by hodkinss In reply to Changing SQL Server authe ...

We need to swap into one mode to do the update, then swap it back to its original mode. We have never had to change a database mode like this, just for an update

Collapse -

by hodkinss In reply to Changing SQL Server authe ...

We need to swap into one mode to do the update, then swap it back to its original mode. We have never had to change a database mode like this, just for an update

Collapse -

by hank In reply to Changing SQL Server authe ...

If you are using SQL Server 2000 then when you are using SQL authenication the security is also set to use Windows authenication. You can set it to Windows only but not SQL only.

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums