Software

Ask something
Discussion Locked

Changing SQL Server authenication

0 helpful
4 replies

by hodkinss

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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?

4 replies

by j.lupo

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.

by hodkinss

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

by hodkinss

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

by hank

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.

This discussion is closed to new replies.