Connect to a remote DB server

To implement windows authentication between machines (which is always a worthy cause), one of the following needs to be done:

1. Ensure both computers are part of the same domain/trusted accross domains

This doesn't seem worthwhile for just two computers!

2. The exact same logon and password must be set up on both computers.

Sounds silly hey but without a central domain to authenticate to its the only way to do it.

thank you for your reply,

1. Both computers are in the same workgroup. One is XP Pro, another one is XP Home Edition. I'm not sure how to setup a domain for them both.

2. I didn't quite understand this one. They in fact don't have any passwords - they use all default settings, they of course have different names and different logins for loggin into the Windows but apart from that, there's no authenitaction.

Any way to have it done? I mean in theory I would suggest creating probably an account on my db server (the one I'm trying to access) for another computer to access, I'm just not sure how to do it...

Regs,
Yurich

OK, got it working.

Here is the steps to perform it:

1. On the db server setup a new login in the Logins of the Security folder - can be any name, use SQL server authentication as Windows authentication will work only for the domain computers

2. In the 'Database Access' tab mark all databases that will be accessible from another computer and set (tick) this login as 'Owner' (I tried public and couldn't see conents of any table)

3. On the client computer, create new registration, and select SQL server Authentication - use credentials that you created in the step 1.

4. The registration should complete with no errors or warnings and now you can access databases specified in the step 2 from the client machine.

That's it ;)
Yurich

1. Like I say don't bother setting up a domain if you only have two computers.
2. Are you saying when you log into windows as that user, you don't type in a password?

So you actually got it working with SQL Server authentication instead. That is the most practical method for your setup.

2. No, I don't - do you type a password after you started your home pc?

I actually didn't care how - windows authentication was set by default - I just cared about connecting.

Regs,
Yurich

I don't mind refunding the points but perhaps Yurich you could be a little clearer when asking questions in future. If you reread your original question then you might see that it could be a little ambiguousas to what you are asking for.

I'm never mingy for the points and I would give 'em to anyone who'd help me. Sorry if my question was not clear. I needed instructions how to do it (as I posted in my own solution) and whether it would be done with windows authentication or with sql securities didn't matter to me - at least if something was suggested (beside of not adding my two home computers into the domain where there weren't anyway or setting the same login, which sounded rather strange and probably would create collision in the network).

Regards,
Yurich

If it had been clear that SQL authentication was an option that is the first thing I would have suggested. Anyway it doesn't matter, I'm glad you managed to resolve it yourself.