You must Sign In to post a response.
  • Category: Complaints

    Login Failed for user error

    i have uploaded database file .mdf in database folder.
    connection string:
    connectionString="Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=dbname"

    it gives error:
    Cannot open database requested by the login. The login failed.
    Login failed for user 'DOTNETSPIDER1\username'.

    please help
  • #6950

    Can exclude from connection string
    line: Persist Security Info=True;
    be careful that:
    Initial Catalog = AspSpiderUserID_yourDatabaseName

    not only DataBaseName.

    check in Database Manager in Express Manager column "Status" it's must be that follow:
    Database attached successfully.
    SQL Server login created successfully.
    SQL Server access granted successfully.
    Added db_owner role successfully.
    Operation completed successfully.

    If it isn't so you must reattach your database with another name
    for example previousDatabaseName1 and change it's name in connection string value Initial Catalog.
    Best Regards!

  • #6957
    Dear Sir,

    thanks you very much for your help. Now my site working. thanks

  • Sign In to post your comments