Modifying the Details of a Profile 
Use
You use this procedure to modify either the login ID or password of a profile. This procedure must be carried out at two levels and also in the same sequence as indicated below:
· At the Mobile Application Studio (MAS) level using User Manager
· At the Mobile Application Repository level using Microsoft SQL Enterprise Manager
We recommend that you do not modify the details of a profile, unless absolutely necessary.
Procedure
Modifying Profile details at the MAS level
...
1. In the Mobile Application Studio, choose Tools ® User Manager.
The User Manager window appears.
2. Select the required profile.
The login and password values appear.
3. Choose Modify.
Enter the new login or password values in the corresponding fields.
4. Choose Save.
Modifying Profile details at the MAR level
Modifying the Password of a Profile
...
1. In the Microsoft SQL Server Enterprise Manager, expand the Microsoft SQL Servers ® SQL Server Group and locate the machine name that has MAR installed.
2. Expand the <machine> node and choose Security ® Logins.
3. Select the login of the profile you want to modify.
4. Right click and choose Properties.
The SQL Server Login Properties window appears.
5. In the General tab, enter the new password.
The password should be the same as the profile password that you have entered at the MAS level.
6. Confirm the password.
Modifying the Login of a Profile
Microsoft SQL Server Enterprise Manager does not allow you to modify a login. Therefore, you must delete the existing login and create a new login.
...
1. In the Microsoft SQL Server Enterprise Manager, expand the Microsoft SQL Servers ® SQL Server Group and locate the machine name that has MAR installed.
2. Expand the <machine> node and choose Security ® Logins.
3. Right click on Logins and choose Delete.
The login is deleted.
4. In the right-hand pane, right-click and choose New Login…
The SQL Server Login Properties window appears.
5. In the General tab, enter the required values for the respective groups as given below:
Group |
Required values |
Login |
New login name (Must be same as the profile login entered at the MAS level) |
Authentication |
Password for the SQL Server Authentication (Must be the same as the profile password entered at the MAS level) |
Defaults |
Name and language of the MAR |
6. If the login is ARSAdmin, in the Server Roles tab, select all the server roles except System Administrators; or continue with the next step.
7. In the Database Access tab, select the Permit field for the required application repository.
8. Select the required database roles that are listed below based on the login in the Permit in Database role list.
We recommend you to assign the database roles as defined in the table below:
Database role |
ARSAdmin |
ARSDeveloper |
ARSUser |
Public |
! |
! |
! |
db_owner |
! |
|
|
db_accessadmin |
! |
|
|
db_securityadmin |
! |
|
|
db_ddladmin |
! |
|
|
db_backupoperator |
! |
|
|
db_datareader |
! |
! |
! |
db_datawriter |
! |
! |
|
db_denydatareader |
|
|
|
db_denydatawriter |
|
|
|
A new login is created with a new password.
See also:
Profiles of the Mobile Application Repository