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

MSDE on WinXP Pro SP2 joined to a domain

Hi,
I have a problem that I cannot find a resolution to.
Recently, I got a laptop and I installed WinXP Pro SP2 on it.
I did this at home so was not near my office domain so I temporarily setup
the laptop as a workgroup computer instead of joining the domain.
Once installed, I then installed MSDE2000RelA.
Everything was working fine.
Then I took the laptop to work, joined the domain, and now MSDE can no
longer connect. All I get in the system tray is a computer tower icon with a
white circle on it. Hovering over that pops up "Cannot connect \\". There
should be a green arrow in the circle when services start.
I have tried uninstalling, re-installing, changing user permissions in group
policy for the guest account? - all sorts of things, but nothing fixes this
issue - and I desperately need MSDE to work on the laptop.
I think it has something to do with the laptop being on the domain, but I
don't know (and that doesn't really make sense to me either).
Can anyone point me to a solution?
Cheers,
Rob
hi Rob
Did u set DISABLENETWORKPROTOCOLS=0 parameter while setup?
by default the setup will take 1 (means disable).
just check out
Dil
|||Ah, no I didn't!
Do I have to reinstall or can I update a previous installation with this
setting?
Cheers,
Rob
|||hi Rob,
RobGT wrote:
> Ah, no I didn't!
> Do I have to reinstall or can I update a previous installation with
> this setting?
please run the Server Network Utility (svrnetcn.exe) to enable the desired
network protocol..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Perfect, thankyou.
It appears to now be working fine.
Shame I found it so difficult to locate this information (I searched online
for ages before coming here to ask the question!)
Thanks a million for resolving this so quickly for me!
Cheers,
Rob

MSDE Installation fails

When trying to install MSDE2000 in an XP Home edition machine the
installation fails (progress bar almost gets at the end but it then rolls
back) with no message.
There is should be a log file but I do not know how to get. Also where can I
find descriptions of the error messages?
In a previous message a similar problem was solved by installing File and
Print sharing. Unfortunately I do not know what this means.
Any ideas?
Thanks
Yannis
hi Yannis,
"Yannis Makarounis" <Yannis.Makarounis@.ace-hellas.gr> ha scritto nel
messaggio news:e%23gecCVoEHA.800@.TK2MSFTNGP14.phx.gbl
> When trying to install MSDE2000 in an XP Home edition machine the
> installation fails (progress bar almost gets at the end but it then
> rolls back) with no message.
> There is should be a log file but I do not know how to get. Also
> where can I find descriptions of the error messages?
> In a previous message a similar problem was solved by installing File
> and Print sharing. Unfortunately I do not know what this means.
> Any ideas?
> Thanks
> Yannis
open the control panel applet -> services... check the "Server" service is
running... this service allows file and pront sharing activities...
if not present, select your network connection properties... File and
Printer sharing for Microsoft network must be installed if not present..
when running the MSDE setup.exe, please add the
/L*v "c:\MsdeLog.txt"
parameter, in order to log the installation process to file, about 2mb, you
can later inspect for troubleshooting, looking for
RETURN VALUE 3
entries
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE install problem

I am trying to install on a fresh copy of XP Home SP1. When I type the cmd line command to start the installation, the progress bar moves to almost completion and then it rolls back to the left and dies. What's going on here??

Help!!

Thanks
Mike Kiewiczhard to say. does it leave behind an install.log? what about the system's event viewer? anything in there?|||I am having the same behavior.

Event viewer has 5 entries

1. Warning
No object list was found in the installation file. Adding an object list to the installation file will improve performance of the system when measuring performance counters.

2. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

3. Error
The performance counter name string value in the registry is incorrectly formatted. The last valid index value is DWORD 0 in the Record Data.

4. Error
Installing the performance counter strings for MSSQL$BOBBY1 failed. The Error code is DWORD 0 of the Record Data.

5. Information
Product: Microsoft SQL Server Desktop Engine -- Installation operation failed.|||I had this same problem. You have to have File and Print Sharing installed and running on the machine.

Kory|||File and print services are installed, however I can not view the properties

MSDE Install Failure - Unable to Configure Server

I have seen a few posts loosely related to this issue - but check this one out.

On a windows xp home box, I installed MSDE without an issue. I then upgraded said pc to MDAC 2.7 SP1 (XP) and got the above mentioned "Unable to Configure Server" error.

We have 3 users who are also getting this error when attempting to install the MSDE from our media, so I really need some help on this one!

I'm reasonably sure it is mdac, but I cannot determine the specifics yet. We also have this same issue on one lonely 98 box here in our office.

Does anyone have any experience with this typ of MDAC issue? Anything you could share would be great.Make sure to stop any anti virus application running.

MSDE fail after upgrade from WIN98 to WINXP HOME

Anyone can help?
I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE failure and i can't reinstall MSDE again, already call microsoft support and try something but no help at all.
John
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
Not to be rude, but your first mistake was attempting to upgrade Win9x to
XP.
MSDE installed under Win9x is a completely different animal than an
installation on the NT style operating systems. With Win9x there are no
service applications so MSDE runs as a standard application when the system
starts up. When you upgrade your OS to XP there is no magical conversion of
the MSDE installation to it running as a service. Your best bet is to backup
your databases and then manually uninstall MSDE. Microsoft has an article on
how to do this at:
http://support.microsoft.com/default...b;en-us;290991
After uninstalling MSDE re-install it and restore your databases.
Jim
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
> Anyone can help?
> I installed MSDE in WIN98 and then upgrade to WINXP home, after that, MSDE
failure and i can't reinstall MSDE again, already call microsoft support and
try something but no help at all.
> John
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
|||Hi Jim,
Thanks for your advice, i will try it !!
John

>--=AD=EC=A9l=B6l=A5=F3--
>Not to be rude, but your first mistake was attempting to=20
upgrade Win9x to
>XP.
>MSDE installed under Win9x is a completely different=20
animal than an
>installation on the NT style operating systems. With=20
Win9x there are no
>service applications so MSDE runs as a standard=20
application when the system
>starts up. When you upgrade your OS to XP there is no=20
magical conversion of
>the MSDE installation to it running as a service. Your=20
best bet is to backup
>your databases and then manually uninstall MSDE.=20
Microsoft has an article on
>how to do this at:
>http://support.microsoft.com/default.aspx?scid=3Dkb;en-
us;290991
>After uninstalling MSDE re-install it and restore your=20
databases.
>Jim
>"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in=20
message[vbcol=seagreen]
>news:OzBSSNkjEHA.1404@.TK2MSFTNGP09.phx.gbl...
home, after that, MSDE
>failure and i can't reinstall MSDE again, already call=20
microsoft support and[vbcol=seagreen]
>try something but no help at all.
newsgroup engine
>supports Post Alerts, Ratings, and Searching.
>
>.
>