Tuesday, March 27, 2012

Advice on connection isssues

I have a SQL server which Authentication is set to Windows only, and all our
software that connects to the server uses 'trusted' connections
My question is if i connect to the server using a VPN , how can i make the
cnnection a trusted source so i can run software from a remote locationMap a drive on the client machine to a share on the SQL Server. This causes
the SQL Server to use those credentials when talking with the specific
client.
The share can contain nothing.
Regards
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
news:42FF3626-5197-4D5D-95D5-25AAC2640747@.microsoft.com...
> I have a SQL server which Authentication is set to Windows only, and all
our
> software that connects to the server uses 'trusted' connections
> My question is if i connect to the server using a VPN , how can i make the
> cnnection a trusted source so i can run software from a remote location|||Mike,
does this work when connectiing to the SQL server though a VPN ?
"Mike Epprecht (SQL MVP)" wrote:

> Map a drive on the client machine to a share on the SQL Server. This cause
s
> the SQL Server to use those credentials when talking with the specific
> client.
> The share can contain nothing.
> Regards
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Peter Newman" <PeterNewman@.discussions.microsoft.com> wrote in message
> news:42FF3626-5197-4D5D-95D5-25AAC2640747@.microsoft.com...
> our
>
>|||When the client establishes a VPN do they authenticate to your DC?
If so, then they should be able to use Windows Authentication. If the user
is never challenged for his credentials,
then the connection is likely to fail with Login failed for user 'null'.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment