Backup BES 5.0 database
HI everybody.
I have a problem when I want to backup database. I am trying wiht following command BlackBerryDBBackup.exe -d BESmgmt -f C:\DBBackup -U xxxxxx -P xxxxxxx where xxxxxxxx are domain username and password as I have choosed to use Windows authentication for SQL during installation proccess. Error i get is : Connecting to SQLServer... Failed connecting to the SQL Server: Microsoft SQL-DMO (ODBC SQLState: 08001) [Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or a ccess denied. [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). SQLServer Login failure Server: local Userid: besadmin anyone has any idea? |
1) try full UNC path instead of c:\dbbackup
2) forget username and password and just use -E for trusted connect BlackberryDBBackup.exe -d BESmgmt -f \\<servername>\<shared folder> -E |
Free SQL Server database backup, Zip and FTP software
Install it, use it, love it. And this coming from a guy who scripts almost everything... |
I have tried both way and problem remains. tried with SQlbackup and FTP software but it can't connect to SQL server neither. Server name :BLACKBERRY, using Windows authentication. Can you tell me which services should be stopped/running when I want to backup DB? I have tried with all SQL services running and with all stopped but I get same error, login failure.
|
Try a SQL account - even with Windows Authentication, it allows you to create SQL Accounts (the sa account for example) and use them. I've also found that some passwords just don't get sent right thru the command line (exclamation marks for example). And lastly, did you use a fully qualified username? DOMAIN\Username?
|
All times are GMT -5. The time now is 08:28 PM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.