More in this section

Forums / Developing with Sitefinity / Facing problem with login failed for user while accessing Local sql server db (Sitefinity.mdf)

Facing problem with login failed for user while accessing Local sql server db (Sitefinity.mdf)

2 posts, 0 answered
  1. Swetha
    Swetha avatar
    5 posts
    09 Jan 2015
    11 Feb 2015
    Link to this post

    Hi All,

     Am new to sitefinity, please help me on this issue

    1.Add a GridView in ASP .NET Visual Studio for a user control .ascx file. 
    2.Assign any table from sitefinity as a datasource to the GridView.
    3.The TestConnection is succeeded, but while we are actually trying to access it as a widget in sitefinity page, we are facing a "Login Failed" issue for the database.
    4.Attached a screen shot of the error in the browser.
    5.The interesting thing here is we are able to access and get data of all other tables which we create in SQL Server, but I hope there are some restrictions stopping me to get the data of Sitefinity tables.

    Connection String in Visual Studio : connectionString="Data Source=DELL-PC\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Sitefinity.mdf;Integrated Security=True"


    Thanks & Regards


  2. Sabrie Nedzhip
    Sabrie Nedzhip avatar
    534 posts
    17 Aug 2017
    13 Feb 2015
    Link to this post
    Hi Swetha,

    The Login failed for user error may occur if the user does not have proper permissions to access the database or that the identity that is managing the application pool for the site does not exist in the SQL Server instance. The problem may also occur if the worker process of IIS is not able to authenticate to the SQL instance at some point, or the identity used for logging to the site is not correct.

    Can you please let me know more details about the issue and when exactly it reproduces? Does the issue appear each time when you try to login to the Sitefinity backend or it only reproduces when you try to access the page where you have dropped your custom widget?

    As far as I understand, you have created a user control in your Sitefinity project in Visual Studio and have added a GridView control in the markup. Can you please let me know what is the data you would like to bind to the GridView? How do you get the data in the code behind and how do you bind the data to the GridView?

    Can you please let me know how you have registered the widget in the Toolboxes, so that you can drop the widget on a Sitefinity page? You can easily register widgets with a couple of clicks using Thunder. Please refer to the following article for more details on this. Can you please try registering the widget using Thunder and let me know about the results?

    It would be grate help if you can record a video demonstrating the exact steps on your side and how the issue is reproduced. This way I will be able to get better picture of the problem.

    Sabrie Nedzhip
    Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Sitefinity CMS Ideas&Feedback Portal and vote to affect the priority of the items
2 posts, 0 answered