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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

How to pass credentials from Visual Web Developer to Reporting Services

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :Sql Server
 

Hi, 

I have a SQL Server 2005 database with Windows Credentials. I am trying to pass my credentials from Visual Web Developer to my report but it returns me: "Cannot create a connection to data source". 

How I have to pass the credentials to the report? 


Best Wishes, Arbi --- Please vote if you find this posting was helpful or Mark it as answered.


View Complete Post


More Related Resource Links

How to pass credentials from Visual Web Developer to Reporting Services

  

Hi, 

I have a SQL Server 2005 database with Windows Credentials. I am trying to pass my credentials from Visual Web Developer to my report but it returns me: "Cannot create a connection to data source". My web application is based on Windows login as well.

How I have to pass the credentials to the report?


How to save Windows credentials to a data source in SQL Server Reporting Services 2008 using Visual

  
I am trying to create a shared data source for SQL Server Reporting Services 2008 that uses a specific Windows user ID and password to connect to the database. Using the Report Manager web interface, if I create a shared data source and specify "Credentials stored securely in the report server", I can check the "Use as Windows credentials when connecting to the data source" checkbox. This tells SSRS that the user ID and password I specify are from a Windows user, not a SQL Server user. I want to create the shared data source using Visual Studio though. In Visual Studio I have an option to use stored credentials but there is no equivalent of the "Use as Windows credentials when connecting to the data source" checkbox. SSRS always assumes that user and password are for a SQL Server user, not a Windows user, and thus the connection fails. Does anyone know how to tell Visual Studio that the stored credentials are for a Windows user?

Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

Unable to pass default network credentials from a .NET / SharePoint application to Web Services

  

Require some help in passing the authentication of a logged-in user to a web services (which is a wsdl file added as web reference to the application) from an ASP.NET application/ SharePoint 2010 portal. When the application calls the web service, the default network credentials need to be passed to the web service to get authenticated to use the data repository. This web service is used for searching a data repository depending on the logged in user's credentials and search query.

We have made necessary changes required in the applications like.

Necessary changes in web.config (like authentication mode to Windows, impersonation is made true). Install client certificates to the trusted location.

Enable IE 8.0 to use Integrated Windows authentication (Internet Explorer -->Tools-->Internet Options -->Advanced--> Security --> Enable Integrated Windows Authentication.

Even the web services have methods to get the windows network credentials. While trying the following code, to pass current credentials, default credentials is empty.

myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials (Here it is a null value)

Application is using Windows Authentication | NTLM.

The following code works, if the authenticat

Can I pass a user's active directory group as a parameter to reporting services?

  

Hi there,

I am wondering if I can pass a user's active directory group as a parameter to reporting services? If so, how can I do that (e.g. where can I get that group from?)?

Is there something as User.UserID for active directory groups?

Many Thanks and best wishes

Oliver

Oliver


Creating and Using an ASP.NET Web Service in Visual Web Developer

  
In addition to letting you create Web pages, Microsoft Visual Studio also lets you create Web services that use ASP.NET XML. Creating a Web service in Visual Studio is similar to creating a Web page. You can also use the Microsoft Visual Web Developer Web development tool to reference and use Web services that are in a Visual Web Developer solution, on your local computer or in a local or external UDDI directory. In this walkthrough, you will create the Web service in one solution and use it in another.

Tasks illustrated in this walkthrough include:

Creating a simple XML Web service in Visual Web Developer.

Creating a separate Web site that uses the Web service.

Integrate Reporting Services with Silverlight and RIA Services

  
One of the most wanted future features in Silverlight is the possibility to create business reports using Reporting Services. In this article, I will show how to use the existing Reporting Services technology with Silverlight and RIA Services combination.

Visual Web Developer 2008

  

I'm getting th error "unable to connect to the asp.net development server 2008"

It's been working fine for months and all the sudden.I'm fairly new at this so if you have a fix I will need details.

Thanks,

Regards


Visual Web Developer 2010 Express "Copy Web Site" using different login

  

I created a site and am trying to grant another pesron access to upload changes to it without giving them my super-user login.


I made a login for her but I can't test whether it works or not because no matter how much I "disconnect" in the Copy Web Site page of VWD 2010, reconnecting to the same site always logs in as my superuser account without prompting me for a login again.

How do I test is the account it set up correctly before having her try to upload to it?    I want to force the login to remote site dialog to pop up again to test her account.

Any ideas?


Reporting Services SQL 2005 .Net 4 compatibility?

  

I've been working on my first asp.net application and for the most part it's been pretty smooth.  Right now I'm having trouble getting reporting services working under SQL Server 2005.  I developed the site with Visual Studio 2010 and didn't think about any of the .Net 4.0 compatibility issues that have arisen.  I'm having no problems with the site communicating with SQL Server 2005 for the regular database stuff.  The only problem I'm having is with setting up Reporting Services.  I have the .Net 4.0 framework installed on the server, however Reporting Services is still using 2.x.  I'm not sure if this is a problem with SSRS or with IIS.  When i go to localhost/Reports it's reading my web.config for my application and throwing an error: "Parser Error Message: Unrecognized attribute 'targetFramework'."  This is referring to a line in my web.config where targetFramework is set to 4.0.


Software that I'm using:

  • Visual Studio 2010
  • SQL Server 2005 Standard
  • IIS 7.0
  • .Net 4.0

Any suggestions?  


Reporting services in 2008 r2 how to get a report in a print button click event in my c#.net page

  

how to  get a report in my c#.net page button lick event also steps to call a report from asp.net to reporting services

 

Thanks in advance


Workflow Services: Visual Design of Workflows with WCF and WF 4

  

The .NET Framework 4 makes it easier than ever to implement WCF services using WF. We'll demonstrate just how easy it is by modeling a long-running, durable and instrumented workflow based on a real-world business case without having to write any code.

Leon Welicki

MSDN Magazine May 2010


VS 2010: Entity Framework 4.0 and WCF Data Services 4.0 in Visual Studio 2010

  

Elisa Flasko takes you through a sample weblog application to demonstrate how new improvements in Entity Framework and WCF Data Services work together to simplify the way data is modeled, consumed and produced in Visual Studio 2010.

Elisa Flasko

MSDN Magazine April 2010


Single Sign-On: A Developer's Introduction To Active Directory Federation Services

  

Use Active Directory Federation Services to allow other organizations to use your Web applications without the need for you to grant access explicitly.

Keith Brown

MSDN Magazine November 2006


SQL Server 2005: Jazz Up Your Data Using Custom Report Items In SQL Server Reporting Services

  

Custom report items in SQL Server 2005 Reporting Services address your needs for custom reports without the pain of doing it from scratch.

Teo Lachev

MSDN Magazine October 2006


Data Points: Report Controls in SQL Server 2005 Reporting Services

  

Reporting has always been one of the dark arts of development. The tools typically seem to do just enough to get you to a certain point, then leave you to find workarounds to solve more complex issues.

John Papa

MSDN Magazine July 2006


Categories: 
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