Solution ID: prim80763
How to create privuser or pubuser account in a new SQL Server 2005 environment using SQL Managment Studio
Status: Reviewed
Version(s): 6.0, 6.1, 6.2, 6.2.1

Problem: How to create privuser or pubuser account in a new SQL Server 2005 environment using SQL Managment Studio.
Problem: Change privuser /or pubuser password in SQL Management Studio (express).
Cause: When moving the project management databases from one server to another these users do not exist unless another project management database is on that server or they were manually created.
Fix: Using the SQL Server Management Studio to create the users:

Step 1) Open up SQL Management Studio (express).



Step 2) Login to SQL Server Management Studio (express) as the ‘sa’ user.


NOTE: Default password: ‘Prima123Vera‘ from a standalone installation of SQL Express.



3) Expand ‘Security’ >> ‘Logins’.



4) Right click on ‘Logins’ and select ‘New Login’.


5) Type the name of the Login name you are trying to create in the Login name field. (IE: privuser,pubuser).


6) Select SQL Server authentication. Type the password in the ‘Password’ and ‘Confirm password’ field. (Password = Login name).


Login name: pubuser
Password: pubuser

Login name: privuser
Password: privuser


7) Uncheck the “Enforce Password Policy” option. 


8)  Click ‘Ok’.


9) Repeat if needed for additional user(s).