Can I remove SQL 2005 from na Exchange Server 2010 ?

atredo
atredo used Ask the Experts™
on
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.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
BusbarSolutions Architect
Commented:
yes you can remove the SQL it is not used by Exchange by any mean.
Imran Javed ZiaConsultant Software Engineer - .NET Architect
Commented:
Hi,
There is no worry to remove sql server installation, but for safe hand take backup of you existing databaase.
Thanks

Author

Commented:
Great, I assume this will delete the BES SQL database too?
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Imran Javed ZiaConsultant Software Engineer - .NET Architect

Commented:
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

Author

Commented:
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.
Use OSQL.  It should be installed with SQL.  You can connect from a command line with :

osql.exe -S Servername -E

Then you can issue SQL commands:

DROP DATABASE MDSS
GO
DROP DATABASE MDSS_DIS
GO
QUIT

That should do it for you.

Author

Commented:
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
Are your SQL services still running?  Check that.  If they are you can run SQLCMD -L from a command prompt to list all your local sql servers.  Look for yours on the list - it may need an instance name like Servername/SQLExpress.  Once you find it try:

SQLCMD -S Servername\Instancename -E

I'm guessing you are an admin on the server as -E is for trusted connections.  Once you log in you can run the drop database commands.

Author

Commented:
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.

Author

Commented:

C:\Users\atredo>sqlcmd -L

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

Author

Commented:
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.

Drop the leading \.  should just be:

sqlcmd -S MAILSERVER\BLACKBERRY -E

Author

Commented:
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>
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.

Author

Commented:
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>
Try this to tell you where the db files are stored:

USE MDSS
SELECT * FROM sys.database_files
GO
USE MDSS_DIS
SELECT * FROM sys.database_files
GO

The easiest option for you then is just to uninstall SQL and delete these files.

Author

Commented:
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.

Author

Commented:
Thanks to all. You were a big Help !!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial