locked
Install SQL Server 2012 with Mixed Mode Authentication RRS feed

  • Question

  • I am Installing SQL Server 2012 Developer for SharePoint Installation. I have selected mixed mode authentication. For reasons, only sa account can do sql authentication. All users that added during Installation default to windows Authentication and cannot do both Sql and windows Authentication although I specified Mixed Authentication

    Ebenezer

    • Moved by Dan GuzmanMVP Tuesday, March 26, 2013 2:33 AM move security question to security forum
    Tuesday, March 26, 2013 1:47 AM

Answers

  • Sure, you can create a domain user as a sysadmin role member either during installation (which I understood you already did) or afterward.  But be aware a domain account can only authenticate using Windows authentication and a SQL login can only authenticate using SQL authentication.  You cannot authenticate using SQL authentication with a domain account, but that begs the question why you would want to.  Can you elaborate what you are trying to achieve?


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Marked as answer by denkyira Tuesday, March 26, 2013 2:24 PM
    Tuesday, March 26, 2013 3:09 AM

All replies

  • You need to add SQL authenticated logins (other than sa) after installation.  I don't believe the installation wizard supports creating new SQL logins during provisioning.  Below is a T-SQL example to add a SQL login with sysadmin role membership:

    CREATE LOGIN SomeLogin WITH PASSWORD = 's0MeP@sswoRD';
    ALTER SERVER ROLE sysadmin ADD MEMBER SomeLogin;
    I'll move this tread to the SQL Security forum.

    Dan Guzman, SQL Server MVP, http://www.dbdelta.com


    • Edited by Dan GuzmanMVP Tuesday, March 26, 2013 2:33 AM added note moving thread
    Tuesday, March 26, 2013 2:32 AM
  • Hi Dan 

    Thanks, but the question is , is it possible to create such user as a Domain user e.g apstore\eb?


    Ebenezer

    Tuesday, March 26, 2013 2:59 AM
  • Sure, you can create a domain user as a sysadmin role member either during installation (which I understood you already did) or afterward.  But be aware a domain account can only authenticate using Windows authentication and a SQL login can only authenticate using SQL authentication.  You cannot authenticate using SQL authentication with a domain account, but that begs the question why you would want to.  Can you elaborate what you are trying to achieve?


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Marked as answer by denkyira Tuesday, March 26, 2013 2:24 PM
    Tuesday, March 26, 2013 3:09 AM
  • I am Installing SharePoint 2013 and need a sql login for the user during configuration. Well I have not tried adding the user to the sysadmin group hence why I am not succeeding, so I get it a try and let you know. Thanks for your help

    Ebenezer

    Tuesday, March 26, 2013 3:15 AM