Security :: Allow Clients To Login To Website And Connect To Specific Server Based On Login
Jul 5, 2010
We have created a windows application which is distributed amongst our clients. The application uses SQL Server 2008 as the back end and each client uses their own database on their own server. The databases are all exactly the same but each clients data is specific only to them.
We would like to offer our clients the ability to log-in to our website which would then login to their own database so that when they are out in the field they can perform similar tasks to what they can do with the windows app.Each of the clients databases has a user table containing their login details, permissions etc.
Our server is running on IIS and has SQL Server 2008 installed but it only contains our data and nothing of the clients.How should we go about this?
What I mean is do we need to make each client have an additional login to our main server which would then hold each clients individual connection strings etc which would then be used to connect to there specific database and then they would need to login again?? Seems like a nightmare for the user.
View 13 Replies
Similar Messages:
Jan 21, 2010
I've set up a system with forms based authentication and using the asp:Login control. When I put in an invalid password I get the approriate invalid password message. However when I put in a valid password, it does nothing...just returns to the login page again. I'm triple checked the login info. There is no error message, and the invalid attempts counter doesn't increment. When I put a break point in the Login_LoggedIn event of the Login form, it hits it, but User.Identity.IsAuthenticated is false. I'm not 100% sure it should be true at this point, as I'm pretty new to .NET but it seems kind of odd.
My user database is stored in a sqlserver 2005 db that already existed. I've added a new connection for it.In the authorization I have
<authorization>deny
users="?"/><authorization>
View 2 Replies
Nov 1, 2010
I need to restrict access to my website by physical PC. When a user signs up I want to be able to restrict access to one machine for that account so it cannot be shared round, if, for example, somebody else in the same office wanted to access the system on their PC they would need a seperate sign in.
I have done some investigation and I "think" the only way is installing an ActiveX component (which isn't an issue that is restricts to IE only) and then read the users MAC address. Am I trying to over complicate things or is that the only way? I realise that MACS can be spoofed but this is not much of an issue.
View 4 Replies
Mar 24, 2011
I am doing a simple secured site using the login control. I would like users to be redirected to their dashboard page once they log in, but after that if they choose to browse I do NOT want them redirected based on their login status. I am using the generic template provided in VWD with the basic login setup in the template including the tabbed ASP menu control - nothing fancy, nothing custom. This is intended to be something very simple and quick. Here is the code I am using for the page load...
[Code]....
So if I do this code WITHOUT the "IsPostBack", logged in users are always redirected to their dashboard and cannot see the hompage. However with that IsPostBack test, the redirect after initial login doesn't work.
I know this is extremely basic and simple, but I am restarting with this stuff after a year away, and I need a nudge.
View 4 Replies
Apr 16, 2010
I am using Membership with Login control.
It worked just fine untill this week, but now it fails to login.
the odd think is that it do login from localhost, but when trying to login through the profuction site it fails to login. this is happens to all users.
View 5 Replies
Feb 18, 2011
After deploying our web application, one of the user was not able to login to the application. After checking, we could realize that his system date was worng, It was a greater than current date. If the system data was less than the current date we can still login. We are using asp.net membership
View 2 Replies
Feb 3, 2010
I have just turned on all membership infrastructure, maked an "Administrator" and successfully logined using standard LoginForm control.But when I uploaded my website on hosting server, I couldn't login anymore.I have MachineKey in web.config. Perhaps I need to set something on server (it is my VDS).
View 5 Replies
Apr 13, 2010
I am a newbie to asp.net and have recently been building a web... I have a login control on the main page which when logged in verifys the user and redirects them to the home page... I published this to the server previously and it worked. Today when I tried logging into my system however I got the following error message:-
"Your login attempt was not successful. Please try again."
The accounts did work before but since I have uploaded a newer version of my program onto the server the above message is displayed. I have been on many websites and read previous forums with suggesstions to add <roles> in the web.config file however the login control worked before and I have not changed anything on the site apart from a different page that doesnt affect the login.
Few points to make... the login control is using the asp.net configuration pre built tables it generates for you, I have created the users and roles inside of asp.net configuration so it is not a custom membership... I am at a complete loss as how to get my login control to work having tried to insert roles into the webconfig file.
View 3 Replies
Jan 7, 2011
I have a online game (written in ASP) which i have finally decided to convert to ASP.NET. However i cannot seem to link the login ID's of users to their specific details in the database. I.E when Joe Bloggs logs in, he will be shown the team information for just his club, not every club. in ASP I use code similar to this below
[Code]....
im not convinced that is the right syntax to be using, but when i execute the code in Query Builder it is showing me the correct data (that i expect to see). So im wondering if there is something else im missing? Is there something extra that i need to be adding in Web.Config file or elsewhere?
View 30 Replies
Apr 12, 2010
After reading a book I brought on ASP.net I fould the login controls to be very nice.I have set it up in my application so that customers can login using the standaard login controls and things were going smooth.But in my schema for my application I also have a table for customers (firstName, LastName, DOB, etc).And of course the customersID is used as a foreign key to tables such as Orders, Addresses (Home, Work, Postal).
The thing is how to i associate an asp.net login to a customer name in my table so that the CustomerID can be used through the application by knowing who is logged in.
View 7 Replies
Jan 28, 2011
Actually m developing a simple website, where I am using ASP.Net Login control and now I want to connect it the database where I am accepting somewhat same kinda information one and one of my field specifies the type of the role that particular person would be playing. So, how would i connect the authenticate through my database's table?
View 7 Replies
Mar 26, 2010
which i added one sitemap in whcih i added all the pages n i want to retrive that sitemap in masterpage based on login in whcih suppose admin hs login then display only admin pages with sitemap n if normal user hs login then it ll display only normal user pages with sitemap. here i didn't use login control but i create login page manually.
View 1 Replies
Dec 22, 2010
When I browse some of my websites a login window has appeared to connect to site. This happens to websites in random and disappeares the login window Automatically.
why this happens and how can i repair it?
it it because of any problem in iis osf server? the version of iis is 6.
View 6 Replies
Jan 24, 2011
At work, I'm currently doing an ASP.NET project, where I have to connect an MS Access file to ASP.NET.
This has been done successfully. Next, I had to create a login page, this has been succeeded as well.
Now I have make sure everyone sees unique queries from the database. Example: There are 12 queries in the database; one person has to see another query than the other person can see. But there are some products, which everyone has to see as well.
How do I do that without creating server errours (I get them a lot with one little change).
View 4 Replies
Aug 20, 2010
I recently upgraded a WinXP machine that had been running VWD 2005 to a Win7 machine using VS 2010. The application targets .Net 2.0, but since the upgrade, I cannot get VS to connect to my database and this is the first time I've tried working on the site since upgrading, so no changes have been made to any code (with the exception of trying to change my connection string so I can connect). The specific error is:Cannot open database requested in login 'dbName'. Login fails. Login failed for user 'SqlLogin'The sql database is on another machine and I was assigned the login/password; I know the login works because I can connect to it with SQL Server Management Studio. Having read several posts and still having trouble, I tried to do a couple things. First I modified my web.config connection string, which looks like this:
[Code]....
When that did not work, I deleted the connection string from the web config and dragged a sqldatasource control onto a page and tried to use the connection string builder while in design mode. Then the error I got was:The database db1 does not exist or you do not have permission to see it. Would you like to attempt to create it?I'm not sure I understand that there is a problem at all, except that I upgraded the OS/IDE. I'm using IIS 7.5 on my local machine to serve the development site while connecting to the development sql server on the other machine. Since I can't use the IIS aspnet account on the remote sql server and my assigned login is verfied working through sql management studio, what else can I do to get my developement site working again?
View 2 Replies
Jan 26, 2010
i am using asp.net membership. when users arrive at my sight they can enter user name and password.
I then want to redirect them to a page called "MyAccountPage.aspx" which is unique to them. could someone post the c sharp code that I can use to capture the Unique Id of the user is it best to then pass this as a parameter to a control on the aspx page that displays data for that user. am I correct in thinking that I need a UserId column in my data table as well.
View 1 Replies
Jun 23, 2010
I need to secure access to all pages in a .NET webapp - EXCEPT requests from:
local network (the network IIS is running on) IPs listed/netmasks listed in a database all other requesets should be redirected to a login form I was thinking in the direction of a HttpModule - but never wrote one.
View 4 Replies
Dec 24, 2010
I've a Gmail account, assume that me@gmail.com. Now I want to login (as admin) in my website through this account. I know I can use OpenID etc. for that purpose but I want to limit it for just me only. Can I do this? I don't let anyone else to know which service I used to login and what is my address and etc. (Note: My website contains just one and only one login form, for just me, only!)
View 1 Replies
May 28, 2010
how i can validate Specific user ON My Login Page
whether the username exist or not
if its exist it should match with the right password and right username
Language-ASP.NET C@
BACKEND-SQLSERVER 2005
View 6 Replies
Jan 14, 2010
I set the impersonation to true in web config. First time accessing the page, it implements the impersonation to access Sql sERVer. However the second request and so on to page, it does not implement impersonation, rather it uses NT AUTHORITYIUSR user account.
I need to impersonate based on the user login all the time.. How can I achieve this?
View 13 Replies
Jan 8, 2010
I started a new Sql Server 2008 with mixed authentication Windows and SQL SERVER AUTh... I created a new login account and use it to directly connect in SQL server managment studio BUT... when i create in VS2008 the connectionstring... everytime i try to open the DB connection i take an exception to the login... some screenshots show all the process ;)
LOGIN: admintvmaismais
PASSWORD: ex
Working to connect in SQL SERVER MANAGEMENT...
LOGIN STATUS ON SQL SERVER MANAGEMENTE
Now in VS2008 Web-Config I declare the connectionstring:
<connectionStrings>
<add name="SqlConnectionString" connectionString="Server=JP;Database=tvmaismais;User ID=admintvmaismais;Password=ex;" providerName="System.Data.SqlClient" />
</connectionStrings>
and When i try to open a connection like this:
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SqlConnectionString"].ConnectionString);
try
{
conn.Open();
...
}
catch (Exception e)
{
retorno = e.Message.ToString();
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
I get this exception: Cannot open database "tvmaismais" requested by the login. The login failed. Login failed for user 'admintvmaismais'. What am I missing? What do i need to do, to get this login to work?
View 4 Replies
Oct 12, 2010
how to make login control allow users to login by either username or email address
View 1 Replies
Aug 13, 2010
i m currently creating an article module, and i want if user wana comment on to the any particular artical, than he should login any of his mail id like gmail, yahoo hotmail etc and than post his or her comment and after than comment should go into the DB.
View 3 Replies
Jan 11, 2011
i doing on a 3 tier project a that required a login page, Im not sure how the flow go for the 3 tier...This is my BLL
[Code]....
This is my DAL
[Code]....
And lastly here is the aspx page
[Code]....
When i try to insert my NRIC and password, it's like not passing through the statement, it just say login sucessfully eventhough i put the wrong NRIC/Password/Not valid..
View 3 Replies
Sep 27, 2010
I have two application (one of this is mojo portal): [URL] for some users when they login into "app" then the login in "mojo" doesn't work and viceversa. I've set the machinekey into web.config file. When the users remove all cookies and session data the login works again. The two application are into a Web Farm. Should be ARR the problem?
View 2 Replies