Re: Connection string/Sql Server 2005/Windows authentication/ but not on domain

SQL Server defaults to prohibit "mixed mode" authentication. Make sure this is enabled.
Next, make sure that the Login account is setup to accept the Windows account and has rights to the correct database. See Chapter 9.

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
http://betav.com
____________________________________________________________________________________________



"Gina_Marano" <ginalster@xxxxxxxxx> wrote in message news:522e7dd9-a23b-4998-9e6e-041fec87433b@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Help,

I am writing a data import application that will import data in to
sql
server database.

The only kind of connection that it will accept is windows
authentication.

Problem is, I am not on the domain. I am logged in remotely via
Himachi (VPN).

I know it is possible, somewhat, because I found a database desktop
tool that allows me to enter the domain credentials.

I need a connection string that will allow me to specify the domain
credentials and fake windows authentication.

Any ideas out there?

I need this so I can write an application remotely.

~Gina_M~

.

Relevant Pages

  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)
  • Re: server authentication & ASP authentication
    ... on to the client workstation with an authorized Windows account. ... SQL Server with Windows authentication. ...
    (microsoft.public.sqlserver.security)
Loading