Remote NT Login not working

[sfarkas]

I have created a new adp with a SQL Server backend. I have the adp
file on my laptop and the SQL Server resides on a remote server that I
access via a VPN. When I open up the adp on my laptop and select File-

Connection and type in the server name of the SQL Server and select

Use a Specific User Name and Password I get a perfectly fine
connection to the database and everything works.

However I want to use Windows NT Integrated Security. When I try to
select this I get an error:

Login failed for user ". The user is not associated with a trusted
SQL Server connection.

The error seems to indicate the username I am passing to SQL Server is
null. I have set up logins and users on SQL Server that work. I know
this because I also have a copy of the adp on the server itself and
when I use NT Security from that adp everything works fine.

So the basic question is:

How can I get my remote laptop to pass a valid username (and I presume
password) to the SQL Server so that I can use Windows NT Integrated
Security?

Thanks.

 

[sfarkas]

I have created a new adp with a SQL Server backend. I have the adp
file on my laptop and the SQL Server resides on a remote server that I
access via a VPN. When I open up the adp on my laptop and select File->Connection and type in the server name of the SQL Server and select

Use a Specific User Name and Password I get a perfectly fine
connection to the database and everything works.

However I want to use Windows NT Integrated Security. When I try to
select this I get an error:

Login failed for user ". The user is not associated with a trusted
SQL Server connection.

The error seems to indicate the username I am passing to SQL Server is
null. I have set up logins and users on SQL Server that work. I know
this because I also have a copy of the adp on the server itself and
when I use NT Security from that adp everything works fine.

So the basic question is:

How can I get my remote laptop to pass a valid username (and I presume
password) to the SQL Server so that I can use Windows NT Integrated
Security?

Thanks.

I should add: I am running SQL Server 2005 under Windows Server 2003
and the laptop is running Windows XP Home.

 

[Sylvain Lafontaine]

When using Integrated Security, your machine must be part of an
authenticated domain on the Win2003 server and this account must be added to
the list of accounts accepted by SQL-Server. The fact that your copy of
the adp on the server works means nothing in this regard.

Please consult your network specialist in order to configure your machine to
be part of an authenticated domain recognised by the Win2003 Server. After
that, you will be able to add this account or its domain to the list of
accounts and domains recognised by SQL-Server.

 

[ExcelMan]

When using Integrated Security, your machine must be part of an
authenticated domain on the Win2003 server and this account must be added to
the list of accounts accepted by SQL-Server. The fact that your copy of
the adp on the server works means nothing in this regard.

Please consult your network specialist in order to configure your machine to
be part of an authenticated domain recognised by the Win2003 Server. After
that, you will be able to add this account or its domain to the list of
accounts and domains recognised by SQL-Server.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)












- Show quoted text -

Thanks -- that makes perfect sense. However, I am still not sure why
I can use SQL Server security and still connect to SQL Server on the
Windows2003 server. Since my laptop is not part of that domain, I
would have thought I couldn't even get into the machine, let alone SQL
Server.

Steven

 

[Sylvain Lafontaine]

Same explanation as the fact that you don't need to be part of a domain to
access a web site.

 

[aaron.kempf]

you can't use Windows Integrated Security _UNLESS_

a) you're on the domain
b) you've got the same user names / passwords as the domain


I think that if you have a local user on the SQL Server named
'johnlocal' and you have a WINDOWS account on your XP Home laptop--
and they both have the same password-- then I think that you could get
in.

I just think that XP Home is crap and so is vista home.. MS doesn't
understand this whole marketing thing at all

Reasonable software are reasonable prices-- is this too much to ask
for?