Connecting to SQL Server Express in XP Home

I have SQL Server Express up and running on a PC, accessed via an ADP
I would like another PC on the LAN to do the same.
On the local machine everything works well, however the other machine cannot
connect.
I am using a trusted connection and the remote machine appears to be trying
to connect using DIMENSION9150\Guest
When I click "Test Connection" in Access I am presented with the following
error message:
"Test connection failed because of an error in initializing provider. Login
failer for user 'DIMENSION9150\Guest'"
Thanks in advance...The guest user has no connect privileges by default. You will have to grant
guest the privileges required.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>I have SQL Server Express up and running on a PC, accessed via an ADP
> I would like another PC on the LAN to do the same.
> On the local machine everything works well, however the other machine
> cannot connect.
> I am using a trusted connection and the remote machine appears to be
> trying to connect using DIMENSION9150\Guest
> When I click "Test Connection" in Access I am presented with the following
> error message:
> "Test connection failed because of an error in initializing provider.
> Login failer for user 'DIMENSION9150\Guest'"
> Thanks in advance...
>|||Roger, thanks for the prompt reply.
Without EM I am lost... is it possible in SQL Express ?
Thanks in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Try downloading this tool:
http://www.microsoft.com/downloads/...&displaylang=en
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443bc139$0$6801$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, thanks for the prompt reply.
> Without EM I am lost... is it possible in SQL Express ?
> Thanks in advance...
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Does it have to be the Guest account ?
I have the Guest account disabled for security reasons.
I tried to use a different account but was told that it was not associated
with a trusted connection.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||I'm not an expert in XP Home but my understanding is that it doesn't do
Windows authentication as anything but Guest.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c5429$0$6834$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Does it have to be the Guest account ?
> I have the Guest account disabled for security reasons.
> I tried to use a different account but was told that it was not associated
> with a trusted connection.
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, I've downloaded the MS Management Studio Express as instructed...
Interestingly when I view security\users for my database "Guest" is already
listed however unlike the other users listed it's icon has a little down
arrow on it ?
Under security\logins for the server "Guest" is not listed, does this mean
that the Guest account has not server access rights and I need to add the
Guest account here ?
Thanks for your patience...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
> The guest user has no connect privileges by default. You will have to
> grant guest the privileges required.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443b6684$0$6811$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||you can enable the guest user with
GRANT CONNECT TO Guest
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, I've downloaded the MS Management Studio Express as instructed...
> Interestingly when I view security\users for my database "Guest" is
> already listed however unlike the other users listed it's icon has a
> little down arrow on it ?
> Under security\logins for the server "Guest" is not listed, does this mean
> that the Guest account has not server access rights and I need to add the
> Guest account here ?
> Thanks for your patience...
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:eGi2RGXXGHA.1196@.TK2MSFTNGP03.phx.gbl...
>|||Roger, getting there...
After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
that the guest account no longer has the little down arrow in it's icon
however the adp is still unable to connect.
I have viewed the event log on the sql server machine and have the following
events logged:
Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date: 13/04/2006
Time: 9:17:02 AM
User: DIMENSION9150\Guest
Computer: DIMENSION9150
Description:
Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 18 48 00 00 0e 00 00 00 .H.....
0008: 0e 00 00 00 44 00 49 00 ...D.I.
0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
0020: 31 00 35 00 30 00 00 00 1.5.0...
0028: 07 00 00 00 6d 00 61 00 ...m.a.
0030: 73 00 74 00 65 00 72 00 s.t.e.r.
0038: 00 00 ..
When I check details in MS Management Studio Express I see the following
which may or may not be relevant:
a) under Dimension9150\Security\Logins
=> the Guest account is not listed
b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
=> the only role that has a member is db_owner who'se sole member is dbo
Thanks Roger in advance...
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
> you can enable the guest user with
> GRANT CONNECT TO Guest
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "McHenry" <mchenry@.mchenry.com> wrote in message
> news:443c9cc0$0$6826$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
>|||Then create a login for DIMENSION9150\Guest
CREATE LOGIN [DIMENSION9150\Guest] FROM WINDOWS
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"McHenry" <mchenry@.mchenry.com> wrote in message
news:443daad2$0$32060$5a62ac22@.per-qv1-newsreader-01.iinet.net.au...
> Roger, getting there...
> After issuing them command GRANT CONNECT TO Guest in SQLCMD I can now see
> that the guest account no longer has the little down arrow in it's icon
> however the adp is still unable to connect.
> I have viewed the event log on the sql server machine and have the
> following events logged:
> Event Type: Failure Audit
> Event Source: MSSQLSERVER
> Event Category: (4)
> Event ID: 18456
> Date: 13/04/2006
> Time: 9:17:02 AM
> User: DIMENSION9150\Guest
> Computer: DIMENSION9150
> Description:
> Login failed for user 'DIMENSION9150\Guest'. [CLIENT: 192.168.1.1]
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Data:
> 0000: 18 48 00 00 0e 00 00 00 .H.....
> 0008: 0e 00 00 00 44 00 49 00 ...D.I.
> 0010: 4d 00 45 00 4e 00 53 00 M.E.N.S.
> 0018: 49 00 4f 00 4e 00 39 00 I.O.N.9.
> 0020: 31 00 35 00 30 00 00 00 1.5.0...
> 0028: 07 00 00 00 6d 00 61 00 ...m.a.
> 0030: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0038: 00 00 ..
> When I check details in MS Management Studio Express I see the following
> which may or may not be relevant:
> a) under Dimension9150\Security\Logins
> => the Guest account is not listed
> b) under DIMENSION9150\Databases\IPS\Security\Rol
es\Database Roles
> => the only role that has a member is db_owner who'se sole member is dbo
> Thanks Roger in advance...
>
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:%23vUZPymXGHA.3656@.TK2MSFTNGP05.phx.gbl...
>