Quickbooks Network And Database Security Problem

Nairaland Forum | Technology | Computers (Moderators: uspry1, Dual Core) | Quickbooks Network And Database Security Problem

Pages: (1)

Author

Topic: Quickbooks Network And Database Security Problem (Read 358 views)

bisifunke

Quickbooks Network And Database Security Problem

« on: November 08, 2007, 02:50 PM »

I have an existing structured network in my company. The Account Dept introduced software QuickBooks which will be installed in a pavilion HP server and 5 intending PC to be connected to it.

The issue is- Only the Acct. dept is authorized to have access to the database. How do I do the configuration? Create an Active directory? Which I only new little about ? OR ……. Gurus please help.

Maleeq (m)

Re: Network And Database Problem

« #1 on: November 08, 2007, 03:41 PM »

Are you trying to restrict access to that server completely to those not in the Account Department? or do you just want to restrict access to the account software's database?

For the former, setting the users' access rights on the server would do the trick(assuming you have Active Directory up and running already). But for the latter case, I guess the account software has some sort of interface where you would be required to enter certain credentials(username and/or password) to gain access? Then, simply give/create user profiles for the account department's personnels.

If I am missing some information(~~which you did not clearly state~~), let me know.

bisifunke

Re: Quickbooks Network And Database Security Problem

« #2 on: November 08, 2007, 04:15 PM »

Maleeq u allready knw what i want my guru. I want to restrict the software to only Acct Dept.
How do I go If I decided to use Active directory.?
The software have user password and log in. Even with that how do i achiev that on the network. having created the username and password on the software ?

bisifunke

Re: Quickbooks Network And Database Security Problem

« #3 on: November 09, 2007, 01:10 PM »

Gurus please contribute it is very urgent and i need it to keep my job ontop

Maleeq (m)

Re: Quickbooks Network And Database Security Problem

« #4 on: November 09, 2007, 01:24 PM »

Sorry for not replying since yesterdaygot some stuff on my mind here.

Well, the truth is, Quickbooks is not an everyday application everybody has experience on(atleast, I don't Grin

).
I understand what you are tryin to do but you have to understand that you need to provide more information:

1 - Is the application web-based or simply a desktop application.
2 - Does it natively support multi-user with simultaneous log in?

If you answer NO to #2, then its not possible to achieve what you want. because, only one of the intended 5 users would have access to the software no matter what you do!.

In short, read the manual of the application. If it has support for multi-user(client-server scenario), it's setup would be clearly stated. That way, user's you want to give access to would just be assigned a profile.

Otherwise, its going to be almost impractical to achieve what you desire.

temileke (m)

Re: Quickbooks Network And Database Security Problem

« #5 on: November 09, 2007, 01:50 PM »

Yes, i agree with maleeq on the issue. I guess you have lately studied some stuff on Windows Server applications and you are looking for a way of promoting an active directory for the application.

1. If the accounting application is not a web based application and does not support client-server interface, then its a no go area.

What you wanted are:

a. Create active directory so that you can manage their user accounts
b. Customise each user to a computer accounts
c. Grant permissions / access to users based on company's policy.
d. Probably thinking of backing up your database in case of crash etc.

For you to do this, ensure the program is a web based application and ensure it can work with windows server. if yes. then install the application in Win ser and grant the permission in active directory to only the selected accounts staff. so you can go on from there.

You need to get Win Server 2003 Enterprise edition. Its not cheap o! take good care

bisifunke

Re: Quickbooks Network And Database Security Problem

« #6 on: November 09, 2007, 04:03 PM »

Thanks Guys, Quickbooks support Multi-user and single user. It is compatible with windows. it is an application that is installed on a desktop pc. net a web base stuff.
Thanks Temileke those are the things I want to achieve How would I configure that having in my that i hve a network runing with dhcp server.

bisifunke

Re: Quickbooks Network And Database Security Problem

« #7 on: November 12, 2007, 10:52 AM »

Guys I hope u hv a wonderful wkend. I need more contribution on this thread. enjoy!!!!!

Guardian (m)

Re: Quickbooks Network And Database Security Problem

« #8 on: July 23, 2008, 12:31 PM »

Dear, so sorry u have been here so long with no positive solution, I came across your post by chance. Well, I have setup QuickBooks in difference environments and platforms, successfully.

If you need help setting up Quickbooks hala me here.

Engineers In The House Pls Kindly Take A Look At This: Keyboard And Mouse Problems I Need A Application Or Code To Hide My Ip Help Me Please? Page 2

Pages: (1)