System.invalidoperationexception: 'connection string "defaultconnection" was not found.'

Question

0.00/5 (No votes)

See more:

Hi Mate

I have this error, each time i m trying to login in, i am getting the websecurity database connection error and dont know how to fix it please help me. Under my AppStart Folder i have the file called "AuthConfig.cs and place the code as below. On my Web.config this my connectionstring.

<connectionStrings>
   <add name="Mystring" providerName="System.Data.SqlClient" connectionString="Data Source=Gcobanim-L\SQLEXPRESS;Database=RegistrationTable" />
 </connectionStrings>

What I have tried:

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("DefaultConnection", "UserProfile", "UserId", "UserName", autoCreateTables: true);
        }
    }
}

Posted 21-Jan-20 1:07am

gcogco10

Updated 21-Jan-20 1:09am

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Accepted Answer · 2020-01-21T01:10:00

Solution 1

There is no connection string named "DefaultConnection". You should try to use configured name instead (Mystring).

Posted 21-Jan-20 1:10am

phil.o

Comments

gcogco10 21-Jan-20 7:16am

I have change the Default to be "Mystring, now i am getting Database.Sql.ClientException login failed for user

phil.o 21-Jan-20 7:21am

Then there is something wrong with the credentials you are supplying.

MadMyche 21-Jan-20 7:26am

wow... how we can't see what is right in front of us

phil.o 21-Jan-20 7:29am

I'm wondering, too :)

OriginalGriff 21-Jan-20 7:37am

"But that connection string worked in the YouTube tutorial I fast forwarded through" :sigh:

gcogco10 21-Jan-20 7:29am

@phil.o before this error, i was first getting system exception on " You must call the WebSecurity.InitializeDatabaseConnection". The i modified my file AuthoConfig.cs under my AppStart folder. So what i have missed before this?

phil.o 21-Jan-20 7:41am

You are over-estimating my ability to guess what could be wrong among informations which you did not provide. The error message tells you there is an issue with provided credentials: either there is no user with specified name, or the password is wrong, or the user/password are correct but there is no access right defined for the user. Whatever the issue, you are the only one who can investigate what is going on.

gcogco10 21-Jan-20 7:55am

@philo.o the user that was created is not yet on the DB, now how do then fix that if the user is not yet created as an existing?

phil.o 21-Jan-20 8:02am

There is no "fix" around that. You must create the user in the database and grant it with proper access rights before trying to use its connection.
Let me do an analogy with a banking system: would you expect to be able to use a credit card for a bank account which has not been created yet?

gcogco10 21-Jan-20 8:13am

Hi @philo.o i created a user table on my DB, My mapping is Web(Security.InitializedDatabaseConnection("MyString", "Users", "UserId", "UserName", autoCreateTables:true) my Users has this field ID(primary key), EmailID, UserName and FullName. But i am still getting same issue. Please assist

phil.o 21-Jan-20 8:20am

Which database engine are you using?

gcogco10 21-Jan-20 8:22am

sql server management studio

phil.o 21-Jan-20 8:31am

You need to learn how to manage users and grant permissions on MS SQL Server (SSMS is not the database engine, it is a graphical front-end to manage databases).
Tutorials Point - MS SQL Server - Assign Permissions[^]

gcogco10 21-Jan-20 9:18am

I have grant permission by following the link and youtube. Now will check if still getting the same issue.

gcogco10 21-Jan-20 9:35am

@phil.o this is strange, i follow this through and grant permission and even restart the sql server. I still facing the same error and still persist.

phil.o 21-Jan-20 9:42am

Could you explain which SQL query you have issued to grant permissions?

gcogco10 21-Jan-20 9:48am

GRANT SELECT ON OBJECT::TestUser.UserName TO Users;
GO

phil.o 21-Jan-20 10:02am

I would rather expect something along USE RegistrationTable; GRANT ALL ON <insert table name here> TO <insert user name here>;.
Instead of creating your own user table, better use the system users table which is already included by the engine.

gcogco10 22-Jan-20 1:55am

I followed this and i am getting this weird error on my sql editor. The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity. Even if i try revoke all on object::dbo.Users to public

phil.o 22-Jan-20 4:47am

I wrote GRANT ALL because I do not know your actual requirements. To get rid of the message, you can specify exactly which rights you want to grant to specified user.
What's the equivalent of the deprecated GRANT ALL on SQL-Azure?[^]
How can I fix “SQL03042: The ALL clause is not supported”?[^]

gcogco10 22-Jan-20 5:07am

Ok now i getting this error, Cannot find the object 'UserReg', because it does not exist or you do not have permission. I created new login it and mapped it with my Domain(window authentication mode). What could i be missing?