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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

How to the web client credentials to call the server (hosted in IIS 7) database with Integrated Secu

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
 
I'm dealing with a problem trying to use Windows authentication with IIS 7 in Windows Server 2008. Also i'm using WCF. I have a client application and the server application. The server application manage the user accounts using Active Directory. Everything starts when the client sends its user and password to the server application, which is hosted in the IIS(7), and this application must use the same credentials to authenticate the user in the Active Directory. Also after the user is logged in the application, every request sent to the database must use Windows Integrated Security. I already installed Windows Authentication in the IIS 7, and also I enabled it, (and disabled Anonymous Authentication), also I added authentication mode="Windows" in the server app Web.config. I would like to know: - How can I know which user is running the server application (In other words, which user is doing requests to the database). I forgot to say I can't use the SQL Server Profiler cause I don't have permissions. - If I'm missing something, cause I don't want to have security problems in the application. By the way this website says something about this topic but using another IIS version. http://imar.spaanjaars.com/287/how-do-i-determine-the-security-account-that-iis-uses-to-run-my-web-site


View Complete Post


More Related Resource Links

WCF - First call to Callback instance from Server takes considerable time to make it to the client.

  
Hello. There's a performance problem we are facing that we are unable to fix using DuplexChannels. The first call made by the client to the server reaches the server instantly. The first call made by the server to the first client using a Callback proxy will take several seconds to reach the client. All subsequent calls to the client (as well as other clients) will reach and execute instantly. The client connects to the Server using a proxy to IServiceProvision, supplies an instance to an implementation of IClientCallback and calls IServiceProvision.Start(). The server instantly processes the call and makes an asynchronous call to IClientCallback.DoWork(), which takes several seconds to enter the client's DoWork() implementation. The remainder of the execution then runs smoothly. Also, the server will experience such a slowdown only for the very first call of the first client that connects to it. Is it normal for the Callback interface to take so much time to warmup, only on the first call to the first client? Below is the full source code. Thanks for any information you may provide. Cheers Mike Shared Class Library using System.ServiceModel; namespace Test { [ServiceContract(Namespace = "http://test/IService", CallbackContract = typeof(IClientCallback))] public interface IServiceProvision { [OperationContract] void Start(); [OperationContract] void

Access database using client credentials

  
I have created a small wcf project that comprises the following  TZ_PI_Interface_WCF - This is a WCF service hosted in IIS  TZ_PI_Interface_Client - This is a test client The service is running in as much that my client communicates with it and executes code in the service. My client app executes the GetProcessData_GetSearch_Client_Detail of my service.  This method should go off to a database and return some data to the client. For the purposes of this test I am catching exceptions in the GetProcessData_GetSearch_Client_Detail method and returnind the error message as a piece of data. When the GetProcessData_GetSearch_Client_Detail is executed, a connection should be made the a database and data should be returned to the client The results I get depend on my connection string. These are the scenarios I am trying along with the results of executing GetProcessData_GetSearch_Client_Detail 1) Local DB Test using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user 'N075650\ASPNET' 2) Local DB Test using SQL Login  Data correctly returned 3) Remote DB using Integrated Security  Connection Error: System.Data.SqlClient.SqlException: Login failed for user '(null)' 4) Remote DB using SQL Login  Data correctly returned In the live environment I will have the service hosted on an IIS server (6.0) and the

WCF web service hosted in Sharepoint 2010 is called TWICE for a single client call. WHY??

  

We have WCF SOAP web service hosted in Sharepoint 2010 using service factory method and observe behavior which we cannot explain.

When authenticated web client invokes our service method “Generate” (synchronously) it is first get called with Anonymous credentials (SPContext.Current.Web.CurrentUser == null). Anonymous users don’t have enough permissions, so the first attempt of the service method to access a folder (SPContext.Current.Web. GetFolder("Shared Documents")) throws ThreadAbortException. But control does not return to the client. Instead the service method gets called AGAIN, now with correctly set SPContext.Current.Web.CurrentUser. Nowit works successfully to the end and result returns to the client.

 

The question which puzzles us a lot is WHY the service is called first time with Anonymous creds? We’d rather avoid this first invocation if possible.

WCF web service hosted in Sharepoint 2010 is called TWICE for a single client call. WHY??

  

We have WCF SOAP web service hosted in Sharepoint 2010 using service factory method and observe behavior which we cannot explain.

When authenticated web client invokes our service method “Generate” (synchronously) it is first get called with Anonymous credentials (SPContext.Current.Web.CurrentUser == null). Anonymous users don’t have enough permissions, so the first attempt of the service method to access a folder (SPContext.Current.Web. GetFolder("Shared Documents")) throws ThreadAbortException. But control does not return to the client. Instead the service method gets called AGAIN, now with correctly set SPContext.Current.Web.CurrentUser. Nowit works successfully to the end and result returns to the client.

 

The question which puzzles us a lot is WHY the service is called first time with Anonymous creds? We’d rather avoid this first invocation if possible.

Setting server UserPrincipleName in a client call SqlClr

  

I'm calling a WCF service from a SQL CLR stored procedure. As a result I cannot use the configuration file generated by svcutil.exe for my SOAP web service. If I run the WCF service under the default .NET account in IIS I'm able to complete the call without difficulty. When I run the WebService under a ServiceAccount I get the following error when I attempt to call the web service from the Sql Clr client:

System.ServiceModel.Security.SecurityNegotiationException: SOAP security negotiation with 'http://sdczeapwdcde09/TestClrService/Service1.svc' for target 'http://sdczeapwdcde09/TestClrService/Service1.svc' failed. See inner exception for more details. ---> System.ComponentModel.Win32Exception: Security Support Provider Interface (SSPI) authentication failed. The server may not be running in an account with identity 'host/sdczeapwdcde09'. If the server is running in a service account (Network Service for example), specify the account's ServicePrincipalName as the identity in the EndpointAddress for the server. If the server is running in a user account, specify the account's UserPrincipalName as the identity in the EndpointAddress for the server.

The config file provides the UserPrincipleName that I need to&n

Server call client machine and pick data from client service.

  

HI All,

Does anyone have any opinions over the best ways to connect a server to client service over internet to get data on server website.

If you have any idea and solution then please feedback me . Thanks 

Regards,

SAS

 


How do I pass username/password credentials from php client to self-hosted wcf service?

  
I have a self-hosted wcf service that just adds 2 numbers and returns the value.  It works fine, but I am not sure how I can send the username and password through the php client, so it will validate against my CustomUserNamePasswordValidator.  Here is the implementation for the Add Method:

  
public class MathService : IMathService
  {
    public double Add(double x, double y)
    {
      return x + y;
    }
  }


Here is my current App.Config:

   
<?xml version="1.0" encoding="utf-8" ?>
  

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

Connestion string create any database server

  
This links important to how to create connection string to any data base sever.

SQL Server Database Transaction

  
A transaction is a group of SQL commands executed together as a single component of work to be accomplished. If all of these commands succeed, then a transaction is committed - the changes to the data are made final. If any of the commands within a transaction fail, then the entire transaction is cancelled, or in SQL Server terms, the transaction will be rolled back.

Transactions are one of the things that keep your data safe, but they're not necessarily easy to understand. Here's some help:

Database Export Wizard for ASP.net and SQL Server

  
A step wizard for ASP.net to export database objects to CSV, TXT, HTML, XML, or SQL. it guides users through a few simple steps to choose a database object (table, view, or query), select columns, and export the data in any of the standard formats CSV, HTML, XML, or SQL.

Connecting to MS SQL Server database using webmatrix.

  

Hi,

I am novice  user to raizor syntax using webmatrix and i am trying to connect MS Sql server database (instead of using .sdf file i am using .mdf file) using the tool webmatrix for startersite.

The connection string that i setup as follows.

<?xml version="1.0"?>

<configuration>

    <system.web>
        <compilation debug="false" targetFramework="4.0" />
    </system.web>
    <connectionStrings>
    <add name="OESConnectionString" connectionString="Data Source=.\SQLServer2005;AttachDbFilename=|DataDirectory|\OES_Data.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
    </connectionStrings>

</configuration>

And i am using websecurity helper as well and the setup is as follows.

WebSecurity.InitializeDatabaseConnection("Data Source=INLTE5556\\SQLServer2005;Initial Catalog=OES;Integrated Security=True", "System.Data.SqlClient", "UserProfile", "UserId", "Email", true);

When i am trying to insert the user details into database i am getting the below error.

Format of t

sql server 2008 adventureworks database

  

dear Friends


For my MCTS 70 -433 examination, I recently installed sql server 2008 and installed the sample databases too. but my issue is, in that book they have mentioned a database called "AdventureWorks2008" and the nice thing is I don't have a such a database with me in my sql server 2008. 


And the query is 

-- MERGE Statement
USE AdventureWorks2008
MERGE INTO	Sales.SalesOrderDetailHistory AS SODH
USING Sales.SalesOrderDetail AS SOD
ON SODH.SalesOrderID = SOD.SalesOrderID
AND SODH.SalesOrderDetailID = SOD.SalesOrderDetailID
WHEN NOT MATCHED BY TARGET THEN
INSERT (LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, Cancelled)
VALUES(LineTotal, SalesOrderID, SalesOrderDetailID, CarrierTrackingNumber, OrderQty
, ProductID, SpecialOfferID, UnitPrice, UnitPriceDiscount
, rowguid, ModifiedDate, DEFAULT)
WHEN NOT MATCHED BY SOURCE THEN
UPDATE SET SOHD.Cancelled = 'True'
OUTPUT $action , inserted.* ;	


Please help me to overcome this issue and let me know where can I download that database too.


Thanking you

happy Coding


How to extract a schema from a sql server database

  

Hi,

  I need to extract or get the schema from tables in my databse and what is the best way to do it. Is there any third party tool to do it??

 

Any idea will be appreciated..

Thanks

Karen


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