Re: Accessing SQL Server w/ Forms on Intranet

From: bh (bh_at_discussions.microsoft.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 07:55:03 -0800

Your assumption is correct. I am distributing Windows Forms. I am using
Windows Integrated Authentication as that is what our network runs on. I
understand that web based (ASP) is the "cool" thing, but I like the speed at
which Forms process information much better then an ASP app communicating
with the server. Do I bite the bullet and switch to ASP or should I ask the
Networking team here about the Windows Security issue?

"Sam Santiago" wrote:

> Sounds like this would be better off written as a web based application so
> that you would not have to distribute a Form. Since you are saying Form I'm
> assuming a Windows Form application with only a single form in it. What type
> of authentication are you using on SQL Server - Windows(Integrated)? Or SQL
> Server authentication? Either way you should be able to formulate a
> connection string to access SQL with the proper user credentials.
>
> Thanks,
>
> Sam
>
> --
> _______________________________
> Sam Santiago
> ssantiago@n0spam-SoftiTechture.com
> http://www.SoftiTechture.com
> _______________________________
> "bh" <bh@discussions.microsoft.com> wrote in message
> news:B02D753D-EFEA-4601-809C-7F255489D119@microsoft.com...
> > Okay, I am distributing a Form with a SQL connection over an Internet.
> > The
> > forms will be kept on a centralized server. We need to control the users
> > that are allowed to manipulate the data as much of it will be used for
> > records keeping with few managers able to edit the data.
> >
> > I put the app out on a shared drive and it obviously wouldn't log on to
> > the
> > SQL server. What is the most secure way of distributing the Form over the
> > Intranet while allowing SQL access too all users specified on the Server.
>
>
>

Relevant Pages

  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Windows Authentication and software in a hosted environment.
    ... What type of authentication are you using for the VPN? ... If you are using something like ISA server then the user is passing windows ... In my experience with hosted DB solutions almost always SQL auth is used. ...
    (microsoft.public.sqlserver.security)
  • Re: Connecting to SQL Without Windows Authentication
    ... Are you connecting to the SQL ... Server via named ... >> I have a Windows 2000 server ... If I connect using SQL Authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL / IIS Application Pool Identity
    ... Set the authentication tag in web.config to "windows" (this way it actually ... to sql, which will obviously be different for each user. ... I want to use the application pool identity to make the> connection to the SQL server database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Need help configuring Wireless Connection profile
    ... and I can only use the intel OR windows utility, not both at the same time. ... Windows authentication for all users,4129,LRG\ryanv,4149,Wireless WPA2 ... SMALL BUSINESS SERVER: ... STEP #1 Install Certificate Services ...
    (microsoft.public.windowsxp.general)