Showing posts with label theirmachine. Show all posts
Showing posts with label theirmachine. Show all posts

Friday, February 10, 2012

change MSDE to SQL security

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.codecomments.com ***
Darin <darin_nospam@.nospamever> wrote in news:eSrnUNgfHHA.3508
@.TK2MSFTNGP03.phx.gbl:

> 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?
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.
"Darin" <darin_nospam@.nospamever> wrote in message
news:eSrnUNgfHHA.3508@.TK2MSFTNGP03.phx.gbl...
> 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.codecomments.com ***

change MSDE to SQL security

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.codecomments.com ***Darin <darin_nospam@.nospamever> wrote in news:eSrnUNgfHHA.3508
@.TK2MSFTNGP03.phx.gbl:

> 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?
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.
"Darin" <darin_nospam@.nospamever> wrote in message
news:eSrnUNgfHHA.3508@.TK2MSFTNGP03.phx.gbl...
> 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.codecomments.com ***