Solved

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

Posted on 2010-08-13
1
584 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

737 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