Wednesday, November 15, 2017

New Subscription or New History Snapshot produces error

SQL Server 2016 SP1 on Windows 10 Professional on a Dell Laptop
Report Manager (Web Portal URL) has reports embedded, folders etc. Report server; Report Manager and Report Builder 3 are all working.
Trying to create a New Subscription or New History Snapshot produces error. Report user is administrator of SQL Server 2016 SP1 as well as installer. The current user is also the Reporting Services Administrator. The report is neither a linked report not does it have parameters. Data Source credentials are that the report author who is also the current user as well as the server installer on the Windows 10 Pro laptop.
Here are the messages. Some MSDN content on MSDN site related to this subject is outdated and does not relate to some of the procedures mentioned in MSDN articles.

Jayaram Krishnaswamy

Wednesday, November 8, 2017

Power BI and Microsoft OLEDB Provider for ODBC Drivers

Power BI does not support the Microsoft OLEDB Provider for ODBC Drivers also known as MSDASQL.

Power BI uses the .NET Framework Data Provider of OLEDB (System.Data.OLEDB).
This was found while connecting Power BI to Microsoft Excel using the connection string developed using a (Universal Data Link) UDL file.
; Everything after this line is an OLE DB initstring
Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DSN=Excel7_11;DBQ=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam_old.xls;DefaultDir=C:\Users\Owner\Desktop\Blog2017\MSSS2017;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;";Initial Catalog=C:\Users\Owner\Desktop\Blog2017\MSSS2017\Hindu_Islam.xlsx
Also Power BI does not support the Persist Security Info attribute set to false.
This is the error message about OLE DB Provider support.

Tuesday, November 7, 2017

You do not see Report Builder 3 in your All programs

You may not the only one. I installed Report Builder 3 soon after installing SQL Server 2016 and later upgraded with SP1. I could see the Report Builder app icon in the All programs.

After installing Visual Studio Community 2017 and or after installing SQL Server Management Studio V 17.3, I do not see the Report Builder icon.

Right now it is under a different program group as shown here:

Wednesday, November 1, 2017

Problem with Microsoft Edge 41.16299.15.0.

It does not bring up the Report Server Web Services URL which is healthy viewing from other sources (Chrome, IE 11).

It also has some crazy display problems. Suddenly the page is only partially displayed. It does not matter even if you maximize the web browser display.

This is the Edge display.

The Task Manager is shown that many Edge tabs are open (but not seen in the above).

I need to use Task Manager to close the Edge.

This version was installed recently by Microsoft staff at Ala Moana to fix some computer problems.

SQL Server 2016 SP1 repair does not fix Reporting Services Problem

Problem with SQL Server Reporting Services 2016 SP1 is still unsolved. Two things that prevent me from going further is that I cannot use the SQL Server Reporting Services 2016 SP1 because:

Microsoft Edge is not displaying the Report Server.
Web Portal URL is not working and this happens to be the front-end for the Reporting Services.

I assumed that probably there is something wrong with the SQL Server 2016 Sp1 and I went through a repair process:

It appears there is no problem with the Reporting Services 2016.

Monday, October 30, 2017

This is a serious security breach problem with SQL Server Reporting Services 2016

I have been having problem accessing the Web Service URL and Web Portal in Microsoft Edge as well as Mozilla Firefox-both the latest versions.

Microsoft Edge accepts the authentication after three times  entering the same Username/Password with the third time going to the web address. However it does not load and there is a message but with no instructions to go further.

In Mozilla entering the Web Service URL or Web Portal URL in the address with the same authentication information does not even go to the address. There were no messages.

Using the Report Builder you can connect to the Report Server and view the reports; datasources; report parts etc.

These URLs being crucial to work with SQL Server Reporting Services (SSRS), this is totally unacceptable.

What is more serious is that the Reporting Server has no security! When I enter the site address in a Chrome browser, I am not even asked for authentication dialog and I am taken straight to the server. This should not happen. I could even do a ListChildren command. Both Web Service URL and Web Portal URL do not require authentication. Wow!

I thought perhaps it has something to do with Chrome, but no. When I tried with Internet Explorer (on Windows 10) it was amazing. Asked for no authentication, web addresses were accessible.

I think this is something to do with Windows 10 and perhaps not that of Reporting Services.

I am not new to Reporting Services as I have written about them previously.

Notes after the original post (11/2/2017):

I have looked at Internet Options and I do not think these are the reasons why Internet Explorer displays the Web Service URL and Web Portal URL without asking for authentication. The first two images are for Internet Explorer and the last one for Microsoft Edge.

These two are for IE 11. The Web Service URL come sup immediately without prompting for authentication.

This one for Microsoft Edge (latest version)

The Microsoft Edge requests authentication information and succeeds only on the third time (each time same information is provided) but the Web Service URL does not load.

Sunday, October 29, 2017

Report Builder connects to Web Service URL but not the Edge browser

It appears strange that the Report Builder can connect to Report Server and access reports but not the browser.