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 So Paulo, Brazil.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 So Paulo, Brazil.|||Hi Igor,

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

Thanks,

Genilson|||Then ensure the defined user 'AGFBRASIL\GAVieira' has required privilege on SQL side to connect to the database.|||Hello Satya,

Yes. This user is owner of the database.|||May try the BIP site for any information for this behaviour.|||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|||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>