Quick start for SSRS authentication

19/12/2012

1.       Configure SSL Connections on a Native Mode Report Server  http://msdn.microsoft.com/en-us/library/ms345223.aspx   2.       A full end to end SSO custom solution with in an application can be downloaded from here: http://code.msdn.microsoft.com/SQL-Reporting-Single-Sign-eace0073. a step by step can be found at cliff green's blog: http://blogs.msdn.com/b/cliffgreen/archive/2011/03/29/reporting-services-single-sign-on-sso-authentication-part-1.aspx     3.     Supported authentication types: All users or applications who request access to report server content or operations must be authenticated using the authentication type configured on the report server before access is allowed. The following table describes the authentication types supported by Reporting Services. AuthenticationType Name HTTP Authentication Layer...
אין תגובות

Authentication with the Report Server 2012

   Supported authentication types:All users or applications who request access to report server content or operations must be authenticated using the authentication type configured on the report server before access is allowed. The following table describes the authentication types supported by Reporting Services.     AuthenticationType Name HTTP Authentication Layer value Used by default Description RSWindowsNegotiate Negotiate Yes Attempts to use Kerberos for Windows Integrated authentication first, but falls back to NTLM if Active Directory cannot grant a ticket for the client request to the report server....
תגיות: ,
תגובה אחת

Microsoft® SQL Server® 2012 SP1 Feature Pack

16/12/2012

To better run EXCEL against SQL 2012 SSAS, Please download the following: Microsoft® SQL Server® 2012 SP1 ADOMD.NET ADOMD.NET is a Microsoft .NET Framework object model that enables software developers to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2012 SP1 Analysis Services. ADOMD.NET is a Microsoft ADO.NET provider with enhancements for online analytical processing (OLAP) and data mining.Note:The English ADOMD.NET setup package installs support for all SQL Server 2012 languages. Filename: X86 and x64 Package(SQL_AS_ADOMD.msi)Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2012 SP1 The Analysis Services OLE...
אין תגובות

ssis connection manager not storing sql password

  The designed behavior in SSIS is to prevent storing passwords in a package, because it's bad practice/not safe to do so. Instead, either use Windows auth, so you don't store secrets in packages or config files, or, if that's really impossible in your environment (maybe you have no Windows domain, for example) then you have to use a workaround as described in http://support.microsoft.com/kb/918760 .The simplest answer is a config file to go with the package, but then you have to worry that the config file is stored securely so someone can't just read it and take the credentials....
אין תגובות

SQL 2012 OffLine cube

Local cube files have an extension of .cub. We can open the SSMS and open a new mdx query editor window. Then we will create a GLOBAL CUBE query. This is a strange thing. Although the query uses CREATE GLOBAL CUBE, but it is in fact known as local cube or offline cube. Code Snippet CREATE GLOBAL CUBE STORAGE 'C:\Documents and Settings\bcsmith\My Documents\Adventure Works.cub' FROM ( MEASURE ., MEASURE ., MEASURE ., MEASURE ., DIMENSION .., DIMENSION .., DIMENSION [Adventure...
אין תגובות

sp_addserver for remote servers is discontinued

Microsoft SQL Server, had a provision to add remote servers until SQL Server 2008 R2. From Microsoft SQL Server 2012, this functionality is now deprecated, and we now need to add "linked” servers instead. If a user does attempt to use the sp_addserver syntax to add a remote server, system will result in the following error: Msg 15663, Level 16, State 1, Procedure sp_MSaddserver_internal, Line 60Feature "sp_addserver" is no longer supported. Replace remote servers by using linked servers. The solution is to use the sp_addlinkedserver system stored procedure, using which the script would require changes as under: ...
אין תגובות

SQL 2012 Linked servers

sp_addlinkedserver (Transact-SQL) Creates a linked server. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created by usingsp_addlinkedserver, distributed queries can be run against this server. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed. Syntax sp_addlinkedserver 'server' 'product_name' ]      'provider_name' ]      'data_source' ]      'location' ]      'provider_string' ]      [ , [ @catalog=...
תגובה אחת

SQL 2000 Linked Server at SQL 2012

The SQL Server Native Client (SQLNCLI11) that ships with SQL Server 2012 does not support connections to SQL Server 2000 an earlier. I found this out during testing of our upgrade to SQL 2012. We upgraded our 2008 R2 servers in-place and it appears to have left the SQLNCLI10 provider in place but if you did a fresh install of SQL Server 2012 on a new server you may not have this provider. Does your 2012 server have the SQLOLEDB provider listed under Linked Server Providers in SSMS? If so, you could try using that.   Issue ...
תגיות:
7 תגובות