Books Online Updated

Hi,
While installing the SQL Server 2000 Eval, I skipped Books Online since I
had previously downloaded the Books Online (Updated). I then installed the
updated version of Books Online. Now, when I try to access help from any of
the SQL Server tools like Query Analyzer, etc, nothing happens and no help
window comes up. I'd appreciate information on how to connect the SQL Server
installation to the updated Books Online.
Thanks for any help!
YogiFirst simply try re-installing the updated books on line..
If that doesn't work, go back to the SQL install, and do a custom install
and simply select ONLY install books.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Yogi PG" <yogipgNOSPAM@.NOSPAMhotmail.com> wrote in message
news:%23pNfXMXFEHA.712@.tk2msftngp13.phx.gbl...
> Hi,
> While installing the SQL Server 2000 Eval, I skipped Books Online since I
> had previously downloaded the Books Online (Updated). I then installed the
> updated version of Books Online. Now, when I try to access help from any
of
> the SQL Server tools like Query Analyzer, etc, nothing happens and no help
> window comes up. I'd appreciate information on how to connect the SQL
Server
> installation to the updated Books Online.
> Thanks for any help!
> Yogi
>

Books Online July 2006 issue

The SQL Server Books Online was working installed on my workstation fine until this morning. Now when I open it up it does not show me T-SQL reference with all the commands and functions. Yesterday I was on the MSDN website using the Books Online. Could some pointers in the program been corrupted? I have uninstalled and reinstalled Books Online to no avail.

Please help.

Thanks,

Fred

Hi Fred,

When you open Books Online on your local machine, do you see a Contents tab (typically located on the left-hand side of the page)? If no, click the Contents option on the top tool bar. This should reopen the Contents tab that has been closed or hidden.

2. If that doesn't resolve your problem, can you please provide more information. For example, can you find T-SQL Reference topics by using the Index or Search tabs?

Regards,

Gail

|||

Hi Gail,

Yes, the Contents tab is there. When I expand "SQL Server 2005 Books Online" entry in the Contents tab and then expand "SQL Server Language Reference" it shows only "Transact-SQL Reference". It used to show more. Then when I expand "Transact-SQL Reference" it only shows "System Tables (Transact-SQL)". It used to list all the statements and functions.

Thanks,

Fred

|||

Hi Fred,

Okay, this sounds like maybe a filter was accidently set that is limiting the returned topics. At the top of the Contents tab, there's a "Filtered By" drop down box. Make sure the filter is set to either 'unfiltered' or 'SQL Server 2005', or 'SQL Server Database Engine'.

That should resolve the problem, but if it doesn't let me know.

Gail

|||

Hi Gail,

Thanks, that fixed the problem.

Fred

Books Online Help..

I have installed SQL Server 2000 Personal edition on my desktop, which has a C: and a D: drive. All the program files, WINNT folder are on D: drive and the SQL Server has also been installed on the D: Drive.
Now when I try to open the Books online then I get the error " unable to open D:\Program files\Microsoft SQL Server\~sql80.col.
Any help??Have you tried reinstalling?

Did you check to see whether sql80.col exists on your D drive?

Do you get this error when you invoke the help system through both the Windows Menu bar and Query Analyzer's help menu?

Can you run the following command:
C:\WINNT\hh.exe "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"?

blindman|||The location should be "D:\Program Files\Microsoft SQL Server\80\Tools\Books\SQL80.col"

books online download link please

please provide me the link of books online of sql server.

i've this with my sql server, but un installed. i need this book immiedietly please give me the linkGo to Microsoft.com and follow the links to SQL Server 2000 and then downloads. It will get you to the .msi file. I just ran it yesterday without a problem

Books Online

How do you install sql-server 2000 books online to a server that does
not have sql-server installed at all. I want get access the
documentation via a link from our internal intranet. Any ideas!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I can answer the first question, you can download the most current version
from
http://www.microsoft.com/downloads/...DisplayLang=en,
and install it on the server, but I don't know how to make it work from
clients connected to that server.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:eqDdZAtAEHA.212@.TK2MSFTNGP12.phx.gbl...
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Dave Brooks wrote:
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
Doesn't it work?
1) Copy Program Files\Microsoft SQL Server\80\Tools\Books directory
2) Execute C:\WINDOWS\hh.exe
" THE_DIRECTORY_WITH_BOL_ON_YOUR_MACHINE\S
QL80.col"
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||in addition to the downloadable BOL link Stephen provided and the suggestion
from Sebastian, BOL is also available online on MSDN website at:
http://msdn.microsoft.com/library/d...
ap1.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply only to the newsgroup.
"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:eqDdZAtAEHA.212@.TK2MSFTNGP12.phx.gbl...
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

BOL May 2007 shows no index and no table of contents

I downloaded and installed SqlServer2K5_BOL_May2007.msi, and it had no index and no table of contents. The shortcut is
"C:\Program Files\Common Files\Microsoft Shared\Help 8\dexplore.exe" /helpcol ms-help://MS.SQLCC.v9 /usehelpsettings SQLServerBooksOnline.9.0 /LaunchFKeywordTopic sql9.portal.f1

there are table of contents files:

Directory of C:\Program Files\Microsoft SQL Server\90\Tools\Books\1033

01/26/2007 11:59 AM 12,949 sql90.hxt
07/27/2006 07:53 AM 271 SQLCC.hxt
11/07/2006 02:16 PM 687 ssm3.hxt

and there are index files too -- the most important one seeming to be :

05/23/2007 12:44 PM 13,630,606 sql90.hxq

I re-executed the .msi and chose repair.
That didn't work to show the index or TC either.

I will try a reboot -- but then I'll have to resintall the previous BOL.

I downloaded and installed it, I was asked about a previous version and choose yes to override it. I am also running Katamai BOL both runs fine. I have no problems, so I think you should delete the download and get a new file for the next install. Hope this helps.|||TOC and index have showed up after a reboot. (Windows XP SP2)

BOL - Katmai

What is the differences between the downloaded Katmai BOL and the installed
SQL Server BOL?They are the same.
--
Jason Massie
http://statisticsio.com
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
> What is the differences between the downloaded Katmai BOL and the
> installed
> SQL Server BOL?
>|||Why MS has separate downloads for them?
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
> They are the same.
> --
> Jason Massie
> http://statisticsio.com
> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
> > What is the differences between the downloaded Katmai BOL and the
> > installed
> > SQL Server BOL?
> >
> >
>|||So you can install the doc's without having to dl the entire product.
--
Jason Massie
http://statisticsio.com
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
> Why MS has separate downloads for them?
> "jason" <jason-r3move@.statisticsio.com> wrote in message
> news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
>> They are the same.
>> --
>> Jason Massie
>> http://statisticsio.com
>> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
>> > What is the differences between the downloaded Katmai BOL and the
>> > installed
>> > SQL Server BOL?
>> >
>> >
>|||Also, to reach to the content offline.
--
Ekrem Önsoy
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
> Why MS has separate downloads for them?
> "jason" <jason-r3move@.statisticsio.com> wrote in message
> news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
>> They are the same.
>> --
>> Jason Massie
>> http://statisticsio.com
>> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
>> > What is the differences between the downloaded Katmai BOL and the
>> > installed
>> > SQL Server BOL?
>> >
>> >
>|||Sorry, I mean there are separate download of BOL and the Katmai ones. It
made me think they are different.
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:819A939C-234D-4497-9488-B85529A4D15B@.microsoft.com...
> Also, to reach to the content offline.
> --
> Ekrem Önsoy
>
> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
> > Why MS has separate downloads for them?
> >
> > "jason" <jason-r3move@.statisticsio.com> wrote in message
> > news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
> >> They are the same.
> >> --
> >> Jason Massie
> >> http://statisticsio.com
> >>
> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> >> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
> >> > What is the differences between the downloaded Katmai BOL and the
> >> > installed
> >> > SQL Server BOL?
> >> >
> >> >
> >>
> >
> >
>|||>> >> > What is the differences between the downloaded Katmai BOL and the
>> >> > installed SQL Server BOL?
Jason and Ekrem are correct. Right now the downloaded Katmai BOL is the same
as the installed version of Books Online. However, once Katmai is released,
we will continue to release updates to the Katmai Books Online and t that
point, the installed version and the downloaded version will be different.
We started doing this with SQL Server 2000 and with SQL Server 2005, we've
made 5 "refreshed" versions of Books Online available for download.
Hope that helps,
Gail Erickson
SQL Server Documentation Team
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:OVAtBsJLIHA.4196@.TK2MSFTNGP04.phx.gbl...
> Sorry, I mean there are separate download of BOL and the Katmai ones. It
> made me think they are different.
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:819A939C-234D-4497-9488-B85529A4D15B@.microsoft.com...
>> Also, to reach to the content offline.
>> --
>> Ekrem Önsoy
>>
>> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> > Why MS has separate downloads for them?
>> >
>> > "jason" <jason-r3move@.statisticsio.com> wrote in message
>> > news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
>> >> They are the same.
>> >> --
>> >> Jason Massie
>> >> http://statisticsio.com
>> >>
>> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> >> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
>> >> > What is the differences between the downloaded Katmai BOL and the
>> >> > installed
>> >> > SQL Server BOL?
>> >> >
>> >> >
>> >>
>> >
>> >
>|||There is a BOL update called May 2007 as updated on September when I
searched on MS site.
It seems this updated BOL is differenct from Katmai?
"Gail Erickson" <gaile_online@.microsoft.com> wrote in message
news:OlPOlRLLIHA.3516@.TK2MSFTNGP02.phx.gbl...
> >> >> > What is the differences between the downloaded Katmai BOL and the
> >> >> > installed SQL Server BOL?
> Jason and Ekrem are correct. Right now the downloaded Katmai BOL is the
same
> as the installed version of Books Online. However, once Katmai is
released,
> we will continue to release updates to the Katmai Books Online and t that
> point, the installed version and the downloaded version will be different.
> We started doing this with SQL Server 2000 and with SQL Server 2005, we've
> made 5 "refreshed" versions of Books Online available for download.
> Hope that helps,
> Gail Erickson
> SQL Server Documentation Team
>
> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> news:OVAtBsJLIHA.4196@.TK2MSFTNGP04.phx.gbl...
> > Sorry, I mean there are separate download of BOL and the Katmai ones. It
> > made me think they are different.
> >
> > "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> > news:819A939C-234D-4497-9488-B85529A4D15B@.microsoft.com...
> >> Also, to reach to the content offline.
> >>
> >> --
> >> Ekrem Önsoy
> >>
> >>
> >>
> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> >> news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
> >> > Why MS has separate downloads for them?
> >> >
> >> > "jason" <jason-r3move@.statisticsio.com> wrote in message
> >> > news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
> >> >> They are the same.
> >> >> --
> >> >> Jason Massie
> >> >> http://statisticsio.com
> >> >>
> >> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
> >> >> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
> >> >> > What is the differences between the downloaded Katmai BOL and the
> >> >> > installed
> >> >> > SQL Server BOL?
> >> >> >
> >> >> >
> >> >>
> >> >
> >> >
> >>
> >
> >
>|||Alan, I believe you may have found the latest update to the SQL Server 2005
Books Online. - RLF
"Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
news:ePdkvgVLIHA.3356@.TK2MSFTNGP02.phx.gbl...
> There is a BOL update called May 2007 as updated on September when I
> searched on MS site.
> It seems this updated BOL is differenct from Katmai?
>
> "Gail Erickson" <gaile_online@.microsoft.com> wrote in message
> news:OlPOlRLLIHA.3516@.TK2MSFTNGP02.phx.gbl...
>> >> >> > What is the differences between the downloaded Katmai BOL and the
>> >> >> > installed SQL Server BOL?
>> Jason and Ekrem are correct. Right now the downloaded Katmai BOL is the
> same
>> as the installed version of Books Online. However, once Katmai is
> released,
>> we will continue to release updates to the Katmai Books Online and t that
>> point, the installed version and the downloaded version will be
>> different.
>> We started doing this with SQL Server 2000 and with SQL Server 2005,
>> we've
>> made 5 "refreshed" versions of Books Online available for download.
>> Hope that helps,
>> Gail Erickson
>> SQL Server Documentation Team
>>
>> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> news:OVAtBsJLIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> > Sorry, I mean there are separate download of BOL and the Katmai ones.
>> > It
>> > made me think they are different.
>> >
>> > "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
>> > news:819A939C-234D-4497-9488-B85529A4D15B@.microsoft.com...
>> >> Also, to reach to the content offline.
>> >>
>> >> --
>> >> Ekrem Önsoy
>> >>
>> >>
>> >>
>> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> >> news:eZ6RYj$KIHA.5328@.TK2MSFTNGP05.phx.gbl...
>> >> > Why MS has separate downloads for them?
>> >> >
>> >> > "jason" <jason-r3move@.statisticsio.com> wrote in message
>> >> > news:D346C7CC-76F0-48DF-9E5C-EB4700452692@.microsoft.com...
>> >> >> They are the same.
>> >> >> --
>> >> >> Jason Massie
>> >> >> http://statisticsio.com
>> >> >>
>> >> >> "Alan T" <alanNOSPAMpltse@.yahoo.com.au> wrote in message
>> >> >> news:O7N4yK9KIHA.3356@.TK2MSFTNGP02.phx.gbl...
>> >> >> > What is the differences between the downloaded Katmai BOL and the
>> >> >> > installed
>> >> >> > SQL Server BOL?
>> >> >> >
>> >> >> >
>> >> >>
>> >> >
>> >> >
>> >>
>> >
>> >
>>
>|||There are actually three versions of Books Online downloads currently
available on the Web. We periodically publish updates to the Books Online
for the currently shipping version of SQL Server, and make the updates
available as a Web download. In addition, we now publish the SQL Server 2005
Books Online updates through Microsoft Update. As you have found, we have
also publish the SQL Server 2008 Books Online for the latest CTP so that
customers can download the documentation seperately from the product.
The current Books Online downloads are:
1. SQL Server 2008 November CTP Books Online.
2. SQL Server 2005 July 2007 Books Online update, which can also be
installed by using Microsoft Update. We are in the process of finalizing the
testing to refresh the download and Microsoft Updat with the September 2007
update.
3. SQL Server 2000 January 2004 Books Online. This was the last update we
made for the SQL Server 2000 Books Online.
--
Alan Brewer [MSFT]
SQL Server Documentation Team
Download the latest Books Online update:
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
This posting is provided "AS IS" with no warranties, and confers no rights.|||> The current Books Online downloads are:
> 1. SQL Server 2008 November CTP Books Online.
So this is a separate install for SQL Server 2008 BOL?
> 2. SQL Server 2005 July 2007 Books Online update, which can also be
> installed by using Microsoft Update. We are in the process of finalizing
the
> testing to refresh the download and Microsoft Updat with the September
2007
> update.
Do I need to have the SQL Server 2005 BOL installed?
Is this called Katmai?
> 3. SQL Server 2000 January 2004 Books Online. This was the last update we
> made for the SQL Server 2000 Books Online.

Blocked sleeping active connections

Hi

We just installed SQL service pack 4. I am now finding that when doing a sp_who2 active, there are a lot of connections that are blocked by itself. The common factor is they all have a status of 'sleeping'. The strange thing is that even though it shows the connection is blocked, it is in fact not and will still return results. Below is a snapshot of a portion of what the sp_who2 active returns:

SPID Status Login HostName BlkBy DBName
53 sleeping sa TRACKER 53 dbABC
58 sleeping sa TRACKER 58 dbCDE
64 sleeping sa TRACKER 64 dbSTA
66 RUNNABLE User12 PC24 . master
70 sleeping User5 ANALYSIS 70 dbBML
74 sleeping sa TRACKER 74 dbCDE
76 sleeping sa TRACKER 76 dbPTS
83 sleeping User5 ANALYSIS 83 dbANA
86 DORMANT User11 CPTDB . NULL

Has anyone seen this? Is it related to the installation of service pack 4? (We have installed the services pack on many other SQL servers, but have not come accross this before.

Tx,
TessZAThe "self-blocking spid" is a new feature of SP4. In short, it is not actual blocking. If a spid is waiting on a latch, it shows as blocking itself. I have not seen it on this scale, though. Do you happen to know if you are suffering a lot of disk activity around the times that a lot of self-blocking spids are showing up?

Blank warning when I launch SQL Express mgt.

I have rebuilt this laptop (XPpro) and installed the SQL Express, now when we
launch the sql server management studio express we get a blank warning popup.
Anyone have any ideas why we are getting this and how to remove it?
I have sql loaded on other laptops and this is the first one that this has
showed up on. When you click on OK you can connect to your dBase just fine.
Thanks.

Quote:

Originally Posted by tech-pete

I have rebuilt this laptop (XPpro) and installed the SQL Express, now when we
launch the sql server management studio express we get a blank warning popup.
Anyone have any ideas why we are getting this and how to remove it?
I have sql loaded on other laptops and this is the first one that this has
showed up on. When you click on OK you can connect to your dBase just fine.
Thanks.

I was having the same problem. To fix it, I did a complete uninstall of all sql components via add/remove. Then manually removed the C:\Program Files\Micorsoft SQL Server folder.
Then I removed the Network 2.0 framework then, after restarting I reinstalled everything and the blank dialog is gone. You might try just reinstalling the Network 2.0 Framework first. I think MSMXL 6.0 gets removed automatically, but that has to go also.
In any case, I had tried numerous other fixes and this is the only thing that worked.

Blank warning when I launch SQL Express mgt.

I have rebuilt this laptop (XPpro) and installed the SQL Express, now when we
launch the sql server management studio express we get a blank warning popup.
Anyone have any ideas why we are getting this and how to remove it?
I have sql loaded on other laptops and this is the first one that this has
showed up on. When you click on OK you can connect to your dBase just fine.
Thanks.tech-pete;7385369 Wrote:
> I have rebuilt this laptop (XPpro) and installed the SQL Express, now
> when we
> launch the sql server management studio express we get a blank warning
> popup.
> Anyone have any ideas why we are getting this and how to remove it?
> I have sql loaded on other laptops and this is the first one that this
> has
> showed up on. When you click on OK you can connect to your dBase just
> fine.
> Thanks.
I was having the same problem. To fix it, I did a complete uninstall of
all sql components via add/remove. Then manually removed the C:\Program
Files\Micorsoft SQL Server folder.
Then I removed the Network 2.0 framework then, after restarting I
reinstalled everything and the blank dialog is gone. You might try just
reinstalling the Network 2.0 Framework first. I think MSMXL 6.0 gets
removed automatically, but that has to go also.
In any case, I had tried numerous other fixes and this is the only
thing that worked.
dhead12345

Blank warning when I launch SQL Express mgt.

I have rebuilt this laptop (XPpro) and installed the SQL Express, now when w
e
launch the sql server management studio express we get a blank warning popup
.
Anyone have any ideas why we are getting this and how to remove it?
I have sql loaded on other laptops and this is the first one that this has
showed up on. When you click on OK you can connect to your dBase just fine.
Thanks.tech-pete;7385369 Wrote:
> I have rebuilt this laptop (XPpro) and installed the SQL Express, now
> when we
> launch the sql server management studio express we get a blank warning
> popup.
> Anyone have any ideas why we are getting this and how to remove it?
> I have sql loaded on other laptops and this is the first one that this
> has
> showed up on. When you click on OK you can connect to your dBase just
> fine.
> Thanks.
I was having the same problem. To fix it, I did a complete uninstall of
all sql components via add/remove. Then manually removed the C:\Program
Files\Micorsoft SQL Server folder.
Then I removed the Network 2.0 framework then, after restarting I
reinstalled everything and the blank dialog is gone. You might try just
reinstalling the Network 2.0 Framework first. I think MSMXL 6.0 gets
removed automatically, but that has to go also.
In any case, I had tried numerous other fixes and this is the only
thing that worked.
dhead12345

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>