SQL Server Data Tools for Visual Studio 2017

by Levin, Aric

SQL 


Posted on 8/28/2017 7:55:00 PM


The preview version of SSDT for Visual Studio 2017 (15.3.0 preview) is now available. This release introduces a standalone web installation experience for SQL Server Database, Analysis Services, Reporting Services, and Integration Services projects in Visual Studio 2017 15.3 or later.

Read More

Permission accessing SSRS Report Server/Manager

by Levin, Aric

SQL 


Posted on 4/4/2014 2:50:00 PM


Recently we have encountered an issue where a domain admin (and local admin) account was trying to access the SSRS Report Manager and Report Server web sites and was getting the following error:
User DOMAIN\UserAccount does not have the required permissions. Verify that the permissions have been grated and Windows User Account Control (UAC) have been addressed.

Read More

Deploy a Report Builder 3.0/VS 2010 Report on SSRS 2008

by Levin, Aric

Development  Dynamics CRM  SQL 


Posted on 7/19/2011 7:31:00 PM


Visual Studio 2010 and Report Builder 3.0 RDL reports use a new schema that is not supported by SQL Server 2008 Reporting Services. They are designed to work only with SSRS 2008 R2. Currently there is no way to publish a VS2010 Report on SQL Server 2008 without some modifications to the RDL code.

Read More

Report Viewer Control not displaying data when deployed IIS7

by Levin, Aric

Dynamics CRM  SQL  Web 


Posted on 11/5/2010 5:24:00 PM


This issue sometimes happens when you deploy a web application that contains report files on IIS7.
The reports work fine in the development environment, but once published nothing appears in the results.

Read More

Fixing the tp_Title field reverting to Membership Provider username

by Levin, Aric

Servers  SharePoint  SQL 


Posted on 8/20/2010 11:17:00 PM


If you are using Forms Based Authentication for you SharePoint site you might encounter the site displaying a user name such as "i:0#.f|sql-membershipprovider|username" instead of just "username".

You can modify the tp_Title field in your SQL Server UserInfo table directly, but at times the seems to be reverted back to its original value. There is a solution to this problem, however it is unsupported of course, as you are modifying a stored procedure in the SharePoint database directly.

Read More

FBA and Friendly Display Name with SharePoint 2010 and MOSS 2007

by Levin, Aric

Servers  SharePoint  SQL 


Posted on 7/8/2010 7:12:00 PM


When implementing Forms Based Authentication (FBA), SharePoint retrieves the tp_title field from the UserInfo table in the WSS_Content* database to display the name of logged in user.
Depending on the method of adding the users to the SharePoint site, this login might appear with the membership provider details as part of the display name.

Read More

Login failed for user after database restore

by Levin, Aric

Development  Dynamics CRM  SQL 


Posted on 6/29/2010 6:11:00 PM


When using SQL Server logins to connect to a database that has just been restored, most likely the following error will appear: Login failed for User 'username'

Read More