|
1. Make sure your SQL is setup to use mixed authentication mode.
How to change auth mode:
- Open SQL Server Management Studio
- Right click (local)... and select properties
- Select the tab for "security"
- check the box for "SQL Server and Windows Authentication Mode"
- Restart the MSSQLSERVER service.
2. Create a new login with a random name and pass. WRITE IT DOWN!
- Map new login to all 4 databases as db_owner
- Set Server Role as serveradmin, setupadmin, sysadmin
- Apply and Restart MSSQLSERVER service
3. Edit your server files with the new name and pass
4. run the server
|
