"Mike Thomas" <mike@ease.com> wrote in message
news:ettEHy1FFHA.936@TK2MSFTNGP12.phx.gbl...
>
> I'm a programmer rather than a DBA and have been having trouble with using
> a second computer to access and test some applications on SQL server. I
> am using SQL Server 2000 Developer's Edition.
>
> I have an SQL Server instance on Computer1 to which I am connecting to
> from Computer2.
>
> The SQL server is using mixed authentication. SQL authentication is
> working as it should.
>
> Although I am alsays logged on to Computer2 as "mst", when using Windows
> authentication, and logging on to SQL Server from Computer2, it seems that
> the user is always authenticated using the "Computer1\Guest" login.
>
> There is a login in SQL Server for "Computer1\mst". Is there a way to
> arrange it so that when a user logs in to SQL server from Computer2, SQL
> Server sees the login as being for the actual user login rather than the
> Guest account?
>
> Many thanks
> Mike Thomas
>