BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   RIM Software (http://www.blackberryforums.com/rim-software/)
-   -   Bes 4.1.4 -SQL2005 database issue (http://www.blackberryforums.com/rim-software/105001-bes-4-1-4-sql2005-database-issue.html)

jpettes 11-15-2007 11:10 AM

Bes 4.1.4 -SQL2005 database issue
 
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 11-15-2007 11:23 AM

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

jpettes 11-15-2007 11:27 AM

I let it pick windows auth.

jpettes 11-16-2007 07:28 AM

Quote:

Originally Posted by SimonMac (Post 740978)
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???


All times are GMT -5. The time now is 01:38 PM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.