Solved

Problem with running script on MS SQL Express 2005 on Blackberry Server

Posted on 2010-08-13
1
582 Views
Last Modified: 2012-06-21
We created a Blackberry Server Express instance and loaded MS SQL Express 2005 on it to run the BES.

To load the Blackberry Administration Service, we need an admin user and password.  We loaded with the Active Directory setting instead of the BAS setting which didn't create the admin user.

We see plenty of the same problem on google and the answer is listed here: http://www.blackberryforums.com.au/forums/general-bes-discussion/8687-unable-login.html and it seems to work for lots of people running the script against the BES Mgmt Database.

However, when we try by being in the Microsoft SQL Server Management Studio Express with the BESMgmt highlighted on the left and then doubleclicking the script in the windows explorer and then hitting the EXECUTE key in the Studio Express when the script shows in the window.

However, everytime we get an error that says:  
Msg 2812, Level 16, State 62, Line 28
Could not find stored procedure 'SetUpBASorADAuthentication'.

According to the original hyperlink above, this occurs when the "BESTMGgmt database is not selected in the SQL Server Management".  Isnt' having it higlighted on the left pane enough of a selection?    Are we not "running it correctly". What are the steps?

THanks!
0
Comment
Question by:gleasoninc
1 Comment
 

Accepted Solution

by:
gleasoninc earned 0 total points
ID: 33430974
close this.  We managed to add in the user by going into the interface and choosing ADD ADMINISTRATIVE USER and then setting the password.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question