Link to home
Create AccountLog in
Avatar of cknoderer
cknoderer

asked on

Blackberry BES server has "lost" it's SQL database.

I am not sure when it happened. I can guess that it happened when I tried to upgrade from BES 4.1.4 to 4.1.6 and it failed.  Or when I did an upgrade of the Endpoint Antivirus, which is our central AV server.
I can see the BES database and it is pointed correctly. It's just the SQL server (SQL express) that doesn't show it.  

How do I get SQL to add the database back and get it to running?  I can't add any new users. Everything else runs fine.
Avatar of jasin00
jasin00

are your sql services running? try reattaching your db and logs.
Avatar of Kevin Cross
Open SQL Server Management Studio and connect to instance.  Right Click databases folder and click on Attach.  Click Add and select the MDF file(s) desired.
When you setup BES is it setup to resolve sql database using DNS lookups.  If so, switch to an IP address.  What happens when you use the test option in BES to connect to SQL server?
ASKER CERTIFIED SOLUTION
Avatar of cknoderer
cknoderer

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer