sql server

How to rename a report in SSRS (SQL Server Reporting Services)

Here's how to change the name of your SQL Server report.

Describe table in SQL Server 2005 - Equivalent of Oracle Describe command

In Oracle, the describe command shows the metadata for a table in your SQL database. The equivalent command in Microsoft SQL Server 2005 (and 2008, probably) is sp_columns.

You receive "Cannot create a connection to data source" when opening a report on SQL Server Reporting Services

This error may be caused because of insufficient permissions to open the data source. Check the properties of the data source in the Reporting Services web interface.

Error 401 Accessing the Report Website

If you have Reporting Services, SQL and IIS installed on the same server, you may receive an HTTP error 401 that says, "The request failed with HTTP status 401: Unauthorized." The solution is to "Disa

Visual Studio will not deploy report to SQL Server Reporting Services

If Visual Studio will not deploy your report to the Windows Server, and you have not deployed to it before, check the security (SSL) settings for the server.

Syndicate content