.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSRS2008: no Integrated Security; MOSS integrated; WebfrontEnd separate

Posted By:      Posted Date: August 29, 2010    Points: 0   Category :Sql Server
Hi, we have the following setup: 2 webfrontend servers MOSS 2007 with RS addin 1 MSSQL 2008 Cluster 1 MSSQL 2008 with Reporting Services installed when trying to use integrated security in the datasource, i receive the exception saying that integrated security is not configured. doing this on a standalone (MOSS, SQL, SSRS) environment everything works. Do I need to configure the usage of integrated security? Maybe Kerberos ? Regards Sven

View Complete Post

More Related Resource Links

Intranet Users Challenged When Using Windows Integrated Security


We've setup an intranet site using Windows Integrated Security. Its up and running and users can access it. However, they are being challenged with a login dialog for the server when they initially access the site.

Isn't is possible to configure the server so that the users aren't challenged AND are recognized as being already authenticated by Windows? We're trying to go with a seamless experience, whereby all they have to do is login to their machine like normal and then go from there.

Subscriptions using Windows Integrated Security (Datasource)

Hi All, Having an issue with SSRS 2008 at the moment, trying to setup subscriptions.Our system is configured so that any one of 10 users can login to the SSRS website using their windows domain account, and then launch report builder to design and save reports.  This all works very well, however, they have a problem when trying to setup subscriptions - the famous "Subscriptions cannot be created because the credentials used to run the report are not stored....."What the message says is true - the credentials are not stored as they are supplied by the user when they login to report builder.Is the /any/ workaround at all that doesn't involve storing the credentials?  It seems totally crazy that they cannot be prompted for them when setting up the subscription.  For this application its 100% essential to make the user provide their credentials when running reports, because they each see a filtered subset of the data in the report model (this is controlled DB side depeding on the login account), so their domain account needs to be passed to SQL server to enable this filtering to work.  If we saved their credentials then they would see all the data..and thats nasty.The only workaround I can come up with would be to create  a separate datasource for each user and upload a separate model, but thats really nasty to be honest and creates an ad

IIS 7 - Integrated security

Hi, I'm trying to use integrated security in IIS7 (Windows 2008) to connect to a database and add some tables as part of a Vistual Studio installer. I've set up my Application Pool so it users a domain user account to run the pool. As part of the installer, I connect to the database and add some tables though it doesn't seem to recognise the Application Pool indentity from the installer. The same method works fine in Windows 2008 R2 but Windows 2008 seems to have issues with this. I know it's a long shot but has anyone got any ideas? Regards Chris 

JDBC and Integrated security

So, I'm still getting errors when configuring a connection with integrated security: and YES, I copied the sqljdbc_auth.dll into system32 directory (and I put a copy into systemWOW64 also.).<---   error message:ect to Development Server.  Error creating SQL Model Connection connection to Development Server. (Error: This driver is not configured for integrated authentication.)  This driver is not configured for integrated authentication.  Error creating JDBC Connection connection to Development Server. (Error: This driver is not configured for integrated authentication.)  This driver is not configured for integrated authentication.end error message --->I'm no expert here, but the message indicates, to me, that it's the *driver* that doesn't support integrated security. WTF? Was this an oversight? Or is something wrong on my side (Win 7, SQL2005, Eclipse Data Tools, sqlJDBC4, both ver 2.0 and v3[CTP]). I saw messages relating back to version 1.2 that this problem would be fixed.Mark

SS2K8RS in MOSS 2K7 Integrated Mode; Customers are getting Access Denied

Hello             I have SQL Server 2008 Reporting Services Running in SharePoint 2007 Integrated Mode. I have created and successfully deployed many reports to the server and as the admin I can view the reports with no problems. Initially my customers who have read access were also able to access the reports with no problem. As of two days ago the customers are receiving “Access Denied” errors and being asked to request access. For one customer I gave him contribute rights and they still received the “Access Denied” error. The only real configuration change made it that I ran the “SharePoint Products and Technologies Configuration Wizard”.             I have been floundering around a couple of days trying to find a solution; I hope someone will be able to assist.

Subscription problems, SharePoint and MOSS 2007 in Integrated Mode


This does not happen all the time, in fact about 5% of the time, but here's the error message when trying to "manage subscriptions" for an SSRS report:  Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
Troubleshoot issues with Windows SharePoint Services.

Now if I send a copy of the report to file, rename it, upload it again, and try again -- then the error message usually goes away.  In short, intermittently the subscription capability goes away for a given report and then only way to get it back is to delete the report and re-upload it under a slightly different name.

How set connection Integrated Security property


Does anyone have a handy snippet of code in C# or VB.net to find and set the "Integrated Security" property of a connection?

I used to do this stuff in DTS, but ... that was a long time ago!




Help me solve this question:Invalid value for key 'integrated security'


I has develop a website using vS10 using Operating system vista and was working well however i apply it at different os which is window 7 it appeared this error

Invalid value for key 'integrated security'.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Invalid value for key 'integrated security'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: Invalid value for key 'integrated security'

Changing WindowsIdentity creates sql login errors for integrated security connections


I am using winows authentication to connect to a web page and user.identity and principle.windowsidentity are showing as my currently logged in active directory user.  I can successfully connect to SQL Server with a integrated security connection string at this point.

I then prompt the user for login as a different account on the domain and change the principle.windowsidentity to this login using




"advapi32.dll", SetLastError:=True)> Private Shared Function LogonUser(ByVal lpszUsername As String

Passing credentials to run query web service with integrated security

Dear, I want to publish a web service that I perform a query to a db, the problem is that access to the database with integra

IIS 7.0: Enhance Your Apps with the Integrated ASP.NET Pipeline


Mike Volodarsky demonstrates how IIS 7.0 lets you add performance and security upgrades to PHP apps without touching a line of PHP code.

Mike Volodarsky

MSDN Magazine January 2008

Smart Clients: New Guidance And Tools For Building Integrated Desktop Applications


Integrated Desktop is a loosely coupled hosting architecture and composite UI that runs on the desktop and is supported by a loosely coupled architecture on the back end. It collapses the number of applications a user must deal with when making decisions.

Christian Thilmany and Jim Keane

MSDN Magazine September 2006

Real-World XML: Manipulate XML Data Easily with Integrated Readers and Writers in the .NET Framework


In the .NET Framework, XmlTextReader and XmlTextWriter provide for XML-driven reading and writing operations. In this article, the author discusses the architecture of readers and how they relate to XMLDOM and SAX parsers. He also shows how to use readers to parse and validate XML documents, how to leverage writers to create well-formed documents, and how to optimize the processing of large XML documents using functions to read and write Base64 and BinHex-encoded text. He then reviews how to implement a stream-based read/write parser that combines the functions of a reader and a writer into a single class.

Dino Esposito

MSDN Magazine May 2003

.NET Framework-Part 2: Microsoft .NET Framework Delivers the Platform for an Integrated, Service-Ori


This article completes the .NET Framework overview begun in the September issue. The common language specification and ILDasm, the MSIL disassembler, are discussed-as well as how metadata, manifests, and assemblies simplify deployment and versioning. Security, which is integral to the design of .NET, is examined extensively, followed by a walk through the development of a single assembly containing multiple files. Finally, the way managed and unmanaged code work together, and the benefits of using each, including interoperablity with unmanaged code, are described.

Jeffrey Richter

MSDN Magazine October 2000

Microsoft .NET Framework: Delivers the Platform for an Integrated, Service-Oriented Web


The Microsoft .NET Framework is a new platform for building integrated, service-oriented applications to meet the needs of today's Internet businesses; apps that gather information from, and interact with, a wide variety of sources, regardless of the platforms or languages in use. This article, the first of a two part series, illustrates how the .NET Framework enables you to quickly build and deploy Web services and applications in any programming language. Microsoft Intermediate Language and JIT compiler, which make this reuse possible, are described as well as managed components, assemblies, and the Common Type System (CTS).

Jeffrey Richter

MSDN Magazine September 2000

Cannot export from a Report in SharePoint integrated mode in a server hardend environment


We have installed Reporting Services 2008 integrated with MOSS with SQL Server 2008 on a 64 bit platform.

The environment has worked fine in test (but the servers are not hardend).

With the production environment, any attempt to export from a report into another format (eg excel, tiff etc) results in an unexpected error within SharePoint requiring closing the browser and reopening.

There are no details behind the error. We can also find no traces of the error within any of the logs (SharePoint, Reporting Services, Windows event log etc)

When the report is opened directly from Reporting Services (ie http://servername:8080/reportserver) the report exports fine. Similarly, if the report is opened directly from Report Builder 2, or through opening Report Builder 2 from SharePoint there is no issue. This issue only happens when the report is invoked directly through SharePoint.


We can only assume that this issue has something to do with server hardening/UAC as we have

Share Point integrated SSRS reports rendering when access from external site


Our client has a SharePoint (moss2007) site on Windows 2008, SQL2008 R2 Enterprise, and Reporting service is integrated with SharePoint

The authentication on the share point integration is set to windows, else the authentication for the SSAS datasource gives and error

The extranet zone ( forms) and intranet (Customer Forms) and default (Windows) zones are all access from inside the firewall and the reports render in each with no issues, as the datasources are configured to pass a sql username and password.

However, report rendering is a problem from the internet (external site), the following error is displayed:

An unexpected error occurred while connecting to the report server. Verify that the report server is avai
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend