Not with Simple File Sharing. With Simple File Sharing, the
authentication is done with the guest account only.
If you are using Pro, disable simple file sharing. Then you
will need to have the exact same user name and passwords as
users on all the PCs in the workgroup. You will also need to
adjust your XP firewall settings.
-Sue
On Fri, 24 Mar 2006 00:20:05 -0800, BryanW
[quoted text, click to view] <BryanW@discussions.microsoft.com> wrote:
>This is my first venture into MS SQL Server hence the basic question.
>Can I use Windows Authentication in a Workgroup (i.e. XP Pro and Simple File
>Sharing)?
>When I try I get the infamous "Msg 18452, Level 14, State 1, Server
>RS02-2006, Line 1 Login failed for user ''. The user is not associated with a
>trusted SQL Server connection." when trying to connect from a client
>computer.
>sqlcmd -S RS02-2006 works from the "server" computer but not from the
>"client" computer. I can connect from the "client" using SQL Server
>Authentication, e.g. sqlcmd -S RS02-2006 -U sa -P password.
>Is it that you cannot be trusted in a Workgroup network?
>Thanks
>BryanW
Thank you. When I added a Login for Guest I was able to connect.
--
Thanks
[quoted text, click to view] "Sue Hoegemeier" wrote:
> Not with Simple File Sharing. With Simple File Sharing, the
> authentication is done with the guest account only.
> If you are using Pro, disable simple file sharing. Then you
> will need to have the exact same user name and passwords as
> users on all the PCs in the workgroup. You will also need to
> adjust your XP firewall settings.
>
> -Sue
>
> On Fri, 24 Mar 2006 00:20:05 -0800, BryanW
> <BryanW@discussions.microsoft.com> wrote:
>
> >This is my first venture into MS SQL Server hence the basic question.
> >Can I use Windows Authentication in a Workgroup (i.e. XP Pro and Simple File
> >Sharing)?
> >When I try I get the infamous "Msg 18452, Level 14, State 1, Server
> >RS02-2006, Line 1 Login failed for user ''. The user is not associated with a
> >trusted SQL Server connection." when trying to connect from a client
> >computer.
> >sqlcmd -S RS02-2006 works from the "server" computer but not from the
> >"client" computer. I can connect from the "client" using SQL Server
> >Authentication, e.g. sqlcmd -S RS02-2006 -U sa -P password.
> >Is it that you cannot be trusted in a Workgroup network?
> >Thanks
> >BryanW
>
OK but enabling guest accounts is not a good security
practice. Using SQL logins would be another alternative.
-Sue
On Sun, 26 Mar 2006 16:44:01 -0800, BryanW
[quoted text, click to view] <BryanW@discussions.microsoft.com> wrote:
>Thank you. When I added a Login for Guest I was able to connect.
Don't see what you're looking for? Try a search.
