Showing posts with label blackberry. Show all posts
Showing posts with label blackberry. Show all posts

Tuesday, February 14, 2012

Blackberry Server MSDE and active directory authentication

To all, thanks in advance,
I have blackberry server running sql msde 2000 (sp4), which is
authenticated via windows integrated with an active directory user
account. When I changed the password on said user account, restart the
mssqlserver service, it fails to start with a 560 error. I had to
changed said user account back to the old password in order for the
mssqlserver service to start. I wanted know where in ms sql msde 2000,
I needed to make the change in order for this service to start. I also
tried starting the service using local system account and it would not
start either. All help with this is greatly appreciated.
JB
Hi
Control Panel > Services. The Service can be stopped and started from there,
and the account password can be changed there for the service.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
<jon.jefferson@.gmail.com> wrote in message
news:1131849352.800496.311170@.g47g2000cwa.googlegr oups.com...
> To all, thanks in advance,
> I have blackberry server running sql msde 2000 (sp4), which is
> authenticated via windows integrated with an active directory user
> account. When I changed the password on said user account, restart the
> mssqlserver service, it fails to start with a 560 error. I had to
> changed said user account back to the old password in order for the
> mssqlserver service to start. I wanted know where in ms sql msde 2000,
> I needed to make the change in order for this service to start. I also
> tried starting the service using local system account and it would not
> start either. All help with this is greatly appreciated.
> JB
>
|||Mike
Thanks for your response, but I did that and the service would not
start under with the new password. The only idea I did not try was to
restart the Server.
Thanks,
JB
|||Mike,
Also, there are other services that start with this same service
account (i.e. all the blackberry services,) and those start fine,
except for errors in the Apps event log because the msssqlserver
service would not start with the same user account change for some
strange reason. I am changing passwords to in AD because I am taking
over duties after someone has left and need to change passwords for
security purposes. This is my only hold up.
JB

BlackBerry Enterprise Server - SQL problem

Does anybody used BlackBerry Enterprise Server?

Windows Server 2003 Enterprise
Exchange Server 2003 Enterprise + SP1
SQL Server 2000 + SP4

Problem:
Everything is instaled properly (I hope so) exactly as is written in
manual (Creating database, adding users) but BlackBerry Manager can't
connect to SQL database.
After clicking on "Test SQL Server Connection" (at BlackBerry Server
Configuration) there is a message: "Connection successful".
But when i try to run BlackBerry Manager there is an error: "Unable to
connect to database!".

No matter if i'm using Windows Authentication nor SQL authentication.

Lukasz
--
Feel free to correct my english.Is your SQL server SQL 2000 Standard Edition or the MSDE?
Can you check if SQL is in "Mixed Mode"? Windows Authentication and SQL
authentication.
Also, some installs of the Black Berry software use an "instance" of SQL.
Was the install done this way?

"ukasz" <nospam@.a.com> wrote in message news:dkfvgr$nbo$1@.opal.futuro.pl...
> Does anybody used BlackBerry Enterprise Server?
> Windows Server 2003 Enterprise
> Exchange Server 2003 Enterprise + SP1
> SQL Server 2000 + SP4
> Problem:
> Everything is instaled properly (I hope so) exactly as is written in
> manual (Creating database, adding users) but BlackBerry Manager can't
> connect to SQL database.
> After clicking on "Test SQL Server Connection" (at BlackBerry Server
> Configuration) there is a message: "Connection successful".
> But when i try to run BlackBerry Manager there is an error: "Unable to
> connect to database!".
> No matter if i'm using Windows Authentication nor SQL authentication.
>
> Lukasz
> --
> Feel free to correct my english.