Cannot connect to msde sql 2000

[Luvsql]

Our previous IT employee setup our Blackberry BES server with SQL MSDE. We can no longer connect to it as we get authentication errors. We are logged into the machine as the administrator and the same domain administrator that the BES services are started with. By Default, MSDE is installed with Windows authentication, but what do we do if we cannot connect to it with any domain administrator account?

I've tried connecting to it with SQL 2000 Enterprise Manager and that won't work either.

 

[Mich]

You should upgrade from MSDE.

Can you connect via EM using mixed authentication?

-If it ain't broke, break it and make it better.

 

[yelworcm]

we have an annoying BES server here, as well. It is installed in our DMZ, so it only runs with the Shared Memory protocol, meaning we can not log into it remotely. Is this the problem you are facing, or are you logged into the BES server itself?

 

[Luvsql]

I'm trying to connect to it with Enterprise Manager so that I can setup the backups, reports etc.

 

[Jamfool]

I presume that you are connecting to a named instance with a connection string like the following?

servername\BESMgmt

Check which account in services.msc is running sql and try with that. Have you tried with a local admin account?

Check that allow remote connections is enabled + protocol that you are using (as above is shared memory only enabled, in which case you will need to be doing this on the box)

 

[mutley1]

Correct me if I'm way off the mark here, but I thought backups etc. had to be done via a TSQL job in MSDE? I don't think you would be able to use a maintenance plan - it would need to be a job (which the MSDE SQL Agent can run), but with TSQL steps?

http://support.microsoft.com/kb/325003

HTH

M.