[jpettes]

strange access issue.
New server, clean install win2k3
created besadmin in AD
granted user besadmin local admin rights
Set besadmin: Log on Locally and log on as Service on new server
Installed Exchanged 2003 System manager (and SP2)
Install BES 4.1.4 Professional
I let BES install SQL 2005 server
After the requested reboot and the SQL database is created I get a failure audit in the Application logs:

Source: MSSQLSEVER
Event ID: 18456
user: domain\besadmin
Descrption:Login failed for user 'domain\besadmin'

I am not sure, but I thought if the BES software installed the SQL and created the database that it would grant correct access to it?
I figured I must have messed something up, especially after messing around and re-installing BES two more times... in the end I redid the server from scratch and had the same issues.... and of course BES can not run correctly with out access to the Database

ANY help would be great!!!!

Thanks

Jerry

[SimonMac]

How did you setup SQL for Authentication? Mixed Mode/Windows?

[jpettes]

I let it pick windows auth.

[jpettes]

Originally Posted by SimonMac

How did you setup SQL for Authentication? Mixed Mode/Windows?

Well, we created a SQL account: BESsa and granted full access to the DB
re-installed the BES software and used SQL Auth.
It seems to have worked All services are starting without errors

Only weird thing is everytime you open BES manager it asks for the SQL AUth PW... I guess I can live with that....

Maybe an issue with BB's new Pro version???