RE: Access SQL Server from Stand-Alone PC with Windows Authentication

From: Sophie Guo [MSFT] (v-sguo_at_online.microsoft.com)
Date: 11/23/05 

Date: Wed, 23 Nov 2005 06:53:00 GMT

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.

Relevant Pages

  • Snapshot agent: The process could not connect to Distributor SERVER1
    ... 2000 that runs in mixed mode. ... SQL Server and SQL Server Agent startup accounts are the same which is ... also a local user account that has administrative privileges. ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL2005 sys tables
    ... Maybe you don't have the SQL Editor toolbar open. ... You can also change the database context by using the USE statement in the ... SQL Server Documentation Team ... I mean in sql2000 query analyzer I can do the select statement against ...
    (microsoft.public.sqlserver.security)
  • RE: select during transaction**
    ... > in query analyzer I want to update ... beacuse sql server decide on clustered index scan, therefore this statement must wait on releasing locks made by UPDATE ... because sql server chose clustered index seek and it didn't touch/need ... the data locking by UPDATE from first window. ...
    (microsoft.public.sqlserver.programming)
  • Summing tables in a UDF
    ... developed in Sybase into a SQL Server UDF. ... to run call the function in Query Analyzer even though it ... declare rentrev integer; ... What UDF type do I need to recreate this in SQL Server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Using Query Analyzer with SQL 2005
    ... to 2005) was undone for the release of SP4. ... What version of SQL Server 2000 Query Analyzer are you using? ... or will I always need to keep a copy of SQL Server 2000 to install ...
    (microsoft.public.sqlserver.tools)