|
Home > Archive > MS SQL Server security > July 2005 > How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to manage SQL Server 2000 with Windows Authentication only from workstation not in domain
|
|
| Jacek Skaźnik 2005-07-08, 3:23 am |
| 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\DOMU
SERNAME 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.
Jacek Skaznik
| |
| Geoff N. Hiten 2005-07-08, 8:23 pm |
| Two words: Remote Console.
Geoff N. Hiten
Microsoft SQL Server MVP
"Jacek Skaźnik" <jskaznik@nos.pam.pszczyna.net> wrote in message
news:dal9a2$2cg5$1@n
ews2.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\DOMU
SERNAME 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.
>
> Jacek Skaznik
>
>
| |
| Mark J. McGinty 2005-07-10, 7:23 am |
|
"Jacek Skaźnik" <jskaznik@nos.pam.pszczyna.net> wrote in message
news:dal9a2$2cg5$1@n
ews2.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\DOMU
SERNAME 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
>
>
| |
|
| On Fri, 08 Jul 2005 09:17:09 +0200, Jacek Skaźnik wrote:
> 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\DOMU
SERNAME 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.
>
> Jacek Skaznik
You could try the RunAs feature from your standalone machine. If it it a
Win2K box, you should be able to get to it by holding down the Ctrl-key
and right clicking on EM. In the RunAs box, put in your Domain
credentials ... otherwise, like others have said, Terminal Services or VNC
may be your best friend.
|
|
|
|
|