You must now create a database user that the RAdmin scripts will use to
log in to the database you created above.
These examples create a new database user called “radmin”, with a
password “ra+9+9dminpw”. You may wish to choose a different password, but
we recommend that you keep the user name radmin. The default database for
the “radmin” user is set to the “radmin” database, which is also owned by
radmin. Record these names and password, you will need them later.
- Right click on the Security folder. Choose New -> Login
- Specify a “Login Name” (we recommend “radmin”).
- Choose “SQL Server authentication” and set password to
“ra+9+9dminpw”.
- Click on “Default database” and select “radmin”.
- Click OK.
You can also use command line utility “sqlcmd” to create the user and
set the default database:
- Run the “sqlcmd” command line application. For example, to connect
to local server that listens on port 5161:
sqlcmd -S 127.0.0.1,5161 -d radmin
- Run these commands to create a user and set the default database:
EXEC sp_addlogin ’radmin’, ’ra+9+9dminpw’, ’radmin’;
go
EXEC sp_changedbowner radmin,true
go
- Run “exit” to leave sqlcmd.
