Post reply

Unable to connect to database from application using application role

  • February 1, 2007 at 3:02 pm

    #175721

    I created application role in my database and gave select permissions on some tables to application role.Then I activated application role using sp_setapprole.But when developer trying to connect to server using this approle userID and password  it gives me following erroe.

    Login fails for user "approlename'

     

    Could you please help me with this.

     

    Thanks,

    SR

    Thanks,
    SR

  • February 1, 2007 at 7:59 pm

    #687295

    The app role is at the database level. The developer needs to connect to the SQL Server with a valid login first. Has the developer done that? If the developer is getting a login failed error, it sounds like the developer is trying to use the app role and password as the login.

     

    K. Brian Kelley
    @kbriankelley

  • February 1, 2007 at 8:06 pm

    #687296

    Apparently it's a known bug (with .NET Framework 1.1). More here:

    MSDN Forums - SQL H2 Performance Collector - Buffer Cache Hit Ratio Problem

     

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply