Your UC Reporter data is not summarizing and you see the below error in the IPTMR-summary.txt log file:
Error #0, Message: CREATE DATABASE permission denied in database 'master'., Source: .Net SqlClient Data Provider, Sysmessages table index: 262
Solved! Go to Solution.
Your UC Reporter data is not summarizing and you see the below error in the IPTMR-summary.txt log file:
Error #0, Message: CREATE DATABASE permission denied in database 'master'., Source: .Net SqlClient Data Provider, Sysmessages table index: 262
Cause: Each SQL user is assigned to a default database and sql assigns this to 'master' by default. If your user has sa role rights, then no further action is required, but if your user is restricted to either public or public + dbcreator, then specific permissions to this 'master' database are needed.
Solution: You have 3 options:
1. Change the default database for your user to IPTM_Device instead (Which it should already have enough permissions to).
or
2. In SQL Management Studio go to the Security\Logins section and bring up the properties for your user. Click into user mapping and click on the master database and give db_datareader permission to this database for your user.
or
3. Give your user the 'sa' role
Note: All 3 of these settinsg are set in SQL Management Studio
Your UC Reporter data is not summarizing and you see the below error in the IPTMR-summary.txt log file:
Error #0, Message: CREATE DATABASE permission denied in database 'master'., Source: .Net SqlClient Data Provider, Sysmessages table index: 262
Cause: Each SQL user is assigned to a default database and sql assigns this to 'master' by default. If your user has sa role rights, then no further action is required, but if your user is restricted to either public or public + dbcreator, then specific permissions to this 'master' database are needed.
Solution: You have 3 options:
1. Change the default database for your user to IPTM_Device instead (Which it should already have enough permissions to).
or
2. In SQL Management Studio go to the Security\Logins section and bring up the properties for your user. Click into user mapping and click on the master database and give db_datareader permission to this database for your user.
or
3. Give your user the 'sa' role
Note: All 3 of these settinsg are set in SQL Management Studio
Members | Likes |
---|---|
43 | |
36 | |
23 | |
17 | |
11 |