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.
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.
Last Comment
SOLUTION
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.
SOLUTION
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.
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
alternatively delete databases manually and allow them to delete files
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.
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
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.
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
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
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.
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.
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.
ASKER
C:\Users\atredo>sqlcmd -L
Servers:
MAILSERVER\BLACKBERRY
NARDINI
NARDINI\SUNBELT
NARDINI\TIGERPAW
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.
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
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.
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>
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.
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>
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
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.
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.
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.
ASKER
Thanks to all. You were a big Help !!
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
TRUSTED BY
ASKER