Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Upgrade a hardened SQL Server 2005 Management Studio Express to the fully licensed SQL Server 2005 SP2

Posted on 2008-10-17
4
Medium Priority
?
834 Views
Last Modified: 2012-05-05
Good morning experts.  Please tell me the best way to upgrade a hardened SQL Server 2005 Management Studio Express to the fully licensed SQL Server 2005 SP2.  It is installed on Windows Server 2003, with a fully installed hardend IIS 6.0 running.; also using IE 7.0, patched.  The hardware is Dell Power Edge 2850 server.  Could you use as much detail as possible.  I've just been handed this server.
0
Comment
Question by:configreq
2 Comments
 

Author Comment

by:configreq
ID: 22739619
also running WSUS 3.0 SP1
0
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 2000 total points
ID: 22746868
I assume that since it's running SQL Server Management Studio Express that it's running SQL Server Express as well.  

First step, buy SQL Server (std, enterprise, etc.)
Secondly: Decision time.
   Are you running a named instance
     if so?
     Do you want it to keep the same instance name?
       You will need to uninstall express (after backing up and detaching your DBs) in order to install into the same instance name
     are you ok with changing the instance name?
        You will need to change everything that references that instance name.
    If not?
      Same questions as "if so?" apply.
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question