Tag Archives: SSMS

ByHariharan Rajendran

Latest Update on SQL Server Management Studio

This simple post highlights the top level updates on components in SQL Server Management Studio.

The latest release of SQL Server Management Studio v17 RC3 has updates on below section compare than the earlier version.

  1. Microsoft SQL Server Management Studio
  2. Microsoft Analysis Services Client Tools

ByHariharan Rajendran

Limitations of Custom Reports in SQL Server Management Studio

I have discussed Custom Reports in my earlier post, this post highlights the limitation of custom reports in SQL Server Management studio.

Microsoft provided few custom reports for R services. When I use those custom reports, SQL Server Management Studio has stopped working for all the reports.

SSMS_Stopped

Then I started to check the reports in visual studio. When I check the reports, it used some of the expressions which SQL Server Management not support.

Limitations,

  1. The dataset should be embedded in the report.
  2. Expressions – Regular Expression like sum, count will work but report specific expressions will not be supported, it could be an expression to open drill down reports and etc.
  3. Parameters – If the report has a parameter that should have a default value.

Download the modified version of R Services Custom Reports.

Download

ByHariharan Rajendran

Custom Report for SSMS

It is very easy to create a custom report and use it inside SQL Server Management Studio.

As we know, we have standard reports from Microsoft to monitor the Server and Database information.

These reports are available for instance and database level, If you are not aware of this standard reports, please check it below to access those reports.

 

image

image

Steps to use custom report in SQL Server Management Studio.

Just created a Report as like below,

image

We need to adjust the data source properties to use inside SSMS. Modify the data source like below. Once modified the data source, save the report. We will take this rdl file and attach in SSMS.

image

image

image

Once added the report, open and see the information.

image

Now, you can refresh the report and see the real time information and even you can build a report to specific database for monitoring purpose.

Happy Learning.

ByHariharan Rajendran

SQL Server Management Studio Firewall Settings

We need to follow the below steps to connect the azure based SQL Server in SSMS

1. Add the client IP address in azure firewall

2. Use the azure SQL Server name with proper credentials.

The above steps should be carried out until SQL Server 2016 to access the SQL databases in SSMS.

If IP is not configured then SSMS will not allow to connect, it will through the below error message.

image

 

SQL Server 2016 CTP 3.3 has built in feature to add the IP in azure SQL Server firewall from SSMS itself.

Follow the below steps,

1. There is no IP configured in Azure SQL Server Firewall

image

2. Enter the server name and credentials and click connect. It will open a Azure account sign in window

image

 

image

3. Server will be connected and can access the databases. Client IP address added into firewall.

image

1