Post reply

Changing authenication for upgrade

  • July 3, 2006 at 2:02 am

    #60922

    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?

     

    Madame Artois

  • July 3, 2006 at 4:46 am

    #647158

    Hi, depending on the work the upgraders will have to do (eventually gain access to network ressources during the upgrade) this could be required to switch to Windows authentication.

    Windows Authentication is always on, there is Windows Authentication mode and Mixed mode (including SQL Server authentication) so you normally on´t have to turn on something rather than granting the appropiate person access to SQL Server) If they have been granted access as sa in the past, just put their Windows account in the sysadmin servern role and you are done. But remember to drop them of the role if you don´t want them to have access after the upgrade.

    HTH, Jens Suessmeyer.

    ---

    http://www.sqlserver2005.de

    ---

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply