Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Product Forums » Blackbaud NetCommunity » BBNC RE7 WS Database Connection Issues

BBNC RE7 WS Database Connection Issues

Last post 11-25-2008 10:19 PM by Michael Wiebrands. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 11-24-2008 1:07 AM

    BBNC RE7 WS Database Connection Issues

    Reply Contact

    Hi Guys,

    I am setting up a development environment to develop some custom components for BBNC. I am having some issues with the BBNC install.

    I have setup RE7 on the same machine with a database authenticating through Windows Auth, it all works well. After install of BBNC I get the following error on the testconfig.aspx.

    RE7 WSREAPI Connection265.63FAILEDSystem.ApplicationException: Error loading attributes: Startup Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "re7" requested by the login. The login failed. Native error:4060 Main Startup Step: CBBStartSeq.Startup Start Sequence Step: ConnectToDB
    at Blackbaud.Web.Content.Core.AttributeHelper.GetAttributeTypes(bbAttributeRecordTypes type)
    at Blackbaud.Web.Content.Portal.ConfigurationValidator.RE7ServiceToRE7API()

    Does anyone know what might be causing this and how to correct it?

    It looks like an authentication error and I would assume the details are in the RE7 WS web.config but I cannot find anything in the config related directly to the RE7 database login. As a matter of fact, I cannot remember any mention of auth details for the WS when I installed BBNC. I have also searched through the BBNC and BB knowledge base to no avail. Any help would be appreciated.

    Michael

     

  • 11-24-2008 2:56 AM In reply to

    Re: BBNC RE7 WS Database Connection Issues

    Reply Contact

    Update:

    Figuring it's a windows authentication issue I setup SQL server and RE7 with SQL server authentication instead. They are both working fine.

    I then try to install BBNC and it wont install the database at all. There are no options in the install process for the SQL Server sa username and password so I don't know how it would setup the database to start with. The installer ends up failing when it does it's checks and can't connect to the database (which isn't there). So as far as I can tell, BBNC wont work with SQL Server auth at all!

    Any help would be appreciated

     

  • 11-25-2008 10:19 PM In reply to

    Re: BBNC RE7 WS Database Connection Issues

    Reply Contact

    The issue has been overcome. Rather than do a cold NC install for development I restored the backed up production NC database to the development SQL server instance and hooked the details for that into the installer options. All came up fine.

    Thanks to Garrett Keating for the help and advice :)
Page 1 of 1 (3 items)