Using Windows Auth from domainless client in SQL Server Mgmt Studio



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.
[CLIENT: 192.168.2.2]

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?

.



Relevant Pages

  • Re: Last Question from Newbie on WM 6.0 SDK
    ... I would say go with Pro if you can as it gives you the benefit of SQL Server 2005 integration and it supports both local and remote debugging. ... I guess I can write a setup to do this with Visual Studio 2005. ... Visual Studio 2005 Standard Edition or do I need to use ...
    (microsoft.public.pocketpc.developer)
  • Re: Setting up a Development Environment
    ... I am using I am using XP Pro ... Enterprise Edition, SQL Server, FrontPage, Windows Server 2003, all the ... > Will Visual Studio design web apps or do I need Front Page or Dream ... Most folks want to have ...
    (microsoft.public.dotnet.general)
  • Data List Insert new problem
    ... I'm using Wisual Studio 2005 Pro with SQL server 2005 Dev on XP SP2 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Upgrade Pro to Enterprise?
    ... > MS SQL Server for example happily using the ADO components in D7 pro. ... I am not sure how much we would pay if we purchase all different DBExpress ... Thats why i asked if a Updatefrom Pro to Ent in the same version ...
    (borland.public.delphi.non-technical)
  • Re: Number of allowed connections for SQL Server 2005 Standard on
    ... I can put as much memory and storage space as I want. ... Hitchhiker's Guide to Visual Studio and SQL Server ... But if you are worried about lots of connections then why ... would you want to use XP Pro? ...
    (microsoft.public.sqlserver.connect)