Post reply

Authentication mode while upgrading from sql 2000 to 2005

  • March 2, 2009 at 12:18 pm

    #131417

    Hi,

    We are doing inplace upgrade from sql 2000 to 2005.The sql server 2000 was installed with the authentication mode is sql server and windows.. Now,while installing sql server 2005, what authentication do we need to choose?

    1.Do we need to choose windows Authentication mode? OR

    2.Do we need to choose Mixed mode? and why?

    if choose windows Authentication, will the upgrade fail?

  • March 2, 2009 at 3:20 pm

    #952145

    Better choose windows authentication and after upgrade don't forget to enable sa login and specifying a strong password for it.

    MJ

  • March 2, 2009 at 3:52 pm

    #952165

    In windows authentication mode , sa has no role since its a SQL level id , better install it using Mixed mode and change the authentication mode in case of necessity

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

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