August 15, 2019 at 5:54 am
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
August 16, 2019 at 6:10 am
Thanks for posting your issue and hopefully someone will answer soon.
This is an automated bump to increase visibility of your question.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply