.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 hide SQL Server password from user in an Windows Forms Application?

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

Using - VS 2005, SQL Server 2005 Express, Windows Forms Application

Problem-

I am unable to find a way that hides the password to connect to database in case of a Windws Forms Application.

- app.config is accessible to the user, so connection strings an be read.

- app.config can't be encrypted as in case of ASP.NET applications

- hardcoding the password in the application in connectionstring still makes it possible to be discovered by a user


Vibhor Agarwal


View Complete Post


More Related Resource Links

web application asking server user name password

  

Dear friends,

                   I have been using a asp.net2005 application for one year. Every thing was working fine . Last night i just changed a picture in image folder. Now my application is working fine on server but when i am runing this application on client side , it is asking server's user name and password as soon as  newly added image is going to upload on client.


Plz help  ASAP.

Thanks is advance

vickyjha


SQL Server 2005 random login failures for windows forms application

  

One of our VS .NET 2008 windows forms applications runs from multiple client machines. The application randomly has login failures from random machines and from random places in the code. The login works almost every time but about once every fifteen minutes an error shows up in SQL Server error logs from a random user. We are running a clustered SQL Server 2005 system and the database is in 2005 (90) mode.

The following error appears in the SQL Server error logs:

Login failed for 'App_Login'. [CLIENT: XXX.XXX.X.XXX] Error: 18456, Severity: 14, State: 16.

The following error is what the client sees:

Application Architecture in Windows Forms 2.0

  
Applications have special support in Windows Forms. For starters, you can manage and tailor your application's lifetime, and, when the work flow is disrupted by an unhandled exception, you can choose from several methods of response. Then, there are several application models that you can employ, including Single Document Interface (SDI) and Multiple Document Interface (MDI) applications, each of which can support either multiple-instance or single-instance mode, the former the VS05 default and the latter requiring special consideration. All applications, however, can discover and use a wide variety of information about the system and environment they execute in.

Application Architecture in Windows Forms 2.0-Single-MDI Applications

  
Consider an MDI application like Microsoft Excel; files opened from the file system (by double-clicking) are all opened as separate child windows within the parent Excel window.7 For the first instance of an MDI application to open a new child window to display the file that was passed to the second instance of the application, the second instance must be able to communicate with the initial instance.

No ASPNET User in Windows Server 2008?

  

I have been looking everywhere online regarding this, but have not found a clear answer.

 

I have an ASP.Net app running on Windows Server 2008, it's basically a reporting app using Crystal Reports. I have encountered a roadblock in regards to rendering some pages. When I run the app in Visual Studio(on the same 2008 machine) everything works perfectly. Yet when I publish it and run it live the reports will not display correctly, I get a message saying Failed to render page.

 

I looked this error up in the Crystal Reports website and the fixes they have there refer to giving the windows "aspnet" user full access rights to certain folders on the machine. I would be happy to do this, however there is no aspnet user in Windows Server 2008.

 

I installed the server and set its role to be Web Server. I also checked all the options regarding ASP.Net and IIS 6 compatibility. Yet there is no ASPNET username anywhere.

 

Did I set the server up wrong? or do I have to do something within ASP.Net to  create this user and then give it rights? 


Reporting: Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services

  

SQL Server 2000 Reporting Services--a server-based reporting platform built on the .NET Framework and integrated with SQL Server 2000--lets you easily add reporting from diverse data sources. Using Visual Studio and Reporting Services you can integrate reports from any data source that has an OLE DB, ODBC, or ADO.NET provider into your Web applications. This article explains how it's done.

John C. Hancock

MSDN Magazine August 2004


Windows Forms: Give Your .NET-based Application a Fast and Responsive UI with Multiple Threads

  

If your application performs any non-UI processing on the thread that controls the user interface, it may make the app seem slow and sluggish, frustrating users. But writing multithreaded apps for Windows has long been restricted to C++ developers. Now with the .NET Framework, you can take advantage of multiple threads in C# to control the flow of instructions in your programs and isolate the UI thread for a fast and snappy user interface. This article shows you how. Also, it discusses the pitfalls of multiple threads and presents a framework for safe concurrent thread execution.

Ian Griffiths

MSDN Magazine February 2003


Windows Forms: Developing Compelling User Controls that Target Forms in the .NET Framework

  

In the beginning, writing controls meant dealing with Windows messages. Then came Visual Basic controls, which introduced methods, properties, and events. Later, ActiveX controls, which ran atop COM, became popular. While each innovation in control writing brought more flexibility, nothing has matched the versatility of the new .NET Windows Forms controls and Web Forms controls. This article, the first of a two-part series, introduces the reader to Windows Forms, beginning with their inheritance from one of the .NET CLR base classes, which makes control creation much faster than before. Control programming is illustrated through the development of a login control. The equally flexible Web Forms controls will be covered in Part 2.

David S. Platt

MSDN Magazine April 2002


Forms based users being prompted for windows authentication login for My Sites photos in user lists

  
Here's an issue I didn't see coming for our forms based authentication users. 

We have a web application extended to an external url to handle forms based authentication for users outside of our domain. Our setup looks like this...

Internal Users/Windows Authentication - moss.domain.com
External Users/Forms Based - mossext.domain.com
My Site for Internal Users - mysites.domain.com

When our forms based users are accessing user lists, or discussion pages that display user pictures, they are getting a windows authentication login for our internal users (mysites.domain.com) who have populated their my site with personal photo.

How do we fix this? 

Automatic expiration of forms authentication when user closes the browser windows without signing ou

  
Dear all, can u tell me how to automatically sign out a user if he/she closes the browser window without signing out. I'm using Forms Authentication.   Thanks 

how do i create a windows form application login for to validate username and password from sql serv

  
 I would like to know how I can create a login form for my windows form application. The login form must be linked to a SQL server 2005 express edition database (in which the username and passwords are stored). The login form must validate the user using the database and allow them to access the program. 

Connection to Exchange Server of .NET 1.1 Framework application on Windows 2008 64-bit

  
I am running Visual Studio 2003 .NET Framework 1.1 application on Windows 2008 64-bit machine. There is only one problem - connection to Exchange Server. The same application is running fine on Windows 7 64-bit machine (not server). I tried to use the same Interop.MAPI.dll I used for Windows 7, but it doesn't work for Windows 2008.   Please help.  

Sockets in Windows Forms, Server Hanging

  
First off, I'm relatively new to C# but not programming.  I've written multiple connection apps in VB6 off and on for the last 8 years.  The problem with my server is that it hangs when ChatServer() is called and nothing appears in the rich text box.  I have no idea how to correct this or get it to start listening for connections, accept them, then retrieve data.  Pretty much learning as I go.  Here's the server so far: Any help would be greatly appreciated.   Edit:  I rewrote the server code using Winsock Control 6.0.  I know it's outdated but it's what I know and fairly well.  However, I noticed they did away with control array's!  What in the world?  Instead of setting a control's index property to 0, you now have to create references, objects, etc. etc.  SO much code for something so simple.  Anyway.  The problem now lies with the following code:   namespace Simple_Chat { public partial class frmServer : Form { int maxPlayers = 100; int index; public frmServer() { InitializeComponent(); } public void addToChat(string p, string fntcolor) { switch(fntcolor) { case "red": rtbMain.SelectionColor = Color.Red; rtbMain.SelectedText = p; break; case "blue": rtbMain.Selecti

Using Windows Authentication for connecting sql server from web application using froms authenticati

  
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. 

Sockets in Windows Forms, Server Hanging

  
First off, I'm relatively new to C# but not programming.  I've written multiple connection apps in VB6 off and on for the last 8 years.  The problem with my server is that it hangs when ChatServer() is called and nothing appears in the rich text box.  I have no idea how to correct this or get it to start listening for connections, accept them, then retrieve data.  Pretty much learning as I go.  Here's the server so far: Any help would be greatly appreciated.   Edit:  I rewrote the server code using Winsock Control 6.0.  I know it's outdated but it's what I know and fairly well.  However, I noticed they did away with control array's!  What in the world?  Instead of setting a control's index property to 0, you now have to create references, objects, etc. etc.  SO much code for something so simple.  Anyway.  The problem now lies with the following code:   namespace Simple_Chat { public partial class frmServer : Form { int maxPlayers = 100; int index; public frmServer() { InitializeComponent(); } public void addToChat(string p, string fntcolor) { switch(fntcolor) { case "red": rtbMain.SelectionColor = Color.Red; rtbMain.SelectedText = p; break; case "blue": rtbMain.Selecti

LDAP - directory entry issue with out user and password using impersonate and windows authentication

  
Hi All I am using the below code to fetch the user information from LDAP             DirectoryEntry entry = new DirectoryEntry("LDAP://DEV");             DirectorySearcher searcher =  new DirectorySearcher(entry);             SearchResult result;             searcher.Filter = "samaccountname=testuser";             result = searcher.FindOne(); here i am using windows authentication always and along with that when i enable the impersonate = true ,  the code fails at "result = searcher.FindOne();" with message "object reference not set to instance of an object "  also with the same code if i give the username and password along with the impersonate tag >> it works  or if i am using the user and password along with the DirectoryEntry  object then also it will work  but it fails with same user that i gave in impersonate tag / directory entry object with windows authentication enabled  and the  user logged to the application and no username and password tag in directory entry / impersonate tag  Interesting thing is that  in our development server ,  i am able to execute the same code with out user name p

Oulook.exe hangs when Domain User launches application through Interop windows 2003 sp2

  
Hello,I have a problem using Interop.Outlook on a win2k3 sp2 server. For windows 2003 version prior to sp1 i could use a specific identity for application pool and i had no problems launching outlook.User was authenticated and delegated correclty. With sp2 the Outlook.exe process is launched by the domain user specified as identity (also visible on Task Manager Processes) but no exception or time out is ever thrown.  The only way that i can make this to work is when i set impersonate=true in web config (without setting userName and password as this would have exactly the same affect with the application pool identity).Are there any permissions that i can set to overcome this?Help would be greatly appreciated. Normal 0 false false false EL X-NONE X-NONE Appreciate
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