Microsoft Dynamics Support Forum Index Microsoft Dynamics Support
Visit the Microsoft Dynamics newsgroups and exchange ideas with a community of business professionals and product experts from around the globe.
 
   ProfileProfile   Log in to check your private messagesLog in to check your private messages  |  FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups Log inLog in   RegisterRegister 

Using MSOA with a Server - howto

 
Post new topic   Reply to topic    Microsoft Dynamics Support Forum Index -> Microsoft Office Small Business Accounting Development
Author Message
mcair
Guest
PostPosted: Sat Apr 26, 2008 6:40 am    Post subject: Using MSOA with a Server - howto Reply with quote
After many hours of frustration, I have figured out the basics for deploying
and MSOA database to a server running SQL2005 and connecting client machines.

1. Create database on a client machine that has SQLExpress installed locally.
2. Detach database
3. Copy .sbd file to server and attach
4. Create AD user group; add MSOA users; give this group dbowner rights in
the attached database
5. In Sql Configuration Manager, add port 5356 to the existing 1433
6. Copy .sbc file to a network share
7. Edit .sbc file. The format is:

database=<MSOAdatabase>
server=<servername>\MSSQLSERVER

note: forget specifying a port number. MSOA uses 5356 regardless.

8. If the server is running SQL2005 standard or above, create nightly backup
job

You are done. The database is on a server, secure, backed up reliably and
not leaving the building.
Back to top


Display posts from previous:   
Post new topic   Reply to topic    Microsoft Dynamics Support Forum Index -> Microsoft Office Small Business Accounting Development All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group
eXTReMe Tracker