Re: How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain
From: Mark J. McGinty (mmcginty_at_spamfromyou.com)
Date: 07/10/05
- Next message: Phil Turtle: "NETWORK SERVICE Account and sp_add_job problem"
- Previous message: Mark J. McGinty: "Re: Preventing ALL text SQL Injection by removing single-quotes ?"
- In reply to: Jacek Skaźnik: "How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain"
- Next in thread: D Dub: "Re: How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 10 Jul 2005 04:49:53 -0700
"Jacek Skaźnik" <jskaznik@nos.pam.pszczyna.net> wrote in message
news:dal9a2$2cg5$1@news2.ipartners.pl...
> Hi,
>
> I'm looking for an answer to this - I have a SQL Server 2000 with Windows
> Authentication and I can't switch to mixed mode in this particular
> environment (security reasons). Is there a way to connect to this server
> from Enterprise Manager installed on another machine that is not in any
> domain (standalone workstation)? I've already tried net use
> \\SERVERNAME\IPC$ /user:DOMAINNAME\DOMUSERNAME and it works for file
> shares on the same server, but trying to connect using EM returns ' Login
> failed for user '(null)'. Reason: Not associated with a trusted SQL Server
> connection. Reason: Not associated with a trusted sql server connection'.
> Thanks for your help.
The only way is to have synchronized accounts on both machines, with
identical login names and identical passwords. The account on the SQL box
must, needless to say, have access to SQL. The corresponding account on the
other box must be logged-in or impersonated by the app attempting to access
SQL Server. Otherwise you need a domain as a central authentication
authority.
-Mark
> Jacek Skaznik
>
>
- Next message: Phil Turtle: "NETWORK SERVICE Account and sp_add_job problem"
- Previous message: Mark J. McGinty: "Re: Preventing ALL text SQL Injection by removing single-quotes ?"
- In reply to: Jacek Skaźnik: "How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain"
- Next in thread: D Dub: "Re: How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
