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

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Database login set up issue

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hi folks, I have more than one domains trusted each other, one user has already been granted access in the server, but I don't see it using Exec  xp_logininfo. I even tried adding the user as sysadmin. no problem for most of other users from the same domain. For another user, when I run the Exec  xp_logininfo, it returns: Msg 15404, Level 16, State 11, Procedure xp_logininfo, Line 62 Could not obtain information about Windows NT group/user 'INTL\RTxie', error code 0x534. what happened to these two accounts? is it a SQL issue or Active Directory issue? That domain has 15000 accounts across over 100 domain controllers. my domain has roughly the same amount users. they are trusted each other under same forest. Thank you in advance.

View Complete Post

More Related Resource Links

Login database with visual studio 2010 asp website template


Has anyone deployed a website using the login database in the visual studio 2010 asp website template? I was wondering if I could look at someone's example to see how the integrated this into their website.

Issue with Remember Me on User Login control


Hi everyone,

     I hope you can help me, I tried Google, but none of the solutions worked. Using VB.net and Membership, I have a login control in my master page with a remember me check box. When I check this box and login, some pages indicate that I am not logged in. If I go to another page, it will then indicate that I am still logged in. I have isolated one page that always indicates I am not logged in the first time I visit it, but if log in a second time and then go to it, it will finally recognize me as a user that is properly logged in. 

Some pages that this occurs on is in the top level, some pages are in a sub folder.

My MasterPage has the following Form Code:

<body bgcolor="#E0ECF9" topmargin="0" leftmargin="0">

    <form id="form1" runat="server">

My Aspx file has a troubleshooting label, several Gridviews and several DetailViews:

    <asp:Label ID="lblErRep" runat="server" Text=""></asp:Label>

My aspx.vb file has 1 line of code (Protec

Windows authentication login form issue


Hi guys,

I have an application that requires windows authentication to login, the problem is that every time an user logs in under IE and win XP, the username is pre filled with the IP address of the server as instance and the username. I need to replace the server ip with  XXXX instance name instead of doing this manually.

Could anyone pleas help me out with this one?

Thanks in advance,


Cannot open database "ReportServer$SQLEXPRESS" requested by the login. The login failed. (App Log Ev

I have SQL'08r2x64 freshly installed on a WS'03r2x64sp2 box and WS is also a DC (sorry).  Previously, there was a SQL'05sp3 installation on this box and it worked splendito.  I used the SQL'05 for some minor devel and to host a Backup Exec 11D db/installation; it all was splendito.   Then, i removed SQL'05&BE11D to prepare for an upgrade of this arrangement.  Next, i installed said SQL'08 to be the foundation for a planned Backup Exec 12.5 install.  To date, I can't get to a clean install of SQL'08 and thus have not progressed to installing BE12.5.  I now have this painfully annoying situation (as i've been beating on it for 2 days) where a series of errors occur during boot: 1st: srmSvc; Event ID 12317; File Server Resource Manager failed to enumerate share paths or DFS paths.  Mappings from local file paths to share and DFS paths may be incomplete or temporarily unavailable.  FSRM will retry the operation at a later time. 2nd & 3rd (occurs twice): MsSQL$buExpressSQL; Event ID 18456; Login failed for user 'BOWMAN\ExecSQL'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>] 4th: Report Server Windows; Event ID 107; Report Server Windows Service (SQLEXPRESS) cannot connect to the report server database. I couldn't find anything to sink my teeth into for the 12317 error; i

Issue inserting to database on submit the page goes blank

Hi guys,I'm new to asp.net, can someone please help me with this. I'm trying to insert few values to a table, when i press the submit button the aspx page goes blank and i don't get any error message. I'm not able to find where the error is.The code:Protected Sub AddMInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddMInfo.Click Dim dbsource As SqlDataSource dbsource = New SqlDataSource         dbsource.ConnectionString = ConfigurationManager.ConnectionStrings("dbConnectionString1").ToString         dbsource.InsertCommandType = SqlDataSourceCommandType.Text         dbsource.InsertCommand = "INSERT INTO db_mdl_info(dlprodid,dlmdlid,dlbrnd,dlmdlnm,dlmdlnbr,dlcpst,dlprsr,dlmxm,dlmim,dlmslt,dlmxps,dlmtpe)" &                                 "Values('" & DropDownList2.Text & "','" & DropDownList3.Text & "','" & MakeTextBox.text & "','" & DropDownList2.SelectedItem.Text &                                 "','" & MNoTextBox.Text & "','&quo

need a simple login page cus my hosting provider system wont allow me to have more than one database

I dont really write html code too well  but I manged to get my web site developed and deployed using the built in features such as drag n drop, master page and user account authentication that make web developing almost a codeless experience. However; my hosting provider system wont allow me to have more than one database, this causes problems becasue when I developed my web app using vb2010 web developer (asp.net v2) I used the built in web config tool to manage users for my site, now after I deployed to my domain it all worked ok with the exeption of the login page, when I tried to log in the system threw a error message saying "database not found." or a page of "gobble-dee-gook" that says the same thing When I contacted support (my hosting provider) they said i have to create a table of users in my database file via 2008 sql server, thats ok I can do that, but my real problem is I dont know how to write appropriate code to reference the table. So heres my problem:  I just want to have some kind of login page with a couple of txtboxes and a click button that maybe using the VB code behind or html checks the input variables "username" "password" against something that is hard coded into vb a string variable or a constant and then branches to Mainmenu.aspx if successfull. I just need it real simple, no fancy stuff just a login s

Cannot open database " " requested by the login. The login failed.

Hi, I am trying to take the backup of the sitecolletion using stsadm -o command, getting the following error. Cannot open database "dbName " requested by the login. The login failed. Login failed for user  'User'. Any help appriciated. Thanks Srikanth Reddy

Can I have an SQL Express database open in VS2010E along with the website? "Login failed for user ..

Hi, as the topic says..Whenever I have my database open in Visual Studio 2010 Express, I get this error:Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.Cannot open user default database. Login failed.Login failed for user 'IIS APPPOOL\DefaultAppPool'.

Login to Database from Application

Hello, On my SQL Server I have the Security and Logins section.  I usually do the following to access the database from my application: 1 - Create a database on dbo scheme; 2 - Create a Login; 3 - Create a Database Role in the Database and grant the following permissions:      select, insert, update, delete, execute on schema::dbo 4 - Create a Database User and associate it to the Database role and to the Login  Then on my MVC application I use a Connection String with the login to access the database. Can I access the database without the login? Should I make this in some other way? Thank You, Miguel

Cannot Login with Forms Based Authentication to SharePoint 2010 - Issue with the SecurityTokenServic

Please be advised I have followed the steps on http://donalconlon.wordpress.com/2010/02/23/configuring-forms-base-authentication-for-sharepoint-2010-using-iis7/. I have tried to fix the following issue for a week using different farms and SharePoint 2010 installations, however I am getting the following error when trying to authenticate using Forms Based into a Claims site: Cannot get Membership Provider with name FBARoleProvider The membership provider for this process was not properly configured. You must configure the membership provider in the .config file for every SharePoint process. 1. I am certain the membership provider is configured in the SecurityTokenServiceApplication webservice as I can manage users and roles in IIS7 using the SecurityTokenServiceApplication website. 2. I am certain that membership provider is configured in the both the Claims Web Application and Central Admin as I can manage users and roles in IIS7 using their websites. 3. I know the issue is the SecurityTokenServiceApplication service as I had to set <serviceDebug includeExceptionDetailInFaults="true" /> to get the error above. 4. I can log into the Claims Based Application using windows authentication, however I am unable to see the users on the people picker despite that I can see them from the application's site on IIS

Login issue using authentication mode="Forms"

Hi,I am using authentication mode="Forms" with ldap, i manage to login and logour fine but when user 1 is logged and when user2 logs, user1 gets the user2 session. Any idea why this might be happening? Here is some code:     <authentication mode="Forms">            <forms name="login" loginUrl="Login.aspx" />        </authentication>        <authorization>            <allow roles="auditor"/>            <allow roles="approver"/>            <allow roles="user"/>            <deny users="?"/>        </authorization>        <identity impersonate="true"/>protected Boolean ValidateUser(String strUsername, String strPassword)        {            //Return true if the username and password is valid, false if it isn't             &n

Cannot open database "dbTest" requested by the login. The login failed.

Hi,All Hi, all      I meet a problem and an error: Cannot open database "dbTest" requested by the login. The login failed.Login failed for user 'machinename'. The condition is like this: 1 I make my website connect to a remote sql server. 2 This sql server makes only access to a count, such as 'sa' and its password is 'sapw' 3 I write the connect string in web.config like this : <add name="ConnectionString" connectionString="Data Source=dbTestSource;Initial Catalog=dbTest;Integrated Security=True;    User ID=sa;Password=sapw;"    providerName="System.Data.SqlClient" />   But the error says "Login failed for user 'machinename'". How could I make my website access to the sql server with the account of "sa"?  

An exception occurred when trying to issue security token: The trusted login provider did not supply

We are facing the issue after got authenticated by OpenID and forwarded back to Sharepoint, it crashed at the /_trust/ page the error "Operation is not valid due to the current state of the object." and event log shows this:   "An exception occurred when trying to issue security token: The trusted login provider did not supply a token accepted by this farm... "    

MVC Login Database

I have started a new MCV application in Visual Web Developer 2010 express. I have an administration controller. I want a page that shows the administrator all the users on the site (using the default database - accessed from the ASP.NET Web Application Administration Tool) and give him controls to edit and delete users and create new users. I have no idea of how to do this as I am relatively new to ASP.NET. Any ideas?I am writing the website in C#. Also, on the ASP.NET Web Application Administration Tool, when managing access rules, it says: "Rules that appear dimmed are inherited from the parent and cannot be changed at this level.". What does this mean and how do I change them?

Login Page issue with the Banner



I'm using Visual Web Developer 2010 Express.

I've published the application however when I view the login page the banner is not displayed I just get the red x.. It's fine in pages in other folders but not the Login page which sits in the Account folder however I'm getting the menu so it seems to be picking up the master page.

I've added the image to the Account folder but it just wont show, any ideas?





<%@ Page Title="Log In" Language="vb" MasterPageFile="~/Site.Master" AutoEventWireup="false"
    CodeBehind="Login.aspx.vb" Inherits="PODPortal.Login" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
        Log In
        <asp:HyperLink ID="RegisterHyperLink" runat="server" Visible="false" Enab

Issue with SAN Drive Migration in master database in clustered SQL Server 2005 SP1




In our SQL Server 2005 SP1 cluster, I have to retire the existing SAN and move all my databases to new SAN drive. I have successfully moved all datafiles (user,system databases, resource) except master database.


Even when I change the parameters in start-up from configuration manager, I am getting error when starting up from cluster administrator / configuration manager.


But I am able to start the SQL Server successfully from command line (without any flags).


When I start the SQL Server from cluster administrator / configuration manager (after changing the parameters), I see that the start-up parameters are changing back to originalpath (old SAN) .


Please let me know incase you need any more information.

Application deployment - database connection issue


Hi, I finished an intranet application using webconfig to store my connection string to an Access database which has linked tables to SQL Server 2005.

Everything works perfectly, but when I publish the application on a IIS server service, it seems like all connections fail... :(


I looked up on internet but found nothing on this. I think my webconfig file is correct :


    <add key="dbconnect" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=//192.168.xxx.x/Websites/xxx/xxx.accdb;Persist Security Info=True"/>


Any idea why it happens?


thanks alot !

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