System.ArgumentNullException:DatabaseSqlClient

Guest User

Hi Team

Who can help me, i am unable to launch my web application, i am getting database.sqlclient exception : login failed for user. Here is my logic below, this is on my AppStart folder(AuthConfig.cs);

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using Microsoft.Web.WebPages.OAuth;
using WebMatrix.WebData;
namespace eNtsaPortalWebsiteProject
{
public class AuthConfig
{
public static void RegisterAuth()
{
WebSecurity.InitializeDatabaseConnection("MyString", "eNtsaMemberRegistrationDB", "UserId", "UserName", autoCreateTables: true);
}
}
}

I have so far try to grant the permission to allow for execution on my sql database, using the sql syntax below;

use eNtsaMemberRegistrationDB

grant all on TestUser to Users;

I am getting this error on my DB

The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar6y ago
Accepted answer
Hello,

Please try below links, Before that please check you web.config file connectionstring name shoud be same in this method also.

Did you change anything in connection string ?, please have a look at connectionstring in web.config/App.config.
https://stackoverflow.com/questions/32375159/asp-net-mvc-websecurity-initializedatabaseconnection-return-error

https://stackoverflow.com/questions/12849415/simplemembershipprovider-websecurity-initializedatabaseconnection-failing-with-a

https://stackoverflow.com/questions/16508934/asp-net-mvc-4-the-websecurity-initializedatabaseconnection-method-can-be-call
Guest User6y ago
That link still showing me exact sql statement as mine, on my case i am not having any db link to execute.
Ramachandran M6y ago
Hi,
I hope below link will help you

https://dba.stackexchange.com/questions/13074/how-to-grant-permission-on-a-table-to-a-user-on-the-other-database-in-oracle