troubleshooting Question

Help with SQL Instance - Will deleting an instance have an effect on other instances - see an attached screen shot

Avatar of highstrong
highstrongFlag for Canada asked on
BlackBerry ProgrammingMicrosoft SQL Server 2005
11 Comments1 Solution493 ViewsLast Modified:
ERROR INFO SQL INSTANCES
I have an SBS 2003.  It had BES 4.0.1, and SQL MSDE installed.  All of a sudden the BES SQL database was not accessable. In SQL management studio express, we were unable to connect to it at all. 2 thoughts were that 1 the database was corrupt or 2, it is possible the user profile of the person who created the database was deleted (or both.)

So we upgraded them to BES Express 5.  This install runs SQL 2005 Express - thus updating the MSDE.  We installed and configured a new database.  After install, we are running BES just fine(SERV2\BLACKBERRY).

However the OLD sql instance that we were having trouble with is still there (SERV2). The error code when trying to connect is there.  We have tried everything - including administrtors, and sa accounts etc, but cannot connect.  

Does any one know if we can delete this - and if it will have an impact on the other SQL instances.  We are nervous as it appears to be the "Root" name of the other instances.  

The main problem is that NTBACKUP is not runnning now with a VSS handshake error and we think that this SQL instance is the problem, we also just want to get it cleaned up.

Has anyone seen this before and or have any advice?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros