Re: Accessing SQL Server w/ Forms on Intranet

From: Sam Santiago (ssantiago_at_n0spam-SoftiTechture.com)
Date: 01/07/05 

Date: Fri, 7 Jan 2005 08:23:42 -0800

What specifically is the problem you are having? Any error messages? You
stated: "I put the app out on a shared drive and it obviously wouldn't log
on to the SQL server." There's nothing obvious here. The fact you
launched the application from a shared drive really shouldn't affect SQL
Server. Check out this article since you might be having other issues:

How to deploy a .NET Framework application to run from a network location
http://support.microsoft.com/default.aspx?scid=kb;en-us;832742

Thanks,

Sam 

-- 
_______________________________
Sam Santiago
ssantiago@n0spam-SoftiTechture.com
http://www.SoftiTechture.com
_______________________________
"bh" <bh@discussions.microsoft.com> wrote in message 
news:F0D3F61E-F8C9-41A7-B5E6-0DD0FB26C342@microsoft.com...
> 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: SQL Server Dual Processors INSERTS take long time
    ... Just because a server ... all you might try adding a clustered index on the table. ... Andrew J. Kelly SQL MVP ... > for other parts of the app, that need to be done in real time. ...
    (microsoft.public.sqlserver.server)
  • Re: version & instances
    ... SQL 2000 SP3a for Antivirus app ... that same server, to avoid breaking any of those apps. ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine
    ... can tell it to pickup our SQL server using SQL ... app and SQL Server. ... >user belongs to the local Administrators group, ...
    (microsoft.public.sqlserver.security)
  • Re: Invalid Seek Offset continued...
    ... Well shifting to MS SQL will be a very very big step. ... > As Aashish mentioned, network cards drivers may be causing this problem, I ... > also see this error a lot at one customer where the server RAID Controller ... >>> We are deploying a VFP8 app to several beta sites to replace an FPW ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... of authentication are you using on SQL Server - Windows? ... Sam Santiago ... I am distributing a Form with a SQL connection over an Internet. ...
    (microsoft.public.dotnet.distributed_apps)