Trying To Install Small Business Accounting 2006 On SBS 2003 PLZ H

Discussion in 'Windows Small Business Server' started by Chris Voicu, Feb 1, 2006.

  1. Chris Voicu

    Chris Voicu Guest

    I have been trying to install small business accounting and I followed
    the step by step procedure on how to install it from the Microsoft web site
    quoted below. I got to the final steps on accessing the database from client
    computer; however, I keep getting an error that says, "The company database
    that you requested could not be opened. Use the data utilities to ensure that
    the database exists and that it is attached to the server." This however is
    false because I can access the file from the server, just not the client
    computer. If it was not attached I wouldnt be able to access it from the
    server either. Plz help me figure this out. I really need MSBA, and I am not
    sure what I must do to access it from client computer. Any help will be
    appreciated.
    Thanks
    Chris Voicu
    "
    To set up a Small Business Accounting security group in Windows SBS
    1. Log on as an administrator to the computer running Windows SBS.
    2. Click Start, and then click Server Management.
    3. In the console tree, click Security Groups.
    4. In the details pane, click Add a Security Group. The Security Group
    Wizard opens.
    5. On the Security Group Information page, do the following:
    a. In the Name of the Security Group text box, type SBA Users Group.
    b. In the Description text box, type Small Business Accounting Security Group.
    c. Click Next.
    6. On the Group Membership page, do the following:
    a. In the Users and Groups column, double-click all user accounts that you
    want to access the Small Business Accounting database.
    b. Assure that all appropriate individual user accounts are listed in the
    Members of this Security Group column.
    c. Click Next.
    7. Click Finish.


    To set up a Small Business Accounting shared folder in Windows SBS
    1. Click Start, and then click Server Management.
    2. In the console tree, click Shares (Local).
    3. In the details pane, click Add a Shared Folder. The Share a Folder Wizard
    opens.
    4. On the Folder Path page, do the following:
    a. Click Browse.
    b. On the Browse for Folder page, click the drive and/or folder where you
    keep your shared data, and then click Make New Folder. Small Business
    Accounting does not require that the database file be located in a specific
    folder or on a specific drive. The important thing is that the users know
    where they can access the shared folder.
    c. New Folder is highlighted in the upper window. Type SBA Database as the
    name of the new folder, and then click OK.
    d. Click Next on the Folder Path page.
    5. On the Name, Description, and Settings page, click Change.
    6. On the Offline Settings page, click Files or programs from the share will
    not be available offline, and then click OK.
    7. On the Permissions page, select the Use custom share and folder
    permissions, and then click Customize.
    8. In the Customize Permission dialog box, click Remove to delete the
    Everyone group, and then click Add.
    9. On the Select Users, Computers, or Groups dialog box, do the following:
    a. Click Advanced, and then click Find Now.
    b. Scroll down, and then click SBA User Group.
    c. Click OK, and then click OK again.
    10. On the Customize Permission dialog box, under Permissions for SBA User
    Group, select the Change checkbox in the Allow column, and then click OK.
    11. Click Finish, and then click Close.

    Step 2: Set Up Small Business Accounting on the Server

    To install and set up Small Business Accounting
    1. Log on as an administrator to the computer running Windows SBS.
    2. Install Small Business Accounting on your server, following the
    instructions provided with the software.
    3. Open Small Business Accounting, and then run the Small Business
    Accounting Startup Wizard. When prompted for where to save the Small Business
    Accounting database, browse to the SBA Database shared folder that you
    created in "Step 1: Set Up a Security Group and Shared Folder for Small
    Business Accounting in Windows SBS."
    Important
    Make sure you save your company's file in the SBA Database shared folder
    that you created earlier in this document. By default, Small Business
    Accounting sets up a Small Business Accounting folder in My Documents, which
    only the administrator can access.
    Important
    It is recommended that users not log on locally to Windows SBS in order to
    access Small Business Accounting to perform daily tasks. After Small Business
    Accounting has been successfully set up on the server, all Small Business
    Accounting tasks should be performed from a client computer.

    To associate TCP/IP Port 56183 with Small Business Accounting

    1. From the Start menu, click Run.
    2. In the Run dialog box, type svrnetcn, and then click OK. The SQL Server
    Network Utility dialog box opens.
    3. In the Instance(s) on this server drop-down box, click MICROSOFTSMLBIZ.
    4. In the Disabled Protocols section, select TCP/IP, and then click Enable.
    5. In the Enabled Protocols section, select TCP/IP, and then click
    Properties. The <ServerName>\MICROSOFTSMLBIZ - TCP/IP dialog box opens.
    6. Enter 56183 in the Default Port text box, and then click OK to confirm.
    7. In the SQL Server Network Utility dialog box, click OK.
    8. Click OK in the SQL Server Network Utility alert box.

    To restart the SQL service

    1. From the Start menu, click Run.
    2. In the Run dialog box, type services.msc, and then click OK. The Services
    window opens.
    3. In the details pane, scroll down and click MSSQL$MICROSOFTSMLBIZ.
    Additional options become available in the details pane.
    4. Click Stop the Service. When the Service Control box closes, the service
    has been stopped.
    5. Click Start the service on the details pane. When the Service Control box
    closes, the service has been restarted.
    6. Close the Services window.
    To rebuild the Small Business Accounting database
    1. Open your company's file in the shared SBA Database folder using Small
    Business Accounting.
    2. Click File, click Utilities, and then click Data Utilities. The Small
    Business Accounting Data Tools dialog box opens.
    3. Under Rebuild Company File, click Rebuild. The Rebuild Company File
    dialog box opens.
    4. Click your database file, and then click Rebuild. The Select Company File
    dialog box opens.
    5. You must provide a new name for your company database file. Give it a
    unique name that you will recognize, and then click Save.
    6. On the Small Business Accounting dialog box, click OK.
    7. On the Rebuild Company File dialog box, click Close.
    8. On the Small Business Accounting Data Tools dialog box, click Close.
    Next, you set up all of the Small Business Accounting users in the company
    database.

    To create Small Business Accounting users

    1. In Small Business Accounting, click File, and then click Manage Users. Do
    not select Multi-user Settings.
    2. On the Manage Users page, click Select.
    3. On the Small Business Accounting User dialog box, click Select User.
    4. On the Select User dialog box, click Locations.
    5. In the Locations dialog box, double-click Entire Directory, click your
    domain name, and then click OK.
    6. In the Select User dialog box, click Advanced, and then click Find Now.
    7. Scroll down, and then click an individual user account.
    8. Click OK, and then click OK again.
    9. In the Small Business Accounting User dialog box, click Next.
    10. Select the User role in the drop-down box, and then click Finish.
    11. Repeat steps 2-10 of this procedure until all users who require access
    to the Small Business Accounting database have been added, and then click
    Close.
    Step 3: Set Up Client Computers to Use Small Business Accounting
    For the following procedure to be performed successfully, the client
    computer must be a member of the organization's domain.

    To set up Small Business Accounting on client computers [STUCK HERE]

    1. Install Small Business Accounting on each client computer.
    2. Start Small Business Accounting on a client.
    3. Click File, and then click Open Company.
    4. Click the down arrow in the Look in: box, and then click My Network Places.
    5. Double-click to open Entire Network.
    6. Double-click to open Microsoft Windows Network.
    7. Double-click to open your domain.
    8. Double-click the name of your server.
    9. Double-click to open the SBA Database shared folder.
    10. Double-click to open your company's Small Business Accounting database
    file.
    "
     
    Chris Voicu, Feb 1, 2006
    #1
    1. Advertisements

  2. Firewall enabled on the local workstations? ... it should poke the
    hole it needs in port 56183 but you might want to temp disable it just
    to rule that out.

     
    Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP], Feb 3, 2006
    #2
    1. Advertisements

  3. Chris Voicu

    dsatchell Guest

    Did you end up getting this to work and did you use SQL2005?

    David.

     
    dsatchell, May 9, 2006
    #3
  4. Chris Voicu

    SMiano Guest

    Out of curiosity...

    I ran into this before on a test setup, and now we are setting SBA on
    SBS2003 for real. When I try and turn on multi user settings, SBA crashes
    out. Last time it had something to do with sharepoint, but I cant find my
    docs from that implementation. Does anyone have any ideas? When I spoke to
    the MS support rep he said this was common, but I cant seem to find any
    reference to it.

    :-\
    Stephen

     
    SMiano, May 30, 2006
    #4
  5. see if this doesn't help

    http://www.microsoft.com/downloads/...F3-B626-4264-AF3E-8C4F190CAA69&displaylang=en
     
    Cris Hanna [SBS-MVP], May 30, 2006
    #5
  6. I'm getting tired of your bottom posting, Cris ;-). My mouse wheel is
    getting hot.

    --
    Les Connor [SBS Community Member - SBS MVP]
    -----------------------------------------------------------
    SBS Rocks !
    ----------------------
    "Tell me and I'll forget. Show me and I'll remember. Involve me and I'll
    understand." - Confucius


     
    Les Connor [SBS Community Member - SBS MVP], May 30, 2006
    #6
  7. Chris Voicu

    SMiano Guest

    I'm able to add users on the server using the workaround in the original
    post. (FYI: I've been working off the SBAandSBS document version 1.1)

    When I try to connect from a client PC I get:

    "SQL Server does not exist, the service is stopped, or access is denied."

    *shrug* Any ideas?
    Stephen

     
    SMiano, May 30, 2006
    #7
  8. Chris Voicu

    SMiano Guest

    I'm still pretty much dead in the water... Any advice would be greatly
    appreciated.

    I've walked through the SBS and SBA Whitepaper step by step but I cannot get
    workstations to connect to the server. I suspect I'm missing a step, and am
    preparing to unistall the whole thing, and start over. Is there an
    installation support number that we have access to as partners? A lot of
    people are referencing some tricks they learned at TS2 events, but noone's
    talking about them. I'm eager to learn how to deploy this in an SBS
    environment so I can present it as a solution to existing and potential
    clients.

    We're running SBS2003 without ISA. Sharepoint services are installed and in
    use.
    Clients are all WinXP Pro SP2

     
    SMiano, Jun 5, 2006
    #8
  9. Chris Voicu

    SMiano Guest

    Yes. The workstations have been part of the SBS domain for months. Everything
    else functions properly (insofar as I can tell). We've been running off this
    server for months with no issues.

     
    SMiano, Jun 5, 2006
    #9
  10. Chris Voicu

    GeoffM Guest

    So far I haven't seen any resolutions but I'm working on it, I've got pass
    the initial connection error's (not finding the database) and down to;
    "The company database that you requested could not be opened. Use the data
    utilities to ensure that the database exists and that it is attached to the
    server."

    Course I'm haveing issues with Windows Firewall and IPNat.dll (won't start,
    ICS that is) But I don't think that's the issue since a telnet (run > cmd>
    telnet <Servername> 56183 ) from the client machine returns an open port
    (blinking cursor) All the White Papers have been followed and frankly I'm a
    bit taken back by the Issues with SBA and SBS (Not to mention BCM) not using
    the SQL Server (for those that have Premium) I would love to sell this to my
    SBS clients but this is by far beyond the need for built in extra hour
    billing Hyped up SB Product's should be thourghly test for the most common
    senerio's(I'm using my ActionPack to configure and test though I doubt
    there's a version differance)

     
    GeoffM, Jul 14, 2006
    #10
  11. Chris Voicu

    SMiano Guest

    Geoff,

    Just an update for you...

    We've been able to sucessfully install SBA on SBS four times, but we did it
    using an amalgamated version of the white paper, plus some instructions
    previously listed in this post. One common factor in all sucessful installs
    was that we setup a VIRGIN Small Business Server Install... then Installed
    SQL2004, SQL2000SP4, then ISA 2004. After making sure sharepoint "companyweb"
    loaded into Internet Explorer we then installed Small Business Accounting. We
    followed the V1.1 whitepaper instructions, until we reached a point where we
    opened port 56183 (not listed in the whitepaper).

    On a side note, we never got SBA to run on our existing server. In
    desperation, we nuked it.

    The moral of this story is to sell at least ONE copy of SBA with your server
    implements, and install it when you are setting the server up initially.
    Whether they use it or not is up to them. But if you put the infrastructure
    in place when you build the server OS, you're golden. Not the best solution
    in my opinion, but its the conclusion we've arrived at.

    Email me at my display name at MianoVision dot com and I'll see if I can't
    send you out our revised howto. I'd love for you to test it out in your
    sandbox. :)

    Stephen

     
    SMiano, Jul 15, 2006
    #11
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.