Re: Using Windows Auth from domainless client in SQL Server Mgmt Studio
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 25 Feb 2007 09:26:52 -0600
Try mapping a drive to the SQL Server server using your domain account. This will establish known security credentials to the SQL box. Another method is to create a local account on the XP client with the same account/password as a domain account and login to the XP machine with that account.
Hope this helps.
SQL Server MVP
"William" <wejens@xxxxxxxxx> wrote in message news:1172174348.778241.172450@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm trying to use my domain credentials within SQL Server Mgmt. Studio
to connect to our devel server (in the same domain) from an XP Pro
machine that isn't part of any domain. I keep seeing the following
errors in the Event Log:
Login failed for user ''. The user is not associated with a trusted
SQL Server connection. [CLIENT: 192.168.2.2]
SSPI handshake failed with error code 0x8009030c while establishing a
connection with integrated security; the connection has been closed.
Now I'd prefer to not add my XP Pro machine to the domain but still
use Windows Auth to connect. I'm able to use my domain credentials
within VS 2005 to work on web sites on the same devel server, but I
can't figure out how to do it within SQL Server Mgmt Studio. Why would
the two have different security restrictions?
- Prev by Date: Re: Accesing data from many applications.
- Next by Date: Re: Error 0x80070534 when changing service account
- Previous by thread: Using Windows Auth from domainless client in SQL Server Mgmt Studio
- Next by thread: Audit 3 fields in one table