And this: Exec xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode' With that, I can then login using SQL Server authentication and that account. I can then create a normal SQL Server login. If I login to Windows using an admin account, I can connect to the database using Windows authentication.
The full commandline args: /QS /IACCEPTSQLSERVERLICENSETERMS /ACTION=Install /FEATURES=SQL What I need is a sql_login that I can use to connect to the database as an db administrator without regard for the permissions of the logged-in windows user, after having run the installer in unattended mode.
#INSTALL SQL SERVER 2014 VIEW COMPOSER INSTALL#
Is there a way, when running the SQL Server 2014 install unattended, to pass command line arguments that will have it enable sa so I can successfully login using it? My problem is that while I can see sa in sys.server_principals, it's flagged as is_disabled, and I can't login using it. I can create a SQL login and login successfully, so that part of the problem works fine. The command-line already contains /SECURITY MODE=SQL. My problem is that I need to be able to connect to the installed instance as admin using SQL Server authentication. I have an installer that's running the SQL Server 2014 Express installer in unattended mode.īasically, it's creating a command-line and running the setup.
0 kommentar(er)
