Home Forums Discussions General Discussion Installing AC and LYTEC on same server machine

This question is to all Techies out here..

Do you think there is any potential of Database (Sql Server) conflict when two saperate softwares i.e. AC (with SQL Express) & Lytec CLient Server version (with SQL desktop) are installed on teh same server machine?

I am not sure but is this even possible to install two of these on the same machine when these use the same database? I am just tryng to figure out if I should install these on the same machine or should I have individually dedicated machines? Your comments are appreciated greatly...Thanks!

The background story for this situation is that AC is far away from coming up with PM module and it was getting out of hand to manage accounts in Quickbooks. Coincidently a good deal came in my way that I couldn't refuse. A local Ortho had paid for the new Lytec Medical 2009 before he found out that he was gonna close his practice to join an established group out of state. He had paid $4K for 5 user C/S version that I am getting for 2K. I am not planning to link AC with Lytec using X-link though.

HO,

There are many applications which use SQL as their database engine and databases. It would be fairly expensive and complicated to run different machines just to keep them separated.

Yes, you can run multiple application using SQL Server on the same machine.

Basically, you are installing multiple instances of SQL Server to host the databases of the application. The first Server will, by default, have the name of the server as its instance name. Subsequent SQL Servers which will run in isolationg of the other Server will be named differently possibly with an added $.

It also would be helpful to know your OS and if it is already running its version of SQL Server.

HealthObama, the best possible scenario is that you only have a single instance of SQL Server installed. An Instance of SQL Server can "contain/hold" multiple databases. There should never be a need for each application that has a SQL Server Database to install it's own instance. The end result, of running mult8iple server instances will be a negative impact on performance.

I agree with that. But, you do agree he certainly doesn't need multiple "servers" to install multiple programs.

Yes Bert, I agree, 1 Server (machine) running 1 instance of SQL Server (Software) with multiple databases.

Thank you guys for your reply.

I had the same understanding but just wanted to rule out any potential issues that may arise.

Do you guys have any suggesstions or recommendations for a Server machine? i.e. the outlet to purchase, or minimum configuration, RAID or no RAID, or RAID 1 or 5, etc etc.?

OB

I bought mine directly from Dell. Used HP before. They are all pretty good. As far as RAID, I would highly recommend it. If 10 people comment on here, you will get 10 different answers. I personally use RAID1 for OS and RAID5 for data, but you can do it a lot of ways. The easiest setup is probably just plain old RAID5. RAID10 or 1 + 0 is pretty dependable as well. Tons of good websites on it. In the end, you can't go wrong with 1, 5, 10 or RAID1 combined with RAID5 or RAID10. RAID0 would be about your only dumb choice. RAID6 is even pretty good.

See only one person, and you already have seven or more answers, lol.

I bought a decent server from tigerdirect.com. Has faired well and I have always got fairly decent customer service with good prices.

OK, so call me stupid but I still have a question. I also run billing software on a full SQL database. I am getting ready to upgrade to V4. Do I need to do anything special or different or simply follow the upgrade instructions?

Leslie

Nothing special. I believe V4 installs an instance of SQLExpress, even IF you have a full SQL Server.

George is correct. I would just follow the prompts. And, believe me, there are people who devote their entire lives to OS and SQL and still have these questions.

Remember, it stands for Structured Query Language. Nuff said. But, PLEASE, back up your server first. There are even programs such as Backup Assist (you have to purchase an extra module -- get the trial if possible) which backs up your SQL Servers.

But, bottom line, install V4 and go from there.

Leslie, you have to get VM. Then you could install it to your regular computer. Do a snapshot. Then install to your heart's content. Screw it over. Go to previous snapshot. Do it again. Rinse, repeat.

HO,

I belive you could spec out a Dell server and possibly get it cheaper at New Egg, etc., but I can't say enough for buying a server directly from Dell or buying a Dell or HP with a three year on site warranty. The support I get from Dell is beyond great and, if your server goes down and you have no idea why, it is nice to have a Dell support tech or HP support tech at your office in the specified time in your warranty with the parts to fix it. That happened to me last year, and the guy was here in under three hours, installed a new RAID card, and the server was up and running by lunch time.

I don't know...it's up to you. I don't know, Steven may have a good setup with support, but I really don't feel comfortable with a purchase from one place and a warranty from another.

Again, Steven, may have purchased a Dell server and got a warranty through Dell. I know there are all sorts of 3rd party servers; some build their own. But, from my perspective, and I am not a built it myself expert, Dell and HP are kind of the industry standard. Especially in your situation given you are asking this question.

Steven,

What was the brand of the server?

Built my own.

Dual AMD Opteron CPUs
8GB RAM (up to 32)
4X 750GB HDD RAID 5 Hot Swappable
Windows Server 2008

Price 2400.

With all due respect to HealthObama, do you really think he is going to want to build his own. Go out and buy a motherboard, etc. etc. I could get him one for $3400. Yes a thousand more, but it will have the right mobo, the right RAID controller, the OS installed and partitioned. The RAID set up, the CPUs installed, the correct amount of RAM, the correct RAM.

I think Steven and you and I and Vince, etc. can build their own, but I don't think that is what HO is looking for.

I bought a visionman server, but I have heard that the Dell servers direct from Dell are pretty turnkey. I would think the best way to go for HO would be one that is fully configured and outfitted with server software from someone like Dell or HP.

Thanks for the info!

leslie

Thank you all for the info and recommendations..

Love the contrarions' debate that gets on almost every post on this board.

Bert is right, I am not looking to spend(waste) time to buy pieces to put together later, though I can when I am in mood. I have done that for desktops.

HOB

Say George, how much is support on that server?

Ha ha. Just joking. Haven't had my coffee yet.

Wayne because all the components were so inexpensive, I bought 2 Motherboards, one as a spare. So I will be able to swap it out should there be a problem.

I have AZ and LYTEC 08 installed on same server. I use Xlink (installed as required on different computer than lytec/AZ server) to export billing data from AZ to Lytec since Feb 09. This all is working fine after minor initial hiccups.