XP Embedded Database Problem.

[Guest]

Please could somebody help with the following problem?

I have just installed a new install of XP Professional SP2 on my computer,
installed all the latest security updates using Windows Update. Installed XP
Embedded in the order of the splash screen menu. Once installed I run a test
build which seemed to go OK, however after restarting the PC I now get the
following message when I try and run Target Designer or Component Database
Manager.

"Target Designer cannot log on to the component database on 'PC001'.
Possible causes: the database is already open by another user in exclusive
mode, or the database does not exist on server, or you do not have permission
to access the databse."

I am not sure how to check for the above or how to rectify this problem,
would appreciate some assistance.

Thanks.

 

[glenn.woodruff]

Well, I can't help, because I'm having exactly the same problem. I
can't run Target Designer or Component Designer, but I was able to
upgrade the server to SP2 and also connect with the Component Database
Manager. This is very strange since they (according to old ng posts)
use the same mechanism to connect to the db.

Reinstalling the entire database didn't fix it, neither did
reinstalling the local client.

I went back to my old system, and it talks to the database just fine.
I need to reinstall all my custom clds now. This is acceptable for the
time being but it's really obnoxious, I'd really like to know how to
fix it as well.

 

[KM]

skylark,

Obvios check - does the SQL server service is running fine on your dev machine? (I assume it is one-machine install including DB
engine and Tools)
If not, check out Event Logs to see the cause. Also, you can use MSDE logs to find out the problem.

If Firewall is enabled on your machine, disable any security settings for My Computer zone.
Or disable the Firewall (at least for testing purposes).