Solved

What reg key to remove to make SQL Enterprise ask for new database info again

Posted on 2013-11-18
9
211 Views
Last Modified: 2013-11-19
What reg key to remove to make sql server enterprise ask for new  database info again
0
Comment
Question by:parps924
9 Comments
 
LVL 32

Expert Comment

by:Big Monty
ID: 39659402
try deleting (AFTER BACKING UP YOUR REGISTRY)

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

If this doesn't work - you're probably going to need to backup your machine data and rebuild it.
0
 
LVL 15

Accepted Solution

by:
dbbishop earned 500 total points
ID: 39659453
What are you trying to do? If you want to start all over again fresh, go to Control Panel > Programs and Features and remove Microsoft SQL Server.
0
 
LVL 29

Expert Comment

by:Rich Weissler
ID: 39659509
@parps924,
  As dbbishop says, if you want to reinstall MS SQL, that's likely the cleanest way to go.

  You ask about getting sql to "ask for new  database info again"?  There are a few default system databases used by MS SQL itself... I'm not certain if you are asking about changing the setting for one of the default databases, or perhaps to add a user or group to the list of system administrators in SQL (that was a problem, especially in SQL 2008 and beyond when local administrators were no longer automatically database SA.)  Or are you attempting to build a new database?  (Or, I'm not sure if you are really referring to SQL Reporting Services setup...?)  

  I think there are a lot of people who would love to help you, but we aren't yet sure what you are asking.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 39659561
If you want a new instance just run the installer again and click that option... Still not clear on what exactly you are trying to do here
0
 

Author Comment

by:parps924
ID: 39659822
Thanks for the answers... but my issue has been resolved.
0
 
LVL 32

Expert Comment

by:Big Monty
ID: 39659937
was that not the right registration key? how was it resolved?
0
 
LVL 38

Expert Comment

by:Aaron Tomosky
ID: 39659961
You can't be serious that the question was how do you use windows control panel to uninstall a program?
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

This collection of functions covers all the normal rounding methods of just about any numeric value.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now