Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A: Windows Authentication Mode? Mixed Mode?

• Scott H. Chang

  SSCommitted

  Points: 1794

  More actions

  August 26, 2005 at 6:37 am

  #165855

  Hi all,

  I have Windows XP Pro on Microsoft NT 4 LAN System and there is a "named" instance of the early version of MSDE (MSSQL$CAMBRIGESOFT) already installed in my Windows XP Pro.

  I need to download Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A and install it in my Windows XP Pro as a "default" instance to be used in Microsoft Access 2003 in my PC. I read MSDE 2000 Release A Installation Examples, but I do not understand what "Windows Authentication Mode", "Mixed Mode" and "AStrongSAPwd" are. Can someone explain them to me?  Should I use Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A's "Windows Authentication Mode" or "Mixed Mode" for my "default" instance to be used in Microsoft Access 2003?  Please help and advise.

  Thanks in advance,

  Scott  Chang   

• August 29, 2005 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 728159

  More actions

  August 29, 2005 at 8:56 am

  #585873

  These are the security settings for how oyu connect to the server. Windows is probably what you are used to.

  Follow me on Twitter: http://www.twitter.com/way0utwest
  Forum Etiquette: How to post data/code on a forum to get the best help
  My Blog: www.voiceofthedba.com