Re: Configuration of Login and password in VB6 program


"albertleng" <albertleng@xxxxxxxxx> wrote in message
news:1188868401.161722.170880@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dear all,

I have a VB6 project which the program needs to access SQL Server 2005
tables.
As below, the userID is QA and the password is qapl.
The user has requested that to prevent us (the designer) to know the
userID and password of the SQL server, they can configure the userID
and password for the program.

I suggest to give them the source codes to let them change themselves
but they dont want this solution.
They requested that they want a solution which they can change the
login and password of the program without touching the source code but
able to prevent the designer (me) to have idea of login and password
used. Please omit the solution which uses textfile to store the login
and password unless the user can hide those details from the
designer.


Giving them the source for this purpose is pointless unless they have their
own developers. However, they should probably still have the source code
since presumably they're paying you to write this program for them, and
therefore the source code is really theirs.

Nothing wrong with saving it to a text file or any other "type" of file.
However, regardless of the file type, you need to encrypt at least the
password (you may want to encrypt the user id as well). Search these
newsgroups at www.google.com/advanced_group_search for encryption routines
you can use.

The other alternative is instead of using SQL Server authentication, use
Windows authentication. With Windows authentication, no password (or even a
user id, per se) is necessary. User are granted permissions via their
Windows login. If you're not familiar with this, I suggest you read up on it
in SQL Server 2005's documentation.

--
Mike
Microsoft MVP Visual Basic


.

Relevant Pages

  • Re: Configuration of Login and password in VB6 program
    ... I have a VB6 project which the program needs to access SQL Server 2005 ... the userID is QA and the password is qapl. ... able to prevent the designer to have idea of login and password ...
    (microsoft.public.vb.general.discussion)
  • Re: Configuration of Login and password in VB6 program
    ... encryption of the userid and/or password in a text file. ... A dialog box to prompt user to login everytime the program is run. ... Apart from giving them the source code and 2), i can't think of a way ...
    (microsoft.public.vb.general.discussion)
  • Configuration of Login and password in VB6 program
    ... I have a VB6 project which the program needs to access SQL Server 2005 ... the userID is QA and the password is qapl. ... The user has requested that to prevent us (the designer) to know the ... able to prevent the designer to have idea of login and password ...
    (microsoft.public.vb.general.discussion)
  • Re: Configuration of Login and password in VB6 program
    ... SQL Server 2005 which will grant different access rights based on my ... the userID is QA and the password is qapl. ... The user has requested that to prevent us (the designer) to know the ... able to prevent the designer to have idea of login and password ...
    (microsoft.public.vb.general.discussion)
  • Re: Unexpected Login Screen When Accessing SQL Data Via .NET Intra
    ... >> data and the SQL Server is on the same server. ... >> My problem is that one user has started getting a login popup ... >> right in via Windows Authentication like everyone else and like they ...
    (microsoft.public.sqlserver.connect)