Re: ISV Using SQL Authentication - a login concern

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 05/26/04 

Date: Wed, 26 May 2004 10:42:12 -0400

Yes this will work. No it is not very secure. Yes it is simple. SQL does
not care how many users connect using the same login. Of course, you still
will be throttled by the MSDE concurrent processing limit. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"dev" <anonymous@discussions.microsoft.com> wrote in message
news:44DC2471-02F2-4713-A711-1F8B1F571484@microsoft.com...
> 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: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)
  • Re: Access vs SQL
    ... from Access, tweaked my app a bit, and viola, everything works. ... MSDE 2000 adds a bit of complexity, but I have to say, compared to ... > (above and beyond what they pay for my engineering services). ... > Now, still using C1 components, I know I can upsize to MSDE or SQL ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Question about forms and data storage
    ... app that synchs the data from SQL to a list, ... or look at moving the core data into the sharepoint ... list over the database... ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Prevent Viewing on worksheet
    ... and run MSDE as a server. ... been on the market for what.. ... MSDE changed the friggin database market... ... i really reccomend using sql authentication.. ...
    (microsoft.public.excel)
  • RE: SQL & MSDE and Ports 1433 and 1434
    ... As I understand it, if you have an app on a system using MSDE, the system ... would be vulnerable to the SQL Slammer worm *if* the app was listening on ... A gazillion apps install MSDE when they get installed on a system. ... Patch your SQL 2000 systems immediately, run nmap (or whatever you favorite ...
    (Security-Basics)