Concordia Publishing House Forum » Lutheran Service Builder » Ideas for Lutheran Service Builder

Multiple Users

(5 posts)
  • Started 3 years ago by Andrew Jagow
  • Latest reply from Jessica Stromberg

Tags:

No tags yet.

  1. It would be extremely useful to my church if Service Builder could be installed on Bethany's server and then used by multiple users - especially myself and the secretary. While SB-1 had some limited means to do this, SB-2 recommends that we not install it on our server as the process is very complicated. That is a real step back from where we were.

    There are many reasons that installing SB-2 on a server would be more useful to us. With the way Service Builder 2 is set up, it would be ideal for me to begin the process by inputing the necessary data in the create a service mode, but have the secretary finish it off in the bulletin edit mode. Those are nicely divided in SB-2. On a more practical note, the church secretary cannot duplicate the LSB font on her computer when the final bulletins are sent to her for edit and print. On another practical note, storing all the databases on my computer takes up a lot of room.

    In SB-1 the process was that I would go through the necessary steps and then export the Word file to my computer. I would copy the file to the server. Some changes may be made in our worship committee, but the secretary would note those changes and make them herself. It would have been more practical for her to go into Service Builder and re-do the bulletin from there (especially if we had changed a hymn or rearranged the service for some reason), but she could not view that particular service except if she were using my computer. At least, with SB installed on her computer, she could whip up a funeral or wedding service on her own with a little input from me. The biggest pain with SB-1 is that I would spend an hour on the phone with Ryan trying to install the big updates to the software, as that involved a few complicated steps (to me, not to him).

    With SB-2, the door is completely closed. The secretary cannot do any services on her own without SB-1. She has to keep SB-1 on her computer just to use the special font. With SB-2, I see a lot of potential for sharing bulletin-orientated tasks, but that potential will continue to be unrealized until we can get some changes to the software that make it possible for us to see the same services on both our computers.

    I have a hard time believing that we are the only church where the pastor does not do the final editing for the bulletin and the only church that would find making Service Builder accessible to multiple users in the church office a very useful thing.

    Posted 3 years ago #
  2. You *can* do this with Builder 2, but it's moderately complicated and requires editing settings withing SQL Server 2008.

    (Unfortunately, we can't depend on shared Access databases anymore. That functionality isn't supported any longer by Microsoft and it won't even be included in Windows 7.)

    We *do* have plans to make this unbelievably less complicated, but it's going to take us a little while to get there.

    Posted 3 years ago #
  3. BethlehemSG
    Member

    Is there any documentation that you can provide or direct me to on the web (i.e. microsoft.com support) that describes how to set up multiple users to one database? I'm a former IT guy and comfortable with configuring databases. I just don't have the time to research it on my own at this point.

    Posted 2 years ago #
  4. The main thing you'll need to do is download the SQL Server Management Studio Express application from Microsoft. You can get it here:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

    Once you've got that installed, you fire it up and log in to the SQL Server in question. You'll see the structure of your server and databases appear to the right. In order for a user on another computer to link up with the Builder databases, they need to have a user account on the master SQL Server that has enough permission to write to the database. First, you create a user account on the system. This user account can either be set up as a user that already exists on the computer, or you can use the SQL Authentication mode to create a unique username (Builder 2 supports both methods).

    Then, you have to access the user tables for the various Builder database tables and add the user you've created with the proper permissions. Right-click on the LSB databases (you'll see them) to get a context menu with the options you need.

    It's actually quite easy once you get a look at it.

    Once you have the permissions ready, you set up Builder on the second computer. The Setup helper scans your network for available SQL Server installations automatically as part of the installation process. You select the other computer on the network you'd like to link to, and Builder will try automatically to log in with Windows authentication - you can change this using the Advanced settings option.

    Posted 2 years ago #
  5. RE: the LSB font, can you not just copy it from your machine to hers? That is what we have done with the machines here. I have copied the font from my machine and installed it on my personal laptop and the church laptop so I can do updating on the run...

    Posted 2 years ago #

RSS feed for this topic

Reply

You must log in to post.