aspnet_regsql and using SQL server authentication

I have a requirement I should connect to MS SQL server under IIS Application pool account from ASP.NET application where Windows Authentication is enabled. I cannot use user name and password in connection string. ASP.NET application should use Entity Framework 4.0 to work with data. Any ideas how to do it?    

I reviewed lots of postings, still could not find an answer. If I choose Windows authentication: - with TCP/IP and "Dynamically determine port" checked, I get the following error "The user is not associated with a trusted SQL Server connection; - with Named Pipes, Server Name & Pipe Name as "VSAXAONG", I get two errors, one after the other on the same pop-up:       Connection failed  SQL State 01000  SQL Server Error 1385 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] ConnectionOpen (Connect()).       Connection failed  SQL State 08001 SQL Server Error 17 [Microsoft] [ODBC SQL Server Driver] [Named Pipes] SQL Server does not exist or access denied. If I choose SQL Server authentication and fill in the password - the ODBC connection works fine. I have to say that I created two different logins on the server, one for Windows authentication, and one for SQL Server authentication - both for the same Windows user name. I would appreciate any help I can get on this.  Thank you all in advance.

Hi Experts, I have one web application which is configured to be use froms authentication. But, I don't want to use SQL Authentication to connect to SQL server, I want to use windows authentication. Can somebody plase give me detailed setps for how to implement this? Thanks for your help in advance. -Chintak. 

Hi,I have a SharePoint site collection which requires client certificates. On the server I have configured Reporting Services in integration mode.I can call reports on other site collections which don't require client certificates but not on the site which does. On the site which requires client certificates the pages fail with the following error message:'An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> The request failed with HTTP status 403: forbidden'The error message indicates that SharePoint doesn't call the web service with a client certificate. Does anyone know how I can configure SharePoint to use a client certificate?Any help is greatly appreciated.Adam

Situation:IIS 6 installed on Vista (Virtual PC) not member of domain, Visual studio 2008 based website. Active Directory Membership configured in web.config.Trust level set to Full. Using Login control to authenticate.<membership defaultProvider="DomainLoginMembershipProvider"> <providers> <add name="DomainLoginMembershipProvider" type="System.Web.Security.ActiveDirectoryMembershipProvider, System.Web, Version=2.0.0.0,Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="ADConnectionString" connectionUsername="test.bit.com\administrator" connectionPassword="myadminpassword"/> </providers><membership>Connection string is configured as following<connectionStrings> <add name="ADConnectionString" connectionString="LDAP://test.bit.com/CN=Users,DC=test,DC=bit,DC=com"/></connectionStringsEvery time after login it will state "Unable to establish a secure connnction with server"Thanks in advance for your time and support!

Dear All,   I have a client/server socket application that enables file transfer between the client and the server, however, i want the client to be authenticated with the server before a file is transferred. the client should prompt for a user name and password which is used for authentication with the server. The server should be configured with user name/password pairs so that it is able to authenticate client. I have been searching for related work for quite sometime now but haven't come across anything close to this yet. Please i want any1 to help me settle this issues, i would appreciate if i am directed to an article or any other resources that is helpful, or pasting sample code/ uploading sample application would be of greatest help..Thank you all in advance. Regards, Mbgreat.

while installing i only gave the windows authentication.now i want to add the SQL server authentication .how to add that to the existing server.

Hi I want to manage my servers from a central location and have the ability to manage my packges too.  Unfortunatley my servers are across domains which means I have to use SQL Server Login, which isn't a bad thing.  However for some bizzare reason I can't connect to Integration Services using this method, only windows authentication which is a complete pain in the butt from a management stand point as I have to copy packages to various servers rather than add them from a central point. Does anyone know if this bug/feature or what ever Microsoft is calling it will be fixed or know of any workarounds.  Thanks    

Is there a system table or view that contains the server authentication mode?  I would like to keep a history of changes to a SQL Server instance and this is one property I would like to include in the history.  I would like to retrieve the information from a table or view or function programmatically.

Hello, This is my first time using MSDN.  I have a client and server application which use SSLStream to communicate over port 80.  Both the client and the server are running as Windows Services.  Everything works in my test environment (my development computer, under the OS Windows 7 Ultimate). My problem is that when I go to deploy the client and server application to their deployment environments (the server being on Windows Server 2008, and the client being on Windows Server 2003) it does not work, and I get the error: "The client and server cannot communicate, because they do not possess a common algorithm" Please note that I have installed the same certificate using the makecert commands (listed in the "Firstly" section below) In addition, when I gave up on trying to get the client to authenticate under the Windows Server 2003 computer, I moved it to a completely new/different Windows Server 2008 computer.. and then got a new error along the lines of "credentials supplied to package not recognized." If you have any experience with this issue, please advise.  I have been working on this for the past 3 days and have burnt up over 20 hours of development time. Please remember, the problem keeps happening when the Server and Client attempt to authenticate. Firstly, I used the following commands via makece

Hi everyone, I am not sure if this is the correct forum - apologies in advance - I could not identify where it should go! I have an ASP.NET Web Application that uses Forms Authentication using System.Web.Security.ActiveDirectoryMembershipProvider for signing on using Windows credentials.  This works nicely and is solid. The problem I have is connecting to SQL Server.  I need to be able to connect to SQL Server using Windows Authentication (trusted_connection=yes or Integrated Security=SSPI).  This is critical so I can record the user that created/last modified specific records and also to collect "Task-based" records that are relevant to the currently authenticated user. I have tried Google and a tonne of variations of web.config entries, using Win API to impersonate etc...  The only way that I could make it happen was to:- 1. Use the web.config entry:   (please entry at the bottom of the post.  For some reason it won't go into the right spot in this post!) 2. Log on specifically as the user specified in the above web.config entry.  If I log on as anyone else (ie Authenticate as anyone else), then SQL server simply gets the ASPNET service account as the Windows user. I have laboured over this for hours upon hours.  I really would appreciate some assistance. Thanks in Advance, Joe     "<identity

Hi We have a SQL server (x64 standard) that is running with sharepoint on it.  Currently we have some custom s/w that need SQL server authentication also but our server is set to "window authentication mode" only.  Could someone please tell me if we can change the authentication method from "windows authentication mode" to "SQL server and Windows authentication mode" while sql is running.  Will they ask us to re-boot or it will take effect immediately?  thanks, Ted.  

Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

I have created a WCF Service (VS2008), an application pool account which has the access to the SQL Server(in remote machine). Configured the App Pool account to the Virtual Directory in IIS (Version 6.0). Once I browse through the SVC file, I can see the WSDL file. I have the "Windows Authentication" and the 'Anonymous authentication" Checked in the Properties for the Virtual Directory. But when I access service through Client, I get "The HTTP request is unauthorized with client authentication scheme 'Anonymous'. The authentication header received from the server was 'Negotiate,NTLM'.". Binding that is being used is HTTPBinding. I have set the Identity Impersonate to True as well. Bottom line is - I need to use the App Pool account to connect to the SQL Server. Could some one please help me in this?  

I installed SQL Server 2008 Developer Edition (10.0.1600.22.080709-1414) on a Windows Vista 32-bit development machine with Windows Authentication Mode only (no SQL Server Authentication).   Since this is a development machine, I saw no need for Mixed Mode when I did the install.  The SQL Server Management Studio allows me to login to Analysis Services, Integration Services, Reporting Services, BUT NOT the Database Engine!Windows Authentication for the Database Engine gives the following error: EventID: 18456Login failed for user MYDOMAIN\MYLOGIN'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: <local machine>]The 'fix' I have found online is to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine.  Unfortunately, I can't since I didn't install SQL Server Authentication mode (only Windows Authentication Mode).  It appears my only recourse is to uninstall, then reinstall in Mixed mode, then to login as SA in SQL Server Authentication mode & add MYDOMAIN\MYLOGIN as a administrator for the Database Engine. Before I do so, does anyone know of a better approach?Scott D Duncan

We would like to expose SSRS 2008 R2 ReportServer to anonymous users and ReportManager to authenticated users via Forms Based Authentication. I tested a Security Extension in SSRS 2008 and it worked well. When I tried to deploy the same solution to SSRS 2008 R2, I am unable to browse to the reportserver and reportmanager screens. Is there a documented way to authenticate users in FBA when they want to access ReportManager and expose reports on the RepotsServer to anonymous users (or even authenticated users and pass a cookie to the reportserver). I do not want to use a windows user account if that is at all possible?   I followed the following to get it to work in SSRS 2008 : http://technet.microsoft.com/en-za/library/cc281383(en-us).aspx http://technet.microsoft.com/en-za/library/ms155029(en-us).aspx And I worked from the Microsoft Authentication Example project for SSRS. Regards, Pieter Theron    

I want to use an external server to authenticate my users and retrive encryption keys and place it in a landing page. Is it possible I tried with Pluggable SSO but i coudn't interact with the server suggest me plz