ISV using SQL Authentication and a small concern

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: dev (anonymous_at_discussions.microsoft.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 07:31:04 -0700

Hi,

I am an independent software vendor and my app will be deployed on users machine, it will use msde for db needs on clients machine. I am using sql authentication and my app will be connecting to the database using a fixed username and password always, for e.g. sa as user and "myPassword$2" as password. (I know I know that this is not 100% great, but we want to keep things very very simple but dont want windows authentication)

Now, please imagine this situation:

a) small office environment
b) My app installed on three machines.
c) database on 4th machine
d) all 3 users running my app on their individual machines and talking to db.

my concern is, will this scenario work, I mean no matter who the user is, my app logs into msde using sa and "myPassword$2", so will MSDE allow 3 users with same logins to access database at the same time.

Looking forward to hearing from you..
Thanks

Relevant Pages

  • Re: Problem logging users off to make changes
    ... > I have a database that I can't change unless I personally go to 150 ... > machines and log the users off. ... Email requests for all users to log ... The form that tells them to close the app has a timer with a 5 minute ...
    (microsoft.public.access.security)
  • Re: MSSQL7 and WinXP
    ... is closing the database after all connected clients are disconnected. ... > We're closer to a solution to our problem with slow machines on a MSDE ... The entries in the log file were reduced to a more sensible ...
    (microsoft.public.sqlserver.msde)
  • Re: vb.net/sql server speed issue
    ... A lot depends on how the app is used. ... > dataadapter hit the database build a dataset and drop the connection.... ... >> MSDE is the same engine as SQL Server but it has 2 major limitations. ...
    (microsoft.public.dotnet.framework.adonet)
  • ISV Using SQL Authentication - a login concern
    ... all 3 users running my app on their individual machines and talking to db. ... my concern is, will this scenario work, I mean no matter who the user is, my app logs into msde using sa and "myPassword$2", so will MSDE allow 3 users with same logins to access database at the same time. ...
    (microsoft.public.sqlserver.security)
  • Re: accdb will not open in 2007 Runtime
    ... current database - and it works. ... opens breifly and then closes - this is not a trusted location issue. ... I have an app that when run on a PC with Access 2007 Runtime insatlled it ... two different Xp Pro machines and a Winows 7 machine. ...
    (microsoft.public.access.setupconfig)