PRB: Embedded Tools Cannot logon to the database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The tools fails to connect to the database. This has occured after I had
exited the tools and performed some add/remove of other applications and
several restarts (of course) of my system. Any suggestions on how to
receover short of re-installing the tools? The Error dialog indicatea
Possible causes: the database is already open by another user in exclusive
mode or you are not added as a user of this database. I wish someone else
did have the database open in exclusive mode then that would mean I was not
soley responsible for this task!

If someone can suggest what I might try it would be appreciated.

Thanks.
 
John,

You may want to provide us with more details on your XPe database instalaltion:
- Do you have MSDE or SQL Server installed?
- Is the server running on the same machine as the tools or a separate?

Suggestion:
- Do you have any AV software running on your dev machine? If so, turn it off.
- If it is a separate server, did you try restarting the SQL server service there?
- Make sure you've got requires mixed-mode security setting (mixed-mode authentication) configured on the SQL Server

Also, see if this helps:
http://msdn.microsoft.com/library/e...elopmentToolsFailToConnectToSQLServerMSDE.asp
 
I have recovered by installing the Embedded Database again. I tried to
repair the SQL server but that did not help.

KM said:
John,

You may want to provide us with more details on your XPe database instalaltion:
- Do you have MSDE or SQL Server installed?
Click to expand...

SQL and yes I tried to stop and restart server several times
- Is the server running on the same machine as the tools or a separate?
Click to expand...
server on same machine as tools
Suggestion:
- Do you have any AV software running on your dev machine? If so, turn it off.
Click to expand...

AV software was turned off
- If it is a separate server, did you try restarting the SQL server service there?
- Make sure you've got requires mixed-mode security setting (mixed-mode authentication) configured on the SQL Server

Also, see if this helps:
http://msdn.microsoft.com/library/e...elopmentToolsFailToConnectToSQLServerMSDE.asp
Click to expand...

I'll keep this for future reference.
 
Back
Top