SQL Server - Windows Authentication from Outside the Domain

Asked By jwgoerlic on 08-Mar-08 10:58 AM
Hello group,

I have some test workstations that are in a workgroup. The production
workstations and servers are in a domain. The database servers are
running SQL Server 2005 SP2 Enterprise edition, with named instances.

From within the domain, anyone can launch SQL Server Management Studio
and connect up using Windows Authentication. From the test
workstations, however, Windows Authentication fails because we are not
logged on as a domain user.

I have tried the old Net Use \\Server\ipc$ trick to authenticate to
the SQL server. When the Management Studio launches, the connection
still fails. The error is: An error has occurred while establishing a
connection to the server.  When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)
(Microsoft SQL Server, Error: -1)

I did some research and it seems the ipc$ pre-authentication is no
longer supported under SQL 2005. So my question is, how do I open
Management Studio from a workgroup, select Windows Authentication, and
prompt the user to enter their domain credentials?

Thanks in advance,

J Wolfgang Goerlich




Johanna Aqu replied on 20-May-08 05:53 PM
Had the same problem and found a solution at
http://www.galcho.com/Blog/CommentView.aspx?guid=20d0d23f-9f7d-46e8-a82c-971c1118996e#commentstart

open the mgr from the command window by running:
c:\>runas /netonly /user:domain\user "C:\Program Files\Microsot SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

Hope it helps
Tom Bell replied on 21-May-09 04:00 AM
I want to solve the same issue - did you work it out?  Thanks TOM