Access SQL Server from Stand-Alone PC with Windows Authentication

I have a PC that is not joined to the domain. I want to be able to access
our SQL Server from it, but it is my active directory domain account that ha
s
access. How can I gain access to the SQL Server via Enterprise Manager or
Query Analyzer?Hello,
If the machine is in a workgroup, SQL server machine is in the domain, make
sure you can ping the SQL server machine from the machine you log on
successfully via IP address or machine name.
Create a same Local user account both on the machine and the SQL server
machine. The Local user account and password on both machines need to be
same . On the SQL server machine, add the Local user account as the SQL
server logins and grant the user right to access the database. By doing so,
you can access the SQL server via Query Analyzer with Windows
authentication.
Or you can access the SQL server using a SQL logins via Query Analyzer with
SQL authentication.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.