Tag: roles

Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Analysis Services problems (Part 2)

by

Troubleshooting SQL Server 2017 Analysis Services problems (Part 2) If you have problems with SQL Server 2017 Analysis Services (SSAS 2017), review this troubleshooting checklist to find potential solutions. 1. If you cannot connect to SQL Server 2017 Analysis Services, ensure that SQL Server Browser service is started and was running under the account that has local administrator rights. The...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Analysis Services problems (Part 1)

by

Troubleshooting SQL Server 2017 Analysis Services problems (Part 1) If you have problems with SQL Server 2017 Analysis Services (SSAS 2017), review this troubleshooting checklist to find potential solutions. 1. The Analysis Services service may stop unexpectedly and Event ID 22 is logged in the Application log when you process an object in a database. This problem occurs when Analysis...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with linked servers in SQL Server 2017

by

Troubleshooting problems with linked servers in SQL Server 2017 If you have problems with linked servers in SQL Server 2017, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to create linked servers. To create a linked server, you must have ALTER ANY LINKED SERVER permission. So, if you have no this permission, you...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2017 Roles

by

Troubleshooting SQL Server 2017 Roles If you have problems with SQL Server 2017 roles, review this troubleshooting checklist to find potential solutions. 1. The error 920 may occur when you modify the database script level. This error indicates that only members of the sysadmin role can modify the database script level. To resolve this problem, ensure that user, who modify...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2016 Roles

by

Troubleshooting SQL Server 2016 Roles If you have problems with SQL Server 2016 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2016 service pack. Because many SQL Server 2016 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Some tips to work with SQL Server 2016 alerts

by

Some tips to work with SQL Server 2016 alerts SQL Server 2016 writes the events into the Windows Application log. SQL Server Agent checks the Windows application log for SQL Server events. When an event occurs, the SQL Server Agent checks if the appropriate alert exists and if so perform the defined response. Alerts can be used to execute a...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
SQL Server

Troubleshooting SQL Server 2014 Roles

by

Troubleshooting SQL Server 2014 Roles If you have problems with SQL Server 2014 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was […]

Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting SQL Server 2012 Roles

by

Troubleshooting SQL Server 2012 Roles If you have problems with SQL Server 2012 roles, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because many SQL Server 2012 roles bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time this article was...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Oracle Pro Members Standard Members

Proxy Authentication Via Roles

by

Proxy Authentication Via Roles By Yuli Vasiliev Proxy authentication via roles in Oracle Database gives you greater flexibility when you want to realize the principle of least privilege. You don’t grant privileges directly to users but to roles. Also, when connecting through another user, you’ll be able to enable only those roles that are needed to get the job done....

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →
Pro Members SQL Server Standard Members

Troubleshooting problems with SQL Server 2008 R2 roles

by

Troubleshooting problems with SQL Server 2008 R2 roles If you have problems with roles in SQL Server 2008 R2, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 role bugs were fixed in SQL Server service packs, you should install the latest SQL Server service...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Continue Reading →