Remote Repositories

  • Thread starter Thread starter Heidi Linda
  • Start date Start date
H

Heidi Linda

I've had the XPe tools installed on my workstation for
some time, but I'm now supposed to be teaching a coworker
how to use them. As he's rather lower on HD space than I
am, I thought it made more sense to have him connect to
the tools on my machine, however, he doesn't seem to be
able to connect to the database.
He's set up as a user on my machine, and the repositories
are set as shared to everyone. Any idea what could be
stopping this from working?
 
Hi

you have to create a user account for him at the embedded db.
per default, the user who installes the xpe stuff has rights, but if another
user want to use the db, a new account is necessary.

mario
 
Hi Heidi,

Have you tried to set for folder Repositories:

1. Properties: Security everyone(or users that you want).
2. Propertes: Sharing everyone

Try with full access for everyone. When it begin to work, then you can
reduce privileges.


Best regards,
Slobodan
 
If you are using Windows XP.

Go to Folder Options->View
And uncheck: Use simple file sharing (Recommended)

This will allow you to see Security tab.

I'm sorry to say this obvious thing you probably already know. But just in
case, it can't hurt to say.



Best regards,
Slobodan
 
Aha, lovely, thanks.
-----Original Message-----
Heidi,
The Embedded suite created predefined Database Roles on your dev machine (as
viewed through Enterprise Manager) that you can assign SQL Server Users to.
These roles are WES_Reader, Wes_Importer and WES_Admin.
http://msdn.microsoft.com/library/default.asp? url=/library/en-us/xpehelp/html/xerefDatabaseRoles.asp

That link has a little more info as well as a follow on link explaining how
to assign users to these SQL User roles.

Andy

--

This posting is provided "AS IS" with no warranties, and confers no rights.
==========================================================





.
Click to expand...
 
Sorry, I was focused on some other problem :$

When I realized what I said Andy already gave you solution.


Slobodan
 
The first step in the link explaining how to assign roles says "start SQL
Server Enterprise Manager." Is this part of the XPe distribution? If not
how do I get it? Shouldn't the XPe distribution contain all the tools
needed to administer its use?

Sam
 
Andy - these instructions specify being in a domain -
we're in a workgroup. Would this maybe explain why it's
not working?
 
No, that shouldn't matter, though domain credentials are going to be much
easier to manage. In your case, you can either create a local user account
on your machine that is for the person of interest here and have them access
your machine that way by assigning that new local user account to a SQL
Role.

OR

If there are so few people in the company with access to the tools, then you
could simply assign the "Everyone" account to the "User" group on your dev
machine, then in SQL assign that Windows "User" group to the WES_Reader
role, for instance.

So basically it's pretty flexible, just determine how you want users in the
company to connect to your dev machine's general resources via the Windows
Groups, and assign that group to a SQL Role.

Andy
 
Hi Heidi,

I don't know if this matters, but have you set same password on all
machines?

Best regards,
Slobodan
 
Well Roger can view my shares just fine, so everything
seems to be alright there. I'll have to get the IT dept
involved, or donate some RAM to Roger's system so he can
have the reps locally.
 
Hi Heidi,
Well Roger can view my shares just fine, so everything
seems to be alright there. I'll have to get the IT dept
involved, or donate some RAM to Roger's system so he can
have the reps locally.
Click to expand...

Than this is not it.

BTW: Have you tried to use your account on Roger's system.

I have never tried to use different accounts because I'm the only one that
use XPE.
But I am able to use XPE remotely on other machines, although I can't
remember what I have done to make it work. I had no trouble, that is only
thing I can remember.
Also I am using SQL that came with XPE, so this could be difference. As I
understand it uses Windows Authentication, and your SQL can be configured.


Best regards,
Slobodan
 
Back
Top