express 2005: keep on getting sql server does not exist or access denied when trying to backup db

Question

SQL Express 2005 was installed automatically when I installed BES Express 5.x on Windows 2003 R2.  I am following the following pages to try to back up the DB:

http://docs.blackberry.com/en/admin/deliverables/18764/Backing_up_the_BBConfigDB_1154201_11.jsp

I've tried

BlackBerryDBBackup.exe -d BESMgmt -f C:\DB_backup_folder -U sa
BlackBerryDBBackup.exe -d BESMgmt -f C:\DB_backup_folder -E
BlackBerryDBBackup.exe -d BESMgmt -f C:\DB_backup_folder -U domain\BESAdmin
BlackBerryDBBackup.exe -d BESMgmt -f C:\DB_backup_folder -U domain\BESAdmin -P password

but none of them work.

When I go to Database > BESMgmt > Security > Users, I see

dbo, login name: domain\BESAdmin, DB role membership: db_owner

When I go to Security > Logins, I see

builtin\administrators, builtin\users, nt authority\system, sa

I have no idea what the sa pw is since it got created automatically.

Answer 1

can you try creating the folder C:\DB_backup_folder  first ?

---

Regards,
Ahmed Ibrahim
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.

Answer 2

Hello,

Please, could you have a look at http://blackberryrocks.com/how-to-backup-restore-blackberry/ ?

For sa, it can be created but disabled ( classical for SQL Server Express ). In this case, you should be able  with SQL Server Management Studio Express (SSMSE) to enable sa and to modify the password ( open a connection to your database thru SSMSE, in the left panel, double-click on the name of your SQL Server Express to develop the node, double-click to develop the Security node and click on the sa login node.You will arrive to a new form related to sa login )

I think it is a question to post on the BlackBerry forum.

Have a nice day

PS: Blackberry forum ==> http://www.blackberryforums.com/general-blackberry-discussion/17059-blackberrydbbackup-exe-blackberrydbrestore-exe.html

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 3

hi, the below link may do needful for you. Please check it out.

http://serverfault.com/questions/20605/cant-access-sql-server-2008-from-workstations-but-can-from-server

Answer 4

Hello ayutechi,

your link does not bring any information for the original poster. Unuseful...

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.