Login keeps failing despite correct credentials

Discussion in 'ASP.NET / ASP.NET Core' started by GSS355, Jun 12, 2009.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. GSS355

    GSS355

    Hi,

    I have uploaded my database, got the connection string from the SQL Server admin tool (available in the control panel), and edited this string with my credentials from my new login.

    The credentials I have supplied are from a new login I have made in the Sql Server admin tool. I have passed in the credentials to the web.config (no encryption).

    You can see this by going to www.theplaygrounds.co.uk > Xtras.

    What causes this error?
     
    GSS355, Jun 12, 2009
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    I don't see an error??
     
    Bruce, Jun 15, 2009
    #2
  3. GSS355

    GSS355

    Server Error in '/' Application.

    Cannot open database "SQL2005_625372_playgrounds" requested by the login. The login failed.
    Login failed for user 'gss11'.


    This is the error I get, on page http://www.theplaygrounds.co.uk/Xtras.aspx .
     
    GSS355, Jun 16, 2009
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    There could be 2 potential problems

    1) The gss11 user is not valid or do not have permission to access the db. Try use a regular SQL client to connect w/ this user.

    2) The password in your connection string is invalid.
     
    Bruce, Jun 17, 2009
    #4
  5. GSS355

    GSS355

    In that case, how can I make a user which has appropriate credentials? Do I do it through Sql Server in my db and upload that?

    The password is valid, I have done any editing of the connection string with due care and attention.
     
    GSS355, Jun 19, 2009
    #5
  6. Michael Ossou

    Michael Ossou

    Michael Ossou, Jun 20, 2009
    #6
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page