Topics > DataPlus Fishbowl Accounting Integration > DataPlus 4.0 Fishbowl > FAQ ID # 113

FAQ ID # 113
Last Update : 2016/10/25
Print this FAQ

Question / Issue
DataPlus for Fishbowl - Messages

Answer / Solution

PROGRAM: DataPlus for Fishbowl - Messages
Table of Contents


DataPlus Configuration
    Action
  1. Server/Client: DataPlus Configuration Manager
  2. Click on Test Connection

    Error
    DataPlus 4.0 Warning
    Unable to get configuration from server.
    The input is not a valid Base-64 string as it contains a non-base 64 character, more than two padding characters, or an illegal character amoung the padding characters.

    Resolution

  3. Current user does not have permission to create DataPlus-Connection.xml file
  4. Location
    1. C:\Program Files (x86)\Hogan Data\DataPlus 4.0
    2. C:\Program Files (x86)\ACT\Act for Windows\Plugins\DataPlus 4.0
Type: DataPlus Configuration


DataPlus Tab
    Warning
    DataPlus 4.0 Warning
    No DataPlus menus were found. The DataPlus Tab will be disabled.

    NOTE: If this is your first install, you must set default view permissions and re-load DataPlus.

    Resolution

  1. Server Installation KB Line 163
Type: DataPlus Configuration


DataPlus Activation
    Error
    DataPlus 4.0 Error
    The following error has occurred: Product is not activated and trial has expired. All DataPlus features will be disabled. Please run activation and re-enable DataPlus.

    Resolution

  1. Server Installation KB Line 187
  2. Client Installation KB Line 27
Type: DataPlus Activation


Windows/SQL Permission
    Error
    Error connecting to SQL Server
    A network related or instance-specific error occured while establishing a connetion to SQL Server. The server was not found or was not accessible. Verify that the instance name is corrext an d that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Resolution

  1. Ensure that Server/Instance is correct for DataPlus Server.
  2. Use SQL Authentication (sa:password)
Type: SQL Configuration

    Error
    Error connecting to SQL Server
    Cannot open database "dpS100_ABC2", requested by the login. The login failed. Login failed for user 'domain\username'.

    Resolution

  1. Ensure that DataPlus Database is correct.
  2. Ensure the user has SQL permission to SQL database
    - SQL Security
    - DataPlus SQL Security
Type: SQL Configuration

    Error
    Error saving
    Error Saving Connection Settings: Access to the path 'C:\Program Files (x86)\Hogan Data\DataPlus 4.0\DataPlus-Connection.xml' is denied.

    Reason
    Current Windows user does not have permission to write the the folder.

    Resolution

  1. Run DataPlus 4.0 Configuration 'as administrator'
  2. Give user rights to folder (preferred method)
Type: SQL Configuration

    Error
    Error saving
    Error getting Master Setting: Cannot open database 'dpYourDatabaseName' requested by the login. The login failed. Login for user 'DOMAIN\USER'.

    Reason
    Current Windows user does not have permission to SQL database.

    Resolution

  1. Give user permission to read SQL database
    - SQL Security
    - DataPlus SQL Security
Type: SQL Configuration

    Error
    Unable to connect to database server.
    Reason Given: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server)

    Reason
    Server Settings/Server Name is incorrect

    Resolution

  1. Verify the Server Name and SQL Instance Name
    - Server Name:
    - YOURSERVER\YOURSQLINSTANCE
Type: SQL Configuration

    Error
    Unable to connect to database server.
    Reason Given: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40- Could not open a connection to SQL Server)

    Reason
    Server Settings/Server Name is incorrect

    Resolution

  1. Open Inbound port for SQL on server
Type: SQL Configuration


Related FAQs
Error connecting to SQL Server. A network-related or instance-specific error occured while establishing a connection to SQL server!
DataPlus 4.0, 3.0 Auto Import
DataPlus SQL Security
DataPlus 4.0 FishBowl - Server Installation
DataPlus 4.0 FishBowl - Client Installation
DataPlus 4.0 Fishbowl - Act! Database Configuration

Direct Link to This FAQ
http://kb.hogandata.com/?f=113

Back to Top