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


Post New Web Links

C# connect SQL server 2008 window authentication on workgroup

Posted By:      Posted Date: September 26, 2010    Points: 0   Category :Sql Server
 

We have an application winform C# that connects to sql server 2008 with window authentication impersonation.
We need window authentication because of filestream requirement (we did not find other solution).

The application works fine in domain environnement. Our msi create same user on each computer and we use it to access to remote database.

But a lot of our customer are littre company (1 to 10 employees), they are in workgroup configuration, it is impossible to migrate them on domain environment.

We tried to impersonate but it doesn't works in workgroups :

public void Impersonate(string userName, string domainName, string password, LogonType logonType, LogonProvider logonProvider)
  {
   UndoImpersonation();
 
   IntPtr logonToken = IntPtr.Zero;
   IntPtr logonTokenDuplicate = IntPtr.Zero;
   try
   {
	// revert to the application pool identity, saving the identity of the current requestor
	_wic = WindowsIdentity.Impersonate(IntPtr.Zero);
 
	// do logon & impersonate
	if (Win32NativeMethods.LogonUser(userName,
		domainName,
		password,
		(int)logonType,
		(int)logonProvider,
		ref logonToken) != 0)
	{
	 if (Win32NativeMethods.DuplicateToken(logonToken, (int)ImpersonationLevel.SecurityImpersonation, ref logonTokenDuplicate) != 0)
	 {
	  var wi = new WindowsIdentity(logonTokenDuplicate);
	  wi.


View Complete Post


More Related Resource Links

How to connect to local instance of SQL Server 2008 Management Studio Express ?

  

I just installed SQL Server 2008 Management studio Express on my Vista machine.

i tried connecting to local machine using :

.\sqlexpress, (local)\sqlexpress, or .\SQLExpress, MyPCNAME\SQLExpress

nothing is working, getting this error:

-----------------------------
Cannot connect to PC-NAME\SQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------


Indexing services on window server 2008 is not working with .net

  
Hi, I am useing Microsoft indexing services in windows 2008 64 bit .I am getting error like "Exception from HRESULT: 0xC0000005" while i am createing  new catlog from .net 2.0.I am using  "ciodm.dll" for adding new catlog. i am using this code for create new catelog.   Dim Admin As New CIODMLib.AdminIndexServer   Admin.AddCatalog(varContractNo, txtCatelog.Text + "\" + varContractNo) Admin.Stop() Admin.Start() AddScope(txtDocFolderPath.Text, txtSite.Text, txtCatelogname.Text)   Please help me anybody have fixed this issue on window server 2008 64 bit.  

Can not connect to user instance of SQL Server 2008 Express with Advance Services in Visual Studio 2

  
I used SQL Server 2008 Express with Advanced Services (not SQL Server 2008 Express) in Visual Studio 2010 because it is the fast and easy way to developed and managed data-driven applications with powerful built-in reporting and full-text search functionality. I received Sql Server 2008 Service Pack 1 with Windows Update. It's ok if I connect to instance of SQL Server 2008 Express with Advance Services (with SP1) through SQL Server Management, but if I try to attach a database in Server Explorer (Visual Studio 2010), I get the following error: "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed." I'm stuck at this point. Is there a fix or a workaround? I've already tried deleting the 'C:\Users\Administrtor\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS' directory as mentioned in other posts, with no luck. The error.log at 'C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS\error.log' has the following relevant entries: 2010-09-01 14:44:10.47 Server      Error: 17156, Severity: 16, State: 1. 2010-09-01 14:44:10.47 Server      initeventlog: Could not initiate the EventLog Service for the key '3677F6D3-17C7-4F', last error code is 2. 2010-09-01 14:44:10.47 Server &

can't connect via SQL authentication - sql express 2008

  
Hello, I just installed SQL Express 2008, and for some reason I've 2 instances. one SQLEXPRESS and one MSSQLERVER. when i try to connect to 127.0.0.1 via SQL authentication, it works. when i try to connect to 127.0.0.1\SQLEXPRESS via SQL authentication, it doesn't work, but it works for windows authentication. how can i fix it? i want to connect to 127.0.0.1\SQLEXPRESS. Thanks, Gidi.

Unable to connect SQL Server 2008

  
Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

Connect to SQL Server 2008 Express

  
Hi Guys, I have just started a personal project for our Corporate Desktop environment to actively track our Hardware and Software Inventory.  My plan is this for starters:   1 Computer using VBScript and WMI to gather the data, store the data into SQL Server 2008 Express, and present the data using ASP.NET or Javascript. The VBScript will get a list of computers from AD under specified OUs and will run on a scheduled task.   This deployment will initially be on 1 desktop computer for now.  How do I connect to SQL Server 2008 locally using OLEDB from my vbscript?  Will this require a username/password even though it is a local connection?  If it does require a password, do you know a way to prevent the password from being stored as clear text.  Does Windows Integrated configuration on the SQL Server 2008 Express allow a passthrough of credentials from the Scheduled Task so that the password is not required from the script?  I would like it to be as secure as possible since we have financial services users and we would be under the scope of an audit if ever it was needed or requested.  Thanks guys.  :-)

Cannot Connect SQLServer 2008 with the provider SQLNCLI... Is there any SQL Server 2008 patch to sup

  
We have a program which developed under SQL Server 2005. In the program the provider of the connect string is hard coded as "SQLNCLI". It's ok running on SQL Server 2005. Now, for some reasons, this program must run under SQL Server 2008 (x64). But our program cannot access the SQL Server. We check the reason, found that, in SQL Server 2008, SQLNCLI is changed to SQLNCLI10, this caused our program cannot run. So I want to ask, is there any patch of SQL2008, so that the legacy program can normal access SQLserver with SQLNCLI WITHOUT rebuild a new version?  

Can't connect to SQL Server 2008 Reporting Services

  
When attempting to connect to SQL Server 2008 (evaluation) on Windows XP SP3, using the following url, http://servername:8080/ReportServer I receive a popup dialog box asking me for a user name and password to connect to the server.  When I enter the domain\user and password that I think it should be, it pops up two more times and then displays a blank internet explorer web page.  It is a fresh install and I believe I have everything running correctly.   Any input or guidance would be extremely appreciated.   Thank you in advance.

How to connect visual web developer 2008 express edition to SQL server 2008 ??

  
i know its a basic question guys! please help me . i have created a login.aspx file in visual web developer .now i want to connect the username and password details to SQL database ... How do i do it .....I can see some grt genius out there, i am sure some one is kind enough to help me with this question !!! thank you .....................................

SQL Server 2008 Windows Authentication Mode fails for Database Engine, error 18456

  
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

SQL Server SSRS 2008 R2 Authentication

  
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    

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

  
I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Cannont connect to New Installation of SQL SERVER 2008 from New Vista Ultimate machine(s)

  
I have a new SQL Server 2008 Development edition installation on a Newly setup Server running Windows Server 2008 Enterprise edition.  The server is mainly a file server and is not setup as a domain controller.  Since my test environment is fairly basic (server and two Vista Ultimate machines) I thought the connection through data sources on the client machines would be straight forward.  But it isn't working.  I can see the server, ping the server, etc. but when I try and connect the client through a system DNS it will not connect using SQL Server authentication using a loginId.  (since it isn't on a domain, I can't use Windows NT Authentication).   The error is SQL Error 10060 and SQL Error 17.  (connection failed and SQL Server does not exist or access denied)  Any thoughts or suggestions are appreciated. WB

Getting a popup Window during the Silent uninstallation of SQL Server 2008 Dev R2

  
Hi, When i try to uninstall the SQL Server 2008 R2 silently, it openup a window with the options that Add, Repair or Remove. Is there any way to Hide this Window? The command i used for uninstallation is "%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setupARP.exe" /CONFIGURATIONFILE="%~DP0x86\UnInstall.ini" The content of the Uninstall.ini file is ;SQLSERVER2008R2 Configuration File [SQLSERVER2008] INSTANCENAME="MSSQLSERVER" ACTION="UNINSTALL" FEATURES=SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS HELP="False" INDICATEPROGRESS="False" QUIET="True" QUIETSIMPLE="False" X86="True" I have tried with the following command also "%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2\x86\setupARP.exe" /ACTION="UNINSTALL" /FEATURES=SQLENGINE,REPLICATION,FULLTEXT,AS,RS,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,OCS /INSTANCENAME="MSSQLSERVER" /QUIETSIMPLE  

Can't Connect to Sql server studio 2008

  
Hello,   I installed the Sql Server Management Studio 2008 and made a connection but last week when i tried to connect got the error below............   A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)   I haven't changed anything.  I was also unsuccessful in starting the sql agent in sql configuration.  Thanks,        

SOS: Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But networ

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect! System:   Windows Server 2008. Error 18456

Cannot connect to SQL Server 2005 locally by Windows Authentication, but network connection is succe

  
Cannot connect to SQL Server 2005 locally by Windows Authentication DOMAIN \ myname. But network connection is successful.   But SQL Server Logins contain   BUILTIN \ Administrators, and                                                    BUILTIN \  Administrators contain DOMAIN \ Domain Admins, and                                                    DOMAIN \ Domain Admins contain DOMAIN \ myname.   Creating SQL Server Login with DOMAIN \ myname entail successful local connection.   Removing SQL Server Login with DOMAIN \ myname and creating SQL Server Login with DOMAIN \ Domain Admins do NOT entail successful connection. Cannot connect!                                     &
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