Security and upgrade SQL Express

• vsamantha35

  SSChampion

  Points: 11551

  More actions

  August 15, 2019 at 5:54 am

  #3671479

  Hi All,

  Need a clarification. I am not seeing BUILTIN\Administrators group under sql logins. Was it removed from any specific version. I am using SQL 2016 Express Edition. 'sa' is also disabled. only windows authentication is turned on.

  What are the steps to add a windows user as a sql admin.?

  The reason why I am asking this, recently we have got an SQL Express instance which needs to be upgrade (i.e. edition upgrade =Standard) as they hitting 10GB limit on data files. Thats why wanted to know the steps involved to add a user as an sqladmin before performing the edition upgrade.

  Also, are there any known issues while performing edition upgrade from SQL2014 express edition to SQL2014 standard edition ?

  Thanks,

  Sam

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  August 16, 2019 at 6:10 am

  #3671758

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.