database connection erro

  • Thread starter Thread starter Michael GUIARD
  • Start date Start date
M

Michael GUIARD

Hi !

Before, I was using windows xp embedded tools and SQL server on the same PC
and all worked well. Now I have installed the SQL server on a win 2k station
and the embedded tools on my xp pro and I have some problems : I cannot
connect the database server. I think these error come from certificates or
rights problem but I did not find the solution.

How can I resolve this problem ?

thanks
Mike
 
Mike,

Go to SQL Server Manager and expand the server, databases, MantisSQLDB.
Right click Users and choose new database user. Follow the prompts from
there to add the domain account you use to log onto the machine the tools
are installed on, or if your in a workgroup environment add the local user
on the SQL server that corresponds to the local user on the machine the
tools are installed on. Clear as mud? I thought so! If you have more
troubles let us know and I'll try to get you set up.

HTH,
--
Brad Combs
Imago Technologies, LLC

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Tell
Microsoft!
https://www.windowsembeddedeval.com/community/newsgroups
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
 
Hi Brad !

thanks for your answer, but I do not have the "SQL Server Manager". Is this
program is furnished with XPe ? or where can I find it ?

thx
Mike
 
Michael
I'm a still newbie but I've experienced that working with a client-server installation of the WinXPe Tools package it's a bit difficult with MSDE. However, I'm currently doing it
My PC is part of a network domain (not net workgroup). In this case you can use a tool, for exampl

http://www.whitebearconsulting.com/Downloads.ht

for managing the user accounts granted to use the component database. With MSDEMgr, simply connect to server database with "Default Acces Mode", that is SQL account management, giving USERNAME "sa" and the password you set at MSDE install time. Then add your user, as MYDOMAIN\myusername, and give to him administrative rights.
Then, connecting on client machine as MYDOMAIN\myusername you will be able to use the remote database

Hope to help you
Michel
 
ok Michele, I will try this...

thanks a lot :)


Michele Bavaro said:
Michael,
I'm a still newbie but I've experienced that working with a client-server
Click to expand...
installation of the WinXPe Tools package it's a bit difficult with MSDE.
However, I'm currently doing it.
My PC is part of a network domain (not net workgroup). In this case you can use a tool, for example

http://www.whitebearconsulting.com/Downloads.htm

for managing the user accounts granted to use the component database. With
Click to expand...
MSDEMgr, simply connect to server database with "Default Acces Mode", that
is SQL account management, giving USERNAME "sa" and the password you set at
MSDE install time. Then add your user, as MYDOMAIN\myusername, and give to
him administrative rights.
 
Back
Top