We have an installation that already has MSDE (SQL 2000) loaded on their
machine, so there is no enterprise manager or QA.

I need to change this to use SQL security and I need to set the sa
password.

How can I do those from the osql prompt?



Darin

*** Sent via Developersdex http://www.developersdex.com ***

Darin <darin_nospam@nospamever> wrote in news:eSrnUNgfHHA.3508
@TK2MSFTNGP03.phx.gbl:

To set the password, use sp_password (described in BOL).

There is no straightforward way of using T-SQL to change the authentication
mode. It can however be done by:

- SQLDMO
- hacking the registry (e.g. see http://www.microforge.net/kb/41)

as well as using Enterprise Manager or a clone.

The non-straightforward way using T_SQL is to use the sp_OA_Create, etc
series of SPs to instantiate and manipulate an SQLDMO COM object, but I've
never tried doing this that way.

If you mean to enable mixed security mode (i.e allowing both Windows
security and SQL Security), you can modify corresponding Windows registry
key:

1. Start "regedt32.exe"
2. Go this key:
    HKEY_LOCAL_MACHINE->Software->Microsoft->MSSQLServer->MSSQLServer->LoginMode
3. Double click it to edit its value: change the "value Data" from 0 to 2
4. Click "OK" and close Registry Editor.

Now the SQL Server's mixed security mode is enabled. Disclaimer: at your own
risk to edit registry.


Show quoteHide quote

SQL Server 2005: Lock Escalation
sql server 2005 design
Searching whole database
cannot back up database to a disk file
Receiving "Error: 18456" when for a specific user who has rights via AD Group
Backup methodologies
SQL 2005 upgrade advisor's impact on the production server?
Fulltext index and insert performance
Free Text Search
question about secondary file