MS SQL – SSMS error 2

Recently I encountered again an MS SQL SSMS that reported errors when starting ?

There was also a .NET JIT Debugger that started.

The detailed log gave me the hint on why the error appeared.

I remembered that some time again the %LOCALAPPDATA%\Temp folder was cleaned

Meaning that this folder 883 was missing ?

SOLUTION :

I remembered that some time again the %LOCALAPPDATA%\Temp folder was cleaned

Meaning that this folder 883 was missing ?

Just creating this subfolder in the Temp solved the startup issues

Enjoy !!

MS SQL – SSMS error 1

Recently we encountered a strange Error when opening the SSMS ?

The Microsoft.SqlServer.Management SqlStudio, … did not load correctly.

Restarting the SSMS did not help

If you click YES continue all seems OK but this is not the case …

When opening a database you get the next error :

Service Microsoft.SqlServer.Management.IRegistrationService’ not found (Microsoft. SqlServer .Management.SDK.Sqlstudio)

.

When looking on the internet they all pointed out to a permissions issue ?

1. Give permission to the DOCUMENTS folder

 https://stackoverflow.com/questions/57588926/error-while-connecting-to-database-server-from-sql-server-management-studio

2. Update SSMS

https://stackoverflow.com/questions/57588926/error-while-connecting-to-database-server-from-sql-server-management-studio

3. Repair MS SQL Server

https://spgeeks.devoworx.com/service-microsoft-sqlserver-management-iregistrationservice-not-found/

But non of these applied to this case because I logged on as Administrator and the installation was not that old …

.

SOLUTION :

1. Temporary workaound was to start the SSMS.exe using Admin Priviliges.

This lead me to the understanding that the problem was linked to the domain Admin Account ?

After digging a bit deeper I found out that one om the colleagues applied some GPO policies for Desktop folder redirection 

And the administrator was included in that AD Group ?

2. Final Solution was to remove the Domain Admin from that AD group

Everything worked again a usual.

Enjoy !!

MS SQL – Install only SSMS to do an Azure Backup

If you need to install only the SQL Management Studio these days, you will need to go to maximum SQL 2014 !

In the later versions this is not possible anymore to separately selecting the SSMS

Solution :

Download the version INCLUDING the ADVANCED TOOLS

https://www.microsoft.com/en-us/download/details.aspx?id=42299

Use this option

Choose only “Management Tools – Basic and Management Tools – Complete” as shown below:

And you are ready to rock and roll …

Tip : When you need to do an SQL Azure Backup to an onside server YOU NEED SSMS a the tool to do so !

It will save your SQL Backup as *.bacpac file

See here for more info :

https://mikhail.io/2016/10/azure-sql-databases-backups-disaster-recovery-import-export/

Export can also be triggered from Azure Portal and PowerShell scripts or using Command Line Tools :

Data-Tier Application Framework : https://www.microsoft.com/en-us/download/details.aspx?id=46898

SqlPackage.exe is part of the SSDT : https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017

More info : https://msdn.microsoft.com/en-us/library/hh531248(v=vs.103).aspx

Enjoy !

MS SQL – Performance Dashboard

Microsoft is distributing a nice – MS SQL Performance Dashboard which you can use in the SSMS and SSRS.

MS SQL 2005 : http://www.microsoft.com/en-us/download/details.aspx?id=22602

MS SQL 2008 / 2012 : http://www.microsoft.com/en-us/download/details.aspx?id=29063

Getting Started with the Performance Dashboard Reports in SSMS

1. Each SQL Server instance you plan to monitor must contain the procedures and functions used by the queries in the reports. Using SQL Server Management Studio (SSMS), open the Setup.sql Script from your installation directory (default of %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard) and run the script.

Close the query window once it completes.

2. In the Object Explorer pane in SSMS, right mouse click on the SQL Server instance node, then choose Reports-Custom Reports. Browse to the installation directory and open the performance_dashboard_main.rdl file. Explore the health of your server by clicking on the various charts and hyperlinks in the report.

All of the remaining reports are accessed as drill through operations from the main page or one of its children. For a detailed explanation of all installation requirements and guidance on how to use the reports, please see the help file, PerformanceDashboardHelp.chm.

Once installed you can also use it inside of the SSMS – Browse to %ProgramFiles(x86)%\Microsoft SQL Server\110\Tools\Performance Dashboard folder and open the performance_dashboard_main.rdl report.

Getting Started with the Performance Dashboard Reports in SSRS

To get it to work you need to run the SETUP.SQL query in the Master DB. Copy all files from the install directory to your SSRS reports directory. And upload them to the SSRS Reporting Portal.

Create a Shared Data Source in the Report Server !

Once the reports are using the correct data source you can run the main Report to test it.

SharePoint Database Health Dashboard – Bonus

If you are running SSRS in SharePoint Integrated Mode, than you have a nice interface to monitor your database Health.

Just publish the SSRS report to a SharePoint library

And there you go all the data is available per content database.

Enjoy !!