During SQL Server 2014 Installation,I have set up Mixed Mode Authentication and given a password for it.My question is when I set Mix mode,did I set up password for SA login.So if want to use SQL authentication then will my login be SA in user name ?

** https://msdn.microsoft.com/en-us/library/ms144284.aspx says -- If you select Mixed Mode Authentication during setup, you must provide and then confirm a strong password for the built-in SQL Server system administrator account named sa. The sa account connects by using SQL Server Authentication.**

  • 1
    yes try logging in with sa – paparazzo Jun 19 '16 at 5:18
  • Thank you Paparazzi for confirming and for your time.I will do that. – SQLBoy Jun 19 '16 at 5:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.