Most Recent Posts
Version 12.4
by ChrisFNP - 11/13/2026 9:33 AM
AC Tech Support
by ChrisFNP - 11/09/2026 9:10 AM
Should we delete this
by It's me - 11/05/2026 10:33 PM
Bidirectional api
by It's me - 11/05/2026 10:29 PM
ransomware attack
by It's me - 11/05/2026 10:26 PM
AmazingCharts FHIR server
by scfpmd1955 - 11/04/2026 8:50 AM
ICD-10 codes
by ffac - 11/03/2026 12:26 PM
Working on a few programs
by soloim - 10/27/2026 12:22 PM
Member Spotlight
Ruben
Ruben
Florida
Posts: 141
Joined: February 2014
Newest Members
Stanisierra, NEXCURE MD, peter smith, Christophe1776, Jun Valley Occ H
4,616 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
#21656 06/09/2010 3:02 PM
Joined: Apr 2010
Posts: 6
jpeters Offline OP
Member
OP Offline
Member
Joined: Apr 2010
Posts: 6
Hello, I am a new AC user but have been reading this board for months getting helpful tips and tricks. You all seem like family. We started with AC in Jan. putting patients in. One frustration is not allowing the nurses to put in patient data and sign off on it so they will be in the system. We were trying to get our patients in before we went live. We tried to go live this week and first thing that happened is computers falling off AC. We have about 28 computers with AC and when we all are on we just randomly drop off. I saw a thread addressing that and read it but could not find it this am. But there was no good explanation or way to fix it. We emptied message boxes...no help. We have a main server windows 03. All office computers are windows xp providers are 7. We are really frustrated as this is preventing us from going electronic. Even computers that are shut down at night with AC on still pose problems and we have to preform gymnastics to get them up and running. I am hardly able to see patients because I am always working on a computer to bring it back on..when its fixed anothers down. Our network seems fine and runs medical manager from another server and never had a problem with it. Please give me a quick fix. jpeters from southern WV

Joined: Mar 2005
Posts: 241
Member
Offline
Member
Joined: Mar 2005
Posts: 241
Are they all XP Pro?

There is a limit of networking with regular XP.

Greg

Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
Hi jpeters (first name would be nice)

First, welcome to AC.

OK, for number one, I am not completely sure about the question but if you are saying you want your nurses to enter data like PMH, FH, etc., and sign off so it's already in the chart, then either have them do it under your account or just elevate their privileges to doctor level. As you said, we are a family, and I believe it is all about intent. Licensing is per physician, but I believe physician means a person who is going to see patients and actually be a provider. Temporarily making someone a physician is probably no big deal. Check with Jon on that. I doubt he would care.

On the second part, this has come up about three times on here. I would say that means it is probably happening a lot more. I am convinced after reviewing all these that it is directly related to SQL Server Express and offices with many computers. Yes, Express should be able to handle 28 computers, but that is if the following is true:

The computer which is housing the databases and SQL Server should have at least 2GB of memory, 4GB if possible. Second, the key is what is on the other computer? Is there anything elses utilizing SQL? What applications is it running? Is that computer isolated or being used?

It would be helpful if I knew more about your network. Are you running peer-to-peer or client/server? Are you on a domain? What are you using for a server. What OS are you using? SQL Server Express can handle quite a few computers but that is given that it gets its full allotment of memory. While it gets 1GB of memory if your main machine has 2GB and is using 1.5GB, then SQL is running on 512MBs. The OS alone is going to take up its fair share.

Here's the deal. I have tried to help people with this before (and at the risk of offending someone who has tried to work with my tech buddies -- I haven't heard the outcome), it has been quite frustrating.

I have two guys I use to help me. They are good. One, Raja, remoted into my server the other day to help me with some ICD-9 code issues, and watching him in SQL Server Management Studio was like watching Michaelangelo. An artist. I have taught myself a ton about computers and networking, and I am determined to learn SQL. But, it is an entirely different beast. To work with it, you need a SQL Server expert and a DBA.

I think you will need SQL Server 2005 Workstation or Standard. Yes, it will cost for licenses, but once you have them, you will not have the connectivity issues. Given it has much less issues with the amount of RAM it can use, you will probably want to have a server that can house a lot of RAM. A 32-bit OS is limited to 4GB which is really 3.2GBs. A 64-bit OS can hold up to 64GB of RAM. SBS 2008 on a decent server will give you that capability. 2008 comes with both SQL Servers 2005 and 2008, although you get a license only for one.

Now installing AC to an instance of SQL Server 2005 and 2008 is possible, it isn't necessarily a walk in the park. This is where I would recommend an expert.

You can either utilize the two I mentioned in Experts Exchange (www.experts-exchange.com) which you probably won't, because no one ever does on here, or you can hire them directly.

I know that Raja could likely log in and find out where your performance issue lies. The difference between the other group's method and the one I would recommend is they took forever going back and forth trying to set up a time and a method, when it is probably best to do a few emails and then let the SQL expert remote into your network and look at the setup.

If you are interested at all in trying to fix things, let me know, and I will have Raja email you. I can't guarantee you that he will fix the problem, but I think you will know if SQL Express is the problem.

Meanwhile, if you can give me more specs on your network hardware and software including network switches, cabling, router, Cat5e vs Cat6, etc., it would be helpful.

Thanks.


Bert
Pediatrics
Brewer, Maine

Joined: Aug 2009
Posts: 93
Member
Offline
Member
Joined: Aug 2009
Posts: 93
Nurses can put patient data in. Please make sure you have that set correctly through the admin section.

In our case, the front desk is where all the basic patient data is entered. The nurse station (as we call it) is where the vitals are put in. Health history can also be entered by almost any level person.

The Dr is the only one allowed to sign charts.

Am I correct in all this, Bert?

Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
Hi ANSharda,

At first I was thinking the same thing. And, you are 100% correct with what you are saying in the situation you described. If he is talking about that, then you are spot on.

What I think he may have been talking about is having the nurses take the data from the paper charts from the problem list, let's say, and typing it in. In that case, the only way to save that data would be to sign it off, which the nurses couldn't do without elevated privileges.

Now, the workaround to that which would combine both of our methods (again if I am reading what he is saying -- if it's a he) would be for the nurses to enter all of the PMH, FH, etc. and then forward the chart to the provider who could then open the chart, review it, and sign it off.


Bert
Pediatrics
Brewer, Maine

Joined: Apr 2010
Posts: 6
jpeters Offline OP
Member
OP Offline
Member
Joined: Apr 2010
Posts: 6
Dear Bert, Thank you so much for your prompt reply. My first name is Jana. Nice to meet you. Yes I will give nurses privalages to highest provider to get stuff in. Thanks. We have several providers and buying licenses as money allows. I am going to get our tech person to read your post as you lost me I am not a tech person but I have learned how to turn a computer on!!!!. I am registered for the users conference, so hopefully I can learn something. I am going to turn this post over to out tech person and hopefully u all can resolve the issues. Our laptops for the providers are windows 7. Thanks again. Jana Peters

Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
No problems. I think that originally Jon meant AC to be used for offices of six or less. There is no inherent reason for this to be the case save of the database.

When Access was used, having more providers would have filled the 2GB minimum quickly. Even SQL Express has a maximum of 4GB, if I am correct.

There is no way for Jon to roll out v4 or v5 and expect 2,000 users to go out and buy SQL Server 2005 Standard. First, it is expensive and, second, one would have to have some IT knowledge to install it. It would be the same with Oracle.

I think for those with large practices and computers (especially those who will have many accessing the database frequently -- and have other apps using SQL or memory), it MAY be necessary to use a more robust database. SQL Server 2005 Workstation and others can be trialed, I believe.

My recommendation would be for your IT person to read these. Unless he or she is proficient in SQL, I would highly recommend that he/she get in touch with Raja who is at genius level on Experts-Exchange. It won't cost anything to exchange a few emails.

Nice to meet you as well.


Bert
Pediatrics
Brewer, Maine

Joined: Jun 2010
Posts: 4
Member
Offline
Member
Joined: Jun 2010
Posts: 4
Hello -- I provide technical support for Dr. Jana Peters office. All the desktop computers (clients) are running Windows XP. The laptops are running Windows 7. The Main computer is a dedicated server running Server 2003 with 3GB ram. No one uses the Server and the server has no other functions except to run AC.

Joined: Jun 2010
Posts: 4
Member
Offline
Member
Joined: Jun 2010
Posts: 4
Hi Bert,
My name is Sonya Whitfield and I provided technical support for Dr. Jana Peters Office. I am going to try to address your technical questions.....


The computer which is housing the databases and SQL Server should have at least 2GB of memory, 4GB if possible. Second, the key is what is on the other computer? Is there anything elses utilizing SQL? What applications is it running? Is that computer isolated or being used?

We have a dedicated box that is running Server 2003 and has either 3GB or 4GB of memory.
This box is dedicated to running AC only. It also has the Labcorp interface running on it.
Nothing else SQL is being used. No one uses this computer, it's dedicated to only running the AC db.

It would be helpful if I knew more about your network. Are you running peer-to-peer or client/server? Are you on a domain? What are you using for a server. What OS are you using? SQL Server Express can handle quite a few computers but that is given that it gets its full allotment of memory. While it gets 1GB of memory if your main machine has 2GB and is using 1.5GB, then SQL is running on 512MBs. The OS alone is going to take up its fair share.

We are not on a domain. Just a workgroup where some local printers are shared. The All cat5e running to all the hardwired desktops and server. Desktops are running Windows XP, Server running Server 2003 and laptop are running Windows 7. The server hardware is a Dell Optiplex 755 with a 2.0Gz process with 3gb or 4gb of Ram. We were running on a XP box with 2GB of Ram, 1GB of RAM was consumed by SQL Express. So we upgraded to the newer box (mentioned above). We are running on a Cisco 2950, running a default vlan. Nothing really special to report here. Everything is running at 100mb. We have two WAPs servicing the wireless network. We have Lenovo U350 laptops with N wireless cards.

Here's the deal. I have tried to help people with this before (and at the risk of offending someone who has tried to work with my tech buddies -- I haven't heard the outcome), it has been quite frustrating.

I have two guys I use to help me. They are good. One, Raja, remoted into my server the other day to help me with some ICD-9 code issues, and watching him in SQL Server Management Studio was like watching Michaelangelo. An artist. I have taught myself a ton about computers and networking, and I am determined to learn SQL. But, it is an entirely different beast. To work with it, you need a SQL Server expert and a DBA.

[/i]I think you will need SQL Server 2005 Workstation or Standard. Yes, it will cost for licenses, but once you have them, you will not have the connectivity issues. Given it has much less issues with the amount of RAM it can use, you will probably want to have a server that can house a lot of RAM. A 32-bit OS is limited to 4GB which is really 3.2GBs. A 64-bit OS can hold up to 64GB of RAM. SBS 2008 on a decent server will give you that capability. 2008 comes with both SQL Servers 2005 and 2008, although you get a license only for one.[i]

I will check into getting a FULL version of SQL server. Once we get it will AC help us migrate the DB over to the full version?

]Now installing AC to an instance of SQL Server 2005 and 2008 is possible, it isn't necessarily a walk in the park. This is where I would recommend an expert.

I agree about the expert -- will the AC support folks not help us with this?

You can either utilize the two I mentioned in Experts Exchange (www.experts-exchange.com) which you probably won't, because no one ever does on here, or you can hire them directly.

I know that Raja could likely log in and find out where your performance issue lies. The difference between the other group's method and the one I would recommend is they took forever going back and forth trying to set up a time and a method, when it is probably best to do a few emails and then let the SQL expert remote into your network and look at the setup.

If you are interested at all in trying to fix things, let me know, and I will have Raja email you. I can't guarantee you that he will fix the problem, but I think you will know if SQL Express is the problem.

Meanwhile, if you can give me more specs on your network hardware and software including network switches, cabling, router, Cat5e vs Cat6, etc., it would be helpful.

Specs are listed above....

Thanks,
Sonya Whitfield

Joined: Jun 2009
Posts: 1,811
Member
Offline
Member
Joined: Jun 2009
Posts: 1,811
Another thing to keep in mind since AC uses a network share is how many concurrent users are licensed for the server box. The behavior you described can sometimes be a machine getting refused/dropped because the connection pool is max'ed out.

Variation on the above is the user limit for a share - if someone set a limit on the network share on the server.


Indy
"Boss"

Indy's Blog

www.BestForYourPractice.com
Our Name is Our Creed
Joined: Nov 2006
Posts: 2,084
Member
Offline
Member
Joined: Nov 2006
Posts: 2,084
Quote
how many concurrent users are licensed for the server box

Regarding Windows Server 2003 or 2008 software running on the server, I thought that the number of concurrent licensed users was not "set" in the software, it was on the honor system, in case of an audit.


John
Internal Medicine
Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
Two things here. Let's go back to the concurrent user licenses. From what I understand, I don't think you would drop a connection, the last connection just wouldn't be able to connect. To be honest, IMHO, dynamic licensing is kind of stupid.

Now, John is completely right. And, I wouldn't feel bad Indy, it's a little known fact. They advertise it as license which need to be purchased, and they sell them to you, but they aren't needed. Very strange. And, this was told to me by Microsoft Support themselves. But, it works. I bought them all.

Now, Adobe, that's a different story. They wouldn't let you use their product unlicensed for ten minutes.


Bert
Pediatrics
Brewer, Maine

Joined: Nov 2006
Posts: 2,084
Member
Offline
Member
Joined: Nov 2006
Posts: 2,084
I wasn't encouraging anyone not to buy the appropriate number of user CALs (in case anyone from Microsoft is reading this). wink

All I was saying was, the server software isn't monitoring the number of licenses in use, so that couldn't be the reason for the connection loss.


John
Internal Medicine
Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
Thanks John. You're right. Microsoft is hurting for money, lol. smile


Bert
Pediatrics
Brewer, Maine

Joined: Jun 2010
Posts: 4
Member
Offline
Member
Joined: Jun 2010
Posts: 4
Thanks for all of the replies and the info.
I have access to a DBA where I work
smile

If I can get a copy of SQL Server 2008 -- would that work?
Please look at
http://www.iesofts.com/index.php?main_page=product_info&products_id=37

We can get MS SQL Server 2008 with 10 CAL's (and yes, I read the posts early about CAL's) so no additional CALs should be needed.
We can get this for $798.00

What do you think?

Once I get the SQL Software -- will I need AC Tech Support to help me -- will they supply the SA password? etc?
Thanks,
Sonya

Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
I am assuming you have less than 10 users. If that is the case, why do you have 28 computers? Just wondering.


Bert
Pediatrics
Brewer, Maine

Joined: Apr 2010
Posts: 1,549
Likes: 1
Member
Offline
Member
Joined: Apr 2010
Posts: 1,549
Likes: 1
This may have been more elegantly answered above, but if not...

As I remember when I first installed Server 2003 for our practice management database several years ago, you can choose whether the licenses are counted per individual or per concurrent user. I seem to remember having an issue with this at some point because I believe the default was per individual. I have no recollection of just where that setting lay, just that it was an issue.


David Grauman MD, FACP
Flagstaff, Arizona
Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
No, you can do one or the other. It does see to default to user CALs, but I think that is only because it just kind of talks that way. You should contact Microsoft at the get go. You can mix and match, but they aren't big on that as it gets complicated. It is difficult to change in the middle of the licensing agreement.

I brought up my question, because with 10 CALs being enough for the office, it must be per user. And, the ration of 10 or less users to 28 computers or 1:2.8 or better seems like a lot of computers for each user.


Bert
Pediatrics
Brewer, Maine

Joined: Jun 2010
Posts: 4
Member
Offline
Member
Joined: Jun 2010
Posts: 4
Bert, we have 28 users -- and we would have to purchase more CAL's. I understand this.
I was asking your thoughts specifically about moving to SQL 2008, and if AC tech support would help us with any specific information the DBA would need -- since you've done this already -- I figured you have a some experience in this field.

Thanks,
Sonya

Joined: Sep 2003
Posts: 12,908
Likes: 34
Member
Offline
Member
Joined: Sep 2003
Posts: 12,908
Likes: 34
Well, even though I had SQL Server 2005, I went ahead with the embedded Express. Figured why look for problems. I wouldn't try to install an instance to Standard if Express is already configured. And, I would want to have help.

I guess since your post stated you wouldn't need CALs, I was confused. Given your setup, you can use either device CALs or user CALs. I guess it depends on what you think would increase faster, but additional users may mean additional PCs, although I think device CALs would work the best.

I looked at the site and saw the price. There is a huge difference between Microsoft's store and that one, and Amazon is in between. No suprise about Microsoft, but it's still quite a different.

I supposes skipping to 2008 makes sense. SQL Server Workstation and Standard would certainly work for you, Standard definitely. Workstation's biggest limitation is the 3GB of memory, but that is about it.

I would try to set it up on a non-production server first. I am ignorant as to whether 2008 makes a difference with compatibility.

See PM for further details.


Bert
Pediatrics
Brewer, Maine


Moderated by  ChrisFNP, DocGene, JBS, Wendell365 

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Who's Online Now
0 members (), 1,549 guests, and 93 robots.
Key: Admin, Global Mod, Mod
Top Posters(30 Days)
It's me 10
soloim 2
Top Posters
Bert 12,908
JBS 3,002
Wendell365 2,370
Sandeep 2,316
ryanjo 2,084
Leslie 2,002
Wayne 1,889
This board is dedicated to the memory of Michael "Indy" Astleford. February 6, 1961 -- April 16, 2019




SiteLock
Powered by UBB.threads™ PHP Forum Software 7.7.5