Board index » delphi » How to install MSDE2000 with mixed mode security

Alex

Delphi Developer
Tue, 13 Jan 2004 16:29:26 GMT

How to install MSDE2000 with mixed mode security

MS SQL 2000 database engine (formerly msde) seems to get always installed
with Windows authontication mode only.
Our software is built around using "sa" user, i.e. using mostly SQL server
security.

Is there any way to get msde installed with mixed mode security , i.e.
Windows and SQL Server ?
I could not find any switches for this.

If such install is totally impossible, then can it be _programmatically_
changed ? E.g. get msde installed, then connect to it using Windows
security, then run some stored procedure or any other code and turn it into
mixed security. We use ADO to connect.

Alex

 
Oliver Townshen

Delphi Developer
Wed, 14 Jan 2004 14:14:09 GMT

Re:How to install MSDE2000 with mixed mode security


Quote
> If such install is totally impossible, then can it be _programmatically_
> changed ? E.g. get msde installed, then connect to it using Windows
> security, then run some stored procedure or any other code and turn it
into
> mixed security. We use ADO to connect.

If you get hold of the SQL Server Enterprise you can call up the properties
of the database and change the security setting. According to the
xp_loginconfig stored procedure documentation, this is the only way you can
do this.

Oliver

Marc Valenti

Delphi Developer
Thu, 15 Jan 2004 02:00:43 GMT

Re:How to install MSDE2000 with mixed mode security


I think it is possible if you use a custom "setup.ini" file.
Try to find more information on internet about the option that can be
inserted into this file.
-marc-

"Alex" <a...@almsystems.com> a crit dans le message news:
3b612603$1_2@dnews...

Quote
> MS SQL 2000 database engine (formerly msde) seems to get always installed
> with Windows authontication mode only.
> Our software is built around using "sa" user, i.e. using mostly SQL server
> security.

> Is there any way to get msde installed with mixed mode security , i.e.
> Windows and SQL Server ?
> I could not find any switches for this.

> If such install is totally impossible, then can it be _programmatically_
> changed ? E.g. get msde installed, then connect to it using Windows
> security, then run some stored procedure or any other code and turn it
into
> mixed security. We use ADO to connect.

> Alex

Michael Rodrigue

Delphi Developer
Sat, 17 Jan 2004 22:25:33 GMT

Re:How to install MSDE2000 with mixed mode security


If you want mixed security, you can install MSDE like so:

d:\msde\setup.exe SECURITYMODE=SQL

I can't remember where I found it, but it does the trick.

HTH,

--
Michael Rodriguez
Compeat Restaurant Accounting Systems
http://www.compeat.com
m...@compeat.com

Quote
"Alex" <a...@almsystems.com> wrote in message news:3b612603$1_2@dnews...
> MS SQL 2000 database engine (formerly msde) seems to get always installed
> with Windows authontication mode only.
> Our software is built around using "sa" user, i.e. using mostly SQL server
> security.

> Is there any way to get msde installed with mixed mode security , i.e.
> Windows and SQL Server ?
> I could not find any switches for this.

> If such install is totally impossible, then can it be _programmatically_
> changed ? E.g. get msde installed, then connect to it using Windows
> security, then run some stored procedure or any other code and turn it
into
> mixed security. We use ADO to connect.

> Alex

Other Threads

1. MS SQL mixed security mode and login prompt

2. MS SQL Server / mixed security / Connecting

3. BDE in Mixed mode to SQL Server 7

4. BDE in Mixed mode to SQL Server 7

5. To mix or not no mix (comes from non-technical thread)

6. CreateItemFromTemplate does not work in IMO mode for a message with security

7. Paradox 4.x, 5.x and 7 tables Mix with Language driver mix

8. .BDE client install on NT - security issue

9. How to install BDE in unattended mode?

10. BDE 5.01 install in silent mode