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...
Tag: roles
Troubleshooting SQL Server 2017 Analysis Services problems (Part 1)
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...
Troubleshooting problems with linked servers in SQL Server 2017
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...
Troubleshooting SQL Server 2017 Roles
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...
Troubleshooting SQL Server 2016 Roles
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...
Some tips to work with SQL Server 2016 alerts
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...
Troubleshooting SQL Server 2014 Roles
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 […]
Troubleshooting SQL Server 2012 Roles
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...
Proxy Authentication Via Roles
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....
Troubleshooting problems with SQL Server 2008 R2 roles
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...