BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-03-2005, 11:09 PM   #1 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7100T
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy BES Stopped SQL ReportServer

Please Login to Remove!

We have recently Installed Blackberry Enterprise Server. Soon after the installation we noticed that the SQL ReportServer service had stopped.

The BES install went fine and is using sql 2000 on the same server as it is installed. This server also runs reporting services from SQL 2000 for the internal web site.

I am wondering how blackberry could have possibly effected this service?

The server is running 2003 SP1 and we get the following error:

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 30/09/2005
Time: 20:05:48 PM
User: N/A
Computer: LPLFP1
Description:
The ReportServer service failed to start due to the following error:
Access is denied.
Offline  
Old 10-04-2005, 03:11 AM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: Apr 2005
Location: The Netherlands
Model: 8800
Carrier: Vodafone
Posts: 374
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

You have an Access denied error, so you need to check the rights on your SQL database. Check also if you can logon local to your SQL server.


Regards,
Bob Hillesum
Offline  
Old 10-04-2005, 09:51 AM   #3 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

...that would seem like the obvious answer, no?
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 10-04-2005, 06:18 PM   #4 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7100T
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The sql database still works fine. It is just this one Reporting Service that does not work.

Unfortunately I dont have access to these systems at the moment but I was wondering if it is possible that blackberry has caused the problem?
Offline  
Old 10-04-2005, 06:30 PM   #5 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

if the ReportServer service is being run as a certain user, and that user does not have permissions to the SQL database, then *ding*. from the error, i would agree with BBLinks... check the permissions. SQL can work just fine and other services CAN have permissions issues when trying to connect to it.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 10-05-2005, 03:30 AM   #6 (permalink)
New Member
 
Join Date: Oct 2005
Model: 7100T
Posts: 3
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I have spoken with one of the guys on site. He has created a new User account with the necessary permissions and this has resolved the problem. It seems that somehow Blackberry has effected the permissions on the service account as it show in event viewer that the service stoped straight after the blackberry software was installed.

Thanks for your help guys
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.