MSDE remote connection on Windows Home - Windows Authentication

I installed an MSDE on a PC running Windows Home Edition. I would like
to connect to this MSDE installation from an oher PC using Windows
Authentication.
What do I have to do (add account on Home Edition)
hi,
xavierdaull@.gmail.com wrote:
> I installed an MSDE on a PC running Windows Home Edition. I would like
> to connect to this MSDE installation from an oher PC using Windows
> Authentication.
> What do I have to do (add account on Home Edition)
without a Domain Controller, thought in a Workgroup environment, usually you
should rely on standard SQL Server authenticated connections for remote
ones, as all the authentication features are resolved and managed by the
Domain Controller it self..
you can however setup a local account to map the remote account of the other
machine... that's to say, on your local PC you have to add another account
with the very same "credentials" of other account(s) present on the remote
PCs...
all this (still) works becouse of the underlying OS gets somehow confused
and a sort of "embezzlement" where 2 differents accounts, YourPC\YourAccount
and OtherPC\YourAccount "share" a kind of uniqueness becouse of netbios
intrusion... a preventive netbios connection, even on a share or using NET
USE can help...
but this is not granted to work in future releases or even OS service
packs...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply