Windows Vista Forums
Vista Forums Home Join Vista Forums Donate Vista Tutorials Tags

Welcome to Vista Forums we are your forum to discuss Windows Vista x64 and x86 systems. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Vista Newsgroups > Vista security

Vista + VPN + SQL server + Windows Authentication mode

Closed Thread
 
Thread Tools Display Modes
Old 04-14-2007   #1 (permalink)
WoiTEC
Guest
 
Posts: n/a

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

 
Old 04-14-2007   #2 (permalink)
Jerry Jeep
Guest
 
Posts: n/a

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.

 
Old 04-23-2007   #3 (permalink)
guy@guydaniels.com
Guest
 
Posts: n/a

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?

 
Old 04-24-2007   #4 (permalink)
robagius@gmail.com
Guest
 
Posts: n/a

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?

 
Old 04-26-2007   #5 (permalink)
WoiTEC
Guest
 
Posts: n/a

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

 
Old 04-26-2007   #6 (permalink)
WoiTEC
Guest
 
Posts: n/a

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
 
 
Closed Thread

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vista submits 2 identical jobs to IPP print server with authentication Steve S.C. Yau Vista print fax & scan 3 03-04-2008 07:39 PM
My Server requires authentication Jane Vista mail 1 12-26-2007 06:10 PM
Vista submits 2 identical jobs to IPP print server with authentication Steve S.C. Yau Vista print fax & scan 0 09-05-2007 09:17 PM
RDP Authentication Credentials to Server 2003 Joe Vista General 1 08-05-2007 08:43 PM








Vistax64.com 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 2005-2008

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 47 48 49