Results 1 to 8 of 8

Thread: BIP Portal

  1. #1
    Join Date
    Mar 2004
    Location
    Sao Paulo, Brazil
    Posts
    4

    Post Unanswered: BIP Portal

    Hi everyone,

    I've just installed the BIP portal on an Application Server running Windows 2000 with the latest Service Pack and I choose to install the BIP database on a database Server. I've put my user in the BIP_ADMIN on the Application server's local windows user-group and also in the BIP_USERS role on the database BIP. If I try to browse the URL on the the application server it works well, but when I try to browse from my local machine thorough the network I get the following message: User 'AGFBRASIL\GAVieira' do not currently have access to the database. Please add the user to 'BIP_USERS' user group on SQL server's machine or contact the system administrator.

    Anyone could help me?


    Thanks in advance,

    Genilson from São Paulo, Brazil.

  2. #2
    Join Date
    Feb 2004
    Posts
    1

    Re: BIP Portal

    Hi Paulo
    Try to connect to the database from your local computer without BIP.
    Thanks,
    Igor

    Originally posted by gavieira
    Hi everyone,

    I've just installed the BIP portal on an Application Server running Windows 2000 with the latest Service Pack and I choose to install the BIP database on a database Server. I've put my user in the BIP_ADMIN on the Application server's local windows user-group and also in the BIP_USERS role on the database BIP. If I try to browse the URL on the the application server it works well, but when I try to browse from my local machine thorough the network I get the following message: User 'AGFBRASIL\GAVieira' do not currently have access to the database. Please add the user to 'BIP_USERS' user group on SQL server's machine or contact the system administrator.

    Anyone could help me?


    Thanks in advance,

    Genilson from São Paulo, Brazil.

  3. #3
    Join Date
    Mar 2004
    Location
    Sao Paulo, Brazil
    Posts
    4
    Hi Igor,

    Ok, I've already tried and it worked well. I think the problem is with BIP application.

    Thanks,

    Genilson

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Then ensure the defined user 'AGFBRASIL\GAVieira' has required privilege on SQL side to connect to the database.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Mar 2004
    Location
    Sao Paulo, Brazil
    Posts
    4
    Hello Satya,

    Yes. This user is owner of the database.

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May try the BIP site for any information for this behaviour.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Nov 2003
    Location
    Ukraine
    Posts
    2
    Hello gavieira

    I've got the same problem and
    thread http://www.dbforums.com/t803897.html
    ( after translation from German
    helped me to solve it partially

    I've created login BIPuser on SQL Server with PUBLIC access to
    BIP database (it turned out that BIP_USER role membership isn't neccessery in my case)
    and modified web.config in BIP directory on IIS

    <add key="Authentication" value="SQL" />
    <add key="UserID" value="BIPuser" />
    <add key="Password" value="password" />

    The problem IMHO concerns failed delagation for user logged into application server through IIS to SQl on another server - it tries to connect as nt anonymous

    I'll also be greatfull if gurues suggest more appropriate solution

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    If you're using nT authentication then ensure IIS is configured to use the same, if not ensure login used has necessary privilege to access SQL from IIS>
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •