> Alain:
> I have a workgroup; the W98 client is configured on Settings | Network | =
> Access Level to get the login information from the server. Actually they =
> share the internet connection on the XP Professional.=20
> The primary logon in the client is Microsoft Network.
> I log in in the client with this user a registered on the server as part =
> of the Administrators group.
> Since i can see either computer on each of them, i'm assuming the client =
> logged in with the rights i gave it on the server (xp professional).
> I tried adding the 'guest' account to the role on the master database, =
> just to try it, but same results 'Login failed for user <SERVER>\Guest'
> Thank you very much for your help.
> "Alain Quesnel" <cinqsanss...@compuserve.com> wrote in message
> news:3d2a6279_1@dnews...
> > Do you have a Windows domain running on your network, i.e. do you have a
> PDC
> > on your network (primary domain controller)? Is your Win98 client part
of
> > that domain? When you open a session on your Win98 client, do you log in
> as
> > "guest", and is "guest" a member of the domain?
> > --
> > Alain Quesnel
> > cinqsanss...@compuserve.com
> > "Carlos Garcia" <carlos...@hotmail.com> wrote in message
> > news:3d2a5924_2@dnews...
> > > Thank you for reading.
> > > Upon running ADO app on client, i get message 'Login failed for user
> > > <SERVER>\Guest
> > > ( since the instance of sql server and the server machine itself have
> the
> > > same name, i suppose <SERVER> refers to the machine -couldn't make
> > > different)
> > > On MS-SQL 2000 Evaluation edition, i'm using
> > > - Windows authentication
> > > - Startup service account is administrator
> > > - server is XP professional
> > > Client is W98 with latest MDAC (however, computer properties to this
> > client
> > > on XP say is a W95, don't think it matters)
> > > I created this user on the server and added it to the Administrators
> > group,
> > > then i logged in on W98 client with no problem to see the server.
> > > The ADO application uses UDL on /system pointing to the SQL Server, if
> > finds
> > > it just fine.
> > > When running on client, i get 'Login failed for users <SERVER>Guest
> > > Do you know where can i find info to solve this?
> > > How to configue MS-SQL to accept login from windows user?
> > > Hot can i make sure the login is being attempted using that particular
> > user?
> > > Thank you very much for your help.
> > > Carlos Garcia
