Solved

Windows Server 2003

Posted on 2014-07-23
5
97 Views
Last Modified: 2014-07-24
Have client running Windows Server 2003.  There was a SQL error today.  Not allowing SQL to connect to their database.  Can SQL be deleted and reinstalled without the entire OS being installed.  Yes, I know it is way out of date.  They are going to purchase new server software, but need something top repair in the interim?
0
Comment
Question by:ycguy1117
  • 2
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Peter Hutchison
ID: 40215563
Yes, it is possible, although you should have the permissions such as usernames and passwords documented somewhere to restore connectivity. What version of SQL is it?
0
 

Author Comment

by:ycguy1117
ID: 40215628
I do not know, it would have been included with server 2003.
0
 
LVL 24

Accepted Solution

by:
Lionel MM earned 500 total points
ID: 40216626
I would be VERY hesitant to simply uninstall it. There is a lot of work involved with making database backups first, then installing the new SQL and then attching the backups to the new instance of SQl and then making sure you use the same naming conventions for your new SQL instance so the clients can still connect to it. I suggest you tell us more specifically what errors you are getting so we can help you resolve that.
0
 
LVL 24

Assisted Solution

by:Lionel MM
Lionel MM earned 500 total points
ID: 40216632
Not sure of your Tech level but SQL is a server product and not an application you can "simply" uninstall and then reinstall (if you already know this sorry but wanted to make sure you did know in case you didn't)
0
 

Author Comment

by:ycguy1117
ID: 40216684
I knew that but was inquiring about probability because the software tech that runs on this server mentioned it?  Thanks
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Log files are useful in diagnosing and repairing problems.  This is a list of common log files and their standard locations that I've compiled.   While this is not exhaustive, it is a pretty good list that I've found to be useful.  I may update it f…
When you upgrade from Windows 8 to 8.1 or to Windows 10 or if you are like me you are on the Insider Program you may find yourself with many 450MB recovery partitions.  With a traditional disk that may not be a problem but with relatively smaller SS…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

778 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