Avatar of atredo
atredoFlag for United States of America

asked on 

Can I remove SQL 2005 from na Exchange Server 2010 ?

I have an Exchange server 2010 that had Blackberry Enterprise installed.
BES was using SQL.
The BES was removed but the removal didn't play well, and much had to removed manually.
The SQL Server 2005 still has a DB in there for Blackberry) . I have it disabled.
I cant delete it with the SQL Server Config Manager.
No other utility is installed to remove it.

Can I Just Uninstall The SQL server?

I am under the impression that exchange 2010 does not need SQL, IS that correct?
I do not see any other SQL databases in the Manager.There is a SQL Server Browser running.

ExchangeMicrosoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
atredo
SOLUTION
Avatar of Busbar
Busbar
Flag of Egypt image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
SOLUTION
Avatar of Imran Javed Zia
Imran Javed Zia
Flag of Pakistan image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

Great, I assume this will delete the BES SQL database too?
No, it will not delete files you have to manually get the datbase file paths and then delete them manually after uninstalling sql server
alternatively delete databases manually and allow them to delete files
Avatar of atredo
atredo
Flag of United States of America image

ASKER

right. I was going to do this:
For Microsoft SQL Server 2005
1.Click Start > Programs > Microsoft SQL Server > SQL Server Management Studio.
2.Expand Server Name > Databases.
3.Right-click the MDSS database and select Delete.
4.Right-click the MDSS_DIS database and select Delete.

but there is no Server Management Studio installed.
Is there another way?
Thanks for your help.
ASKER CERTIFIED SOLUTION
Avatar of pmcgivern
pmcgivern
Flag of Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

Fiirst command gives me  "could not open connection the the SQL Server"  login timed out.
It may have a password.
SQL Server Configuration Manager

FYI: SQL ver is Version: 2005.090.4035.00

I tried with a -U username and _P password
NO love. Same error

says the failure may be caused by that the default SQL server dows not allow remote conections.

I am running the command from a administrative command prompt on the Exchange server
SOLUTION
Avatar of pmcgivern
pmcgivern
Flag of Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

C:\Users\atredo>sqlcmd -S \mailserver\blackberry -E
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

Avatar of atredo
atredo
Flag of United States of America image

ASKER


C:\Users\atredo>sqlcmd -L

Servers:
    MAILSERVER\BLACKBERRY
    NARDINI
    NARDINI\SUNBELT
    NARDINI\TIGERPAW

Avatar of atredo
atredo
Flag of United States of America image

ASKER

Tried :
Thanks for your replies.    this is annoying.

C:\Users\atredo>sqlcmd -S \mailserver\blackberry -E
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

SOLUTION
Avatar of pmcgivern
pmcgivern
Flag of Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

No love.  shouls I just uninstall SQL 2005 and find the database to delete?

C:\Users\atredo>sqlcmd -S mailserver\blackberry -E
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

C:\Users\atredo>
Avatar of pmcgivern
pmcgivern
Flag of Ireland image

Yes, you can do that as well.  The files should not be too difficult to find - they'll have .mdf, .ndf and .ldf extensions by default.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

AHA !
  I shut down the DB and restarted it, then ran the command and got in but it wont let me remove it.


C:\Users\atredo>sqlcmd -S mailserver\blackberry -E
1> drop database mdss
2> go
Msg 3701, Level 11, State 1, Server MAILSERVER\BLACKBERRY, Line 1
Cannot drop the database 'mdss', because it does not exist or you do not have pe
rmission.
1> quit

So I tried ;

sqlcmd -S mailserver\blackberry -U besadmin -P Password1
Msg 18456, Level 14, State 1, Server MAILSERVER\BLACKBERRY, Line 1
Login failed for user 'besadmin'.


C:\Users\atredo>
SOLUTION
Avatar of pmcgivern
pmcgivern
Flag of Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of atredo
atredo
Flag of United States of America image

ASKER

Ran the uninstall for SQL 2005  and it allowed me granularity  to uninstall the blackberry sql without uninstalling all of sql 2005.     no problem.

I will uninstall SQL 2005 now.

Thanks for hangin in there with me. I'm sure there was some security problem with the databases password that the cause all along.

Avatar of atredo
atredo
Flag of United States of America image

ASKER

Thanks to all. You were a big Help !!
Exchange
Exchange

Exchange is the server side of a collaborative application product that is part of the Microsoft Server infrastructure. Exchange's major features include email, calendaring, contacts and tasks, support for mobile and web-based access to information, and support for data storage.

213K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo