Delete Server in DB Engine

Question

Delete Server in DB Engine

VegasL

Hall of Fame

Points: 3006
More actions
November 12, 2017 at 5:51 am

#324418

Hello,
I have two different instances of database engine on local servers. How do I delete one?
Thanks

Viewing 12 posts - 1 through 11 (of 11 total)

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

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 1

VegasL - Sunday, November 12, 2017 5:51 AM
Hello,
I have two different instances of database engine on local servers. How do I delete one?
Thanks

Uninstall the unwanted instance
😎

VegasL Hall of Fame Points: 3006 More actions · Answer 2

VegasL

Hall of Fame

Points: 3006

November 12, 2017 at 6:19 am

#1967672

how to uninstall the unwanted one?

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 3

VegasL - Sunday, November 12, 2017 6:19 AM
how to uninstall the unwanted one?

Add or remove programs
😎

VegasL Hall of Fame Points: 3006 More actions · Answer 4

Thanks..hmm when i go to add/remove programs i see microsoft sql server ....along with rest of programs on pc, don't see anywhere to uninstall an instance of server for db engine. could you clarify further please?

when i start ssms it asks for server name (because i have 2 instances). One of them I want to remove so i dont have to browse local servers to connect to db engine.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 5

VegasL - Sunday, November 12, 2017 6:32 AM
Thanks..hmm when i go to add/remove programs i see microsoft sql server ....along with rest of programs on pc, don't see anywhere to uninstall an instance of server for db engine. could you clarify further please?
when i start ssms it asks for server name (because i have 2 instances). One of them I want to remove so i dont have to browse local servers to connect to db engine.

Look for the initial installation folders then.
😎

Another option is to permanently disable the unwanted service, does the same😉

VegasL Hall of Fame Points: 3006 More actions · Answer 6

Thanks Eirikur

How do I permanently disable the unwanted service?

SQL Server Configuration Manager > SQL Server Services > Select "Unwanted Server" > Right Click Properties > Start Up Parmeters > Remove All, yes ?

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 7

VegasL - Sunday, November 12, 2017 7:37 AM
Thanks Eirikur
How do I permanently disable the unwanted service?
SQL Server Configuration Manager > SQL Server Services > Select "Unwanted Server" > Right Click Properties > Start Up Parmeters > Remove All, yes ?

That's one way, the other is Services > Unwanted > Disable
😎

VegasL Hall of Fame Points: 3006 More actions · Answer 8

"That's one way, the other is Services > Unwanted > Disable"

That's what I want to do, when I go to SQL Server Configuration Manager > SQL Server Services > Unwanted > I just see ..start, stop, resume, pause but NOT disable.

Eirikur Eiriksson SSC Guru Points: 182882 More actions · Answer 9

VegasL - Sunday, November 12, 2017 9:40 AM
"That's one way, the other is Services > Unwanted > Disable"
That's what I want to do, when I go to SQL Server Configuration Manager > SQL Server Services > Unwanted > I just see ..start, stop, resume, pause but NOT disable.

Services > Unwanted Instance > Properties
😎

Ed Wagner SSC Guru Points: 287024 More actions · Answer 10

Eirikur is describing the OS services, which you won't find in SQL Server or the configuration manager. Depending on your version of Windows, you'll do something like Start...Control Panel...Services. I just open the Run dialog and, type services.msc and click OK. From there, you can disable the services for the unwanted instance. If you don't have permission to remote into the server, you can always have your Server Admin or Network Admin help you get it done.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

VegasL Hall of Fame Points: 3006 More actions · Answer 11

Hi Ed,

When i open the Run dialog and, type services.msc and click OK, it takes me to the SQL Server Configuration Manager , where it has the same..start,stop,pause,resume.... currently it is marked as stopped. But it still forces me to choose between servers when starting ssms.

However, I just saw in this sscm,i right click unwanted server > properties > services > select from dropdown (changed from automatic) to disabled. and it worked 🙂

So thanks to both of you! Now I'll reinstall antivirus program.

Is there a way from UI to delete unwanted server and or go into a data file and delete?

Also is there a way to rename existing server?