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!
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.
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi,
There is no worry to remove sql server installation, but for safe hand take backup of you existing databaase.
Thanks
There is no worry to remove sql server installation, but for safe hand take backup of you existing databaase.
Thanks
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
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.
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.
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.
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
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.
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.
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.
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.
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.
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>
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.
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.
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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial