How to create a local administrator log on in Windows

[Product_Support]

Issue

Continuum 1.9x and above will not install correctly on a PC / Laptop that is on a domain,

One example: When trying to run the Continuum Database Initialization program the following error message may pop up:

You must have local NT administrative privileges to run this application.

Environment

Windows OS 7 8 10

Continuum 1.9x 2.x

Inet

SQL 2005

SQL 2008

SQL 2012

Cause

Microsoft has introduced the use of a higher level of security in the install of their SQL database software SQL 2005 / SQL 2008 / SQL 2012.

When you install Continuum you need to make sure you are logged onto the PC / Laptop as a local administrator, in the case of a lot of a corporate networks, you are most likely logged on as ether a restricted user or a domain administrator, these logons do not have the privileges you need to install an SQL database.

Resolution

Step by step guide to creating a local administrator user on your PC / Laptop

1. Go to "Start" then "Control Panel" in Windows (Windows 7 and above, top right corner change "view by" to "small icons" this will show all icons)
2. Go to "Administrative Tools"
3. Go to "Computer Management" / "Local Users and Groups"
4. In users, right click on the right panel and add new user
5. Fill in the user name and password, un-tick user must change password
6. Tick password never expires then ok it
7. Now go back into control panel and click on "User Accounts"
8. Click on the name you just created, this will open the properties screen (Windows 7 and above click on "Manage user accounts")
9. Click on "Group Membership" then select others, and highlight administrators (Windows 7 and above double click on name you created, click "group membership" click "other" then in the drop down select "Administrator")
10. Apply this and then ok it.
11. Log off your normal account and log back on as the new user you have just created