[sateam]

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?

[wren]

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

[TargetIT]

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...

[sateam]

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.

[TargetIT]

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?