View Complete Post
J have read many answers about
Login failed for user ''. The user is not associated with a trusted SQL server connection
error, but I don't want to mess up in my sql server so I want to be sure that what I do is OK.
In my company, we have our own application wchich we use to connect to database. All users use SQL Server Auth except me. I can log using Windows Auth from server and from my second computer.
Now everything works fine.
- My comp is in our domain 'OurDomian'.
- On server in AD is admin account 'SqlAdmin'.
- In MSSMS in Security->Logins there is account: OurDomian\SqlAdmin
- on my comp account OurDomian\SqlAdmin is added
I can log to sql server from my comp using 'Integrated Security' in application with no problem.
Problem starts when I change SqlAdmin password on server.
When I connect from my comp I get the above error. But when I connect from server there is no problem.
I searcher application code and I don't think that I have to change somthing in it. Probably I have to change something with account and permissions.
1. Will it bee enough to delete and add again 'OurDomian\SqlAdmi
I do not seem to be able to find even a yes no answer on this...
Using windows Authentication... is it possible to progrematically change a password?
I tried using several ways to do this. I tried using the ChangePassword control. This tells me that minimun characters is 7 even though I have more then 7 characters... I also tried using this method:
if (u.ChangePassword(TextBox2.Text, TextBox3.Text))
LabelError.Text = "Password changed.";
LabelError.Text = "Password change failed. Please re-enter your values and try again.";
catch (Exception ex)
LabelError.Text = "An exception occurred: " + Server.HtmlEncode(ex.Message) + "<BE>" + ex.ToString() + ". Please re-enter your values and try again.";
The user is always null... and I am assuming this is because this object is indended to use with Forms authentication.
All I want to do is have an option for users to change passwords. Is this possible with Windows Authentication?
I have two web sites that will be hitting the same reporting services instance. One is external facing (internet), the other intranet. The external site is unable to use windows authentication because some of the devices to not support the challenge
popup to enter their credentials (think: blackberry without enterprise server). The other site is just normal windows machines who can pass their credentials normally. From the research I have found it sounds like [for the external site] I have
to have a form that collects their credentials, authenticates (via LogonUser) and they can go on their merry way. I do not want to do this step for the internal site - I would like to rely on normal windows authentication.
The question is: Is it possible to specify both types of authentication (custom extension and windows) on the same instance, or do I have to use 2 instances, or use forms for both?
Thank you in advance,
I am using sharepoint2010 forms based authenticaion (claims based) configure all the web.config files and its working fine.Now I want to change this applicaion to windows authentication (claims) what
are the things to follow to change the application to windows and vice versa.I refer few links but they are referring from classic to claims and many other things not my req..!
I would like to build a custom login page which doesnt uses the windows or forms authentication but I am troubled as to how I should do that. I tried to follow the default AccountController.vb file but it doesnt help me much as it doesnt show where its connecting with the database.
What is need is:
Database Table User
columns are userid, email, password
to write a login page that will use my sql server to login rather than using the forms or windows authentication
I'm curious if its possible to get windows auth working with asp.net webpages/webmatrix.
I've got it published to IIS with windows auth turned on and anonymous/forms/basic turned off.
I'm guessing the WebSecurity Helper probably won't work here but can you access User.Identity.Name etc?
Sorry for the newbie questions, I've only just started working with asp.net ^^,
Hello, I am seeing a strange problem with Forms Authentication in my DD site. A user logs into and can view/edit/delete data all day, but when they execute a Custom Filter against data (for example , a control DynamicData/Filters/CustomerLastNameSearch.ascx ) then the site auth fails, and redirects to the log in screen.
in web.config I have
<authentication mode="Forms"> <forms name=".Star" loginUrl="~/Login.aspx" protection="All" defaultUrl="~/Default.aspx" path="/" timeout="43200" cookieless="UseCookies" /> </authentication>
Offhand, I am thinking two things : that DynamicData/Filters path requires some special handling for some reason, or the control extension ascx is causing auth to get confused. Has anyone else experienced this or have any suggestions? Thanks!