SQL Server 2016 Standard

Question

Post reply

SQL Server 2016 Standard

richard37

SSC Enthusiast

Points: 112
More actions
July 7, 2022 at 1:49 pm

#4060137

Hey,
I have Windows 10 running SQL Server Express 64-bit and I purchased SQL Server 2016 Standard (genuine) key. I want to upgrade and I'm having difficulty figuring out how to do so. Could you direct me to the best how to or explain the steps?
Thank you.
August 19, 2022 at 3:44 pm

This was removed by the editor as SPAM
August 19, 2022 at 4:25 pm

This was removed by the editor as SPAM

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736198 More actions · Answer 1

I don't believe you can upgrade Express to Standard. I think you need to:

detach dbs
script out logins and linked servers
install SQL standard
attach dbs
recreate logins

Lewis215 Grasshopper Points: 16 More actions · Answer 2

I'm happy to see a particularly subject.

My Estub Sign In

This reply was modified 2 years, 4 months ago by Lewis215.

jonau1 Grasshopper Points: 19 More actions · Answer 3

You can follow instructions from this link https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-2017

This procedure should work for 2016 as well

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

richard37 wrote:

richard37 wrote:
Hey,
I have Windows 10 running SQL Server Express 64-bit and I purchased SQL Server 2016 Standard (genuine) key. I want to upgrade and I'm having difficulty figuring out how to do so. Could you direct me to the best how to or explain the steps? {spam link removed} Thank you.
I got this,...

Nope... I've got you. Spam deleted.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)