[chunk73]

So i accidently installed full blown mds on my upgrade to 4.1 SP6. So i uninstalled completely, and basically did a knife edge cutover install but on the same server. MDS is no longer installed however it is still showing up in the blackberry management console. I assume that something is still lingering in the besmgmt database. Anyone know how to get rid of it in the console?

Thanks

[bl0rb]

Run the following Structured Query Language (SQL) query on the BlackBerry Configuration Database:

Delete from MDSConfig where ServerName = <ServerName>, where <ServerName> is the name of the BlackBerry MDS Connection Service you want to remove. For example, BES01_MDS-CS_2.

[vhato]

I did that too back in 4.1.2. So I left it alone and it works great. Now running 4.1.6 and no problems.

[gibson_hg]

Before you give the guy directions on database deletions, make sure it's for the right MDS. There are 2 remember. He said full blown MDS, I would take this as MDSS.

@ chunk73 - Which MDS do you want to get rid of? The MDS-CS from the cutover or the MDSS from the previous install? Or both?

If you want to delete the MDS-CS, then use the command posted by bl0rb, if you want to get rid of the MDSS URL as well, use the following comamnd:

1> use databasename
2> delete from mdsagconfig where serverurl = 'https://<FQDN>.<domain>:7443/mds'
3> go

serverurl is the MDS URL in your BB Manager.

Those commands should get rid of the MDS listing(s) in your BB Manager.

[chunk73]

I want to remove the full blown MDSS. I need the basic MDS-CS for web browsing capabilities. I ran the SQL statement provided and got the following error. Let me know if this makes any sense to anyone.

Msg 547, Level 16, State 1, Server SQL1, Line 2 The DELETE statement conflicted with the REFERENCE constraint "FK_ServerConfig_MDSAGConfig". The conflict occurred in database "BESMgmt", table "dbo.ServerConfig", column 'MDSAGConfigId'.
The statement has been terminated.

[gibson_hg]

That means that the field that you tried to delete has a foreign key realtionship in the serverconfig table.

So, in the mdsagconfig table there is an Id field. If you run this line:

select * from mdsagconfig where serverurl = <your serverurl>

You will see a field for Id. That is the id that is linked to the serverconfig table. You will need to delete the record from the serverconfig table first.

If you have SQL Server, you can use Enterprise Manager to look at table rather than run commands to delete records. It's easier and somewhat safer, incase you run the wrong sql statement

But this line should work for deleting the record from serverconfig:

delete from serverconfig where mdsagconfigid = <id from above statement>

Before doing any of this, backup the database.

Then you should be able to clear the mdsagconfig table that you tried before. Any questions or concerns let us know.

[chunk73]

Worked like a charm. Thank you very much for your help.