Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Vista Newsgroups > Vista security

Vista - Vista + VPN + SQL server + Windows Authentication mode

Reply
 
Old 04-14-2007   #1 (permalink)
WoiTEC


 
 

Vista + VPN + SQL server + Windows Authentication mode

Hello everyone!

I have a question regarding connection to SQL server using Management Studio
Express on a computer with Vista Business while using a VPN connection to
the network.

With Windows XP (my computer is not in company domain) after connecting
through VPN to my office domain (with a username which is a member of
domain admins group) I could connect to SQL server (2000 and 2005) using
Windows Authentication. After installing Vista that is no longer possible. I
get a message - Login failed for user '(null)'. Reason: Not associated with
a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)
BTW. In the Options of the VPN connection - "Include Windows logon domain"
is checked.
Connection with a SQL server Authentication mode works without any problems.
Any ideas?

Best Regards

WoiTEC


My System SpecsSystem Spec
Old 04-14-2007   #2 (permalink)
Jerry Jeep


 
 

Re: Vista + VPN + SQL server + Windows Authentication mode

Similar problems here also, getting error 734 PPP link control protocol
disconnect. No change except for Vista Untimate. Can still use an Xp system
with no problems behind same firewall.

My System SpecsSystem Spec
Old 04-23-2007   #3 (permalink)
guy@guydaniels.com


 
 

Re: Vista + VPN + SQL server + Windows Authentication mode

On Apr 14, 8:25 pm, "Jerry Jeep" <jerry_j...@hotmail.com> wrote:
> Similar problems here also, getting error 734 PPP link control protocol
> disconnect. No change except forVistaUntimate. Can still use an Xp system
> with no problems behind same firewall.


Same problems here. Have any solutions or suggestions appeared?

My System SpecsSystem Spec
Old 04-24-2007   #4 (permalink)
robagius@gmail.com


 
 

Re: Vista + VPN + SQL server + Windows Authentication mode

I have been told that the problem is related to authentication and
that the solution is to authenticate against the domain (not the VPN
firewall) and to then route all traffic through the server used for
authentication - makes little sense to me but hey when it gets to bits
and bobs it gets all too technical for a simple mind. Why on earth
woudl I have expected Vista Business to just work like XP - duh!!! No
wonder most of our top guys are uninstalling Vista and opting for
XP.....any idea when they port mac to pc?

My System SpecsSystem Spec
Old 04-26-2007   #5 (permalink)
WoiTEC


 
 

Re: Vista + VPN + SQL server + Windows Authentication mode

>I have been told that the problem is related to authentication and
> that the solution is to authenticate against the domain (not the VPN
> firewall) and to then route all traffic through the server used for
> authentication - makes little sense to me but hey when it gets to bits


And this is exactly the way I do it. I authenticate against a domain
server.
I have access to all domain shares with the correct access rights but not
the SQL server!!!

Really nobody knows what the problem might be??
WoiTEC

My System SpecsSystem Spec
Old 04-26-2007   #6 (permalink)
WoiTEC


 
 

Re: Vista + VPN + SQL server + Windows Authentication mode

> Same problems here. Have any solutions or suggestions appeared?

Nobody seems to know how to fix this problem....
I've searched google, but no luck..

WoiTEC
My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
My server requires authentication Vista mail
Vista submits 2 identical jobs to IPP print server with authentication Vista print fax & scan
My Server requires authentication Vista mail
Vista submits 2 identical jobs to IPP print server with authentication Vista print fax & scan


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46