Home > Cannot Open > Cannot Open Sql Server Accpac

Cannot Open Sql Server Accpac

Click Here to join Tek-Tips and talk with other members! Products We Support Sage 300 Sage CRM Sage HRMS Sage FAS Sage Intelligence Sage Enterprise Intelligence Services We Offer Software Selection & Licensing Implementation Customization Support Training Hosting Upgrades Resources Blog smist08 June 21, 2012 at 10:42 pm There is no antivirus, no backup agent and we have disabled oplocks in the registry. Top Of Page | Home Copyright © (2004) PereSoft Software & Support (Pty) Ltd. Source

Since these are Accpac ISAM files, if there are problems with loading custom icons, run ScanIsam to see if there are problems. Citrix 1. If you have not created any data, DataManager can be run and you can put the data straight onto the Network, else copy your data files onto the network. If I just clicked on that I got the error.

The following error message is display: “System error. Share this:TwitterLinkedInFacebookGoogleMoreRedditTumblrDiggPocketPinterest Comments are closed. But say if once we support SQL Server 2010, then you would want that client software installed on every workstation rather than the SQL Server 2008 client installed by 5.6A. We cannot find a solution anywhere on the web or on the Accpac forums.

You can follow the similar steps mentioned above to find the TCP IP pot being used by SQL server you intend to connect if you are not familiar about which port For Pervasive we connect to both the transactional engine using the Pervasive client as well as to the relational engine using ODBC. If you are having trouble signing on, first run DBSpy. Googling any error messages usually yields good clues as to what is going wrong.

This is sometimes caused by one access method not working (usually named pipes) so it tries this first, waits to time out then tries TCP/IP. All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission. b) In the registry under Software|PereSoft|Company Information that the Company name is correct for the server’s registry. So I would strongly recommend you always use the server name in Database Setup to configure your SQL Server companies.

Regards, Daniel Benajmin Daniel Benjamin August 24, 2011 at 10:16 am Reply New operating systems helps. 64 Bit Windows 7 for the workstations and 64 Bit Windows Server 2008R2 for the thanks alot Beckie 25 Jun 2013 6:31 AM Cancel All Responses Answers Only Jay Converse Arxis 25 Jun 2013 9:43 PM In reply to Beckie: Use a subreport, not a This seemed to have stabilised the problem quite a bit as we had fewer of these winuser.ism errors. Another recommendation I’ve heard is to ensure you only use switches and not hubs and to beware that if you are using VOIP that you aren’t saturating your network bandwidth with

Sometimes things like this are caused by bad DNS entries causing network traffic to not route properly. https://sagecity.na.sage.com/support_communities/sage300_erp/f/141/t/67827 To build the sign-on dialog it needs to access the orgs.ism file there which has the list of companies. You could also try removing the references to the JPG files in the ASxxA\eng folder html files. Accpac uses SQL Server in a fairly straight forward manner issuing standard SQL statements without using SQL Server specific modules.

Do you mean that the system hangs up when people sign into the desktop? this contact form Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... Run the Listdll's utility by going into DOS and typing the command Listdlls >filename.prn to place this information into a log format. "Active X component cannot create object" Download the PereSoft If you are running on Terminal Server and have run the Web Deployment Wizard and chosen the DCOM protocol, then you have to run DBSpy (or RVSpy) from the console, they

The ideas of this was to shield the changes to files that one user makes from other users. Create new DSNs on the client you'll use for the next step.4. Once you are done with the above changes run the setup file to install the patches and enter the specific port number. have a peek here As soon as accpac.exe crashes and the winuser.ism is locked up we receive the following logs in Event Viewer: Faulting application name: accpac.exe, version:, time stamp: 0x4df2c9ff Faulting module name:

Related Written by smist08 April 17, 2010 at 8:37 pm Posted in sage 300 Tagged with accpac, database connection, support « Diagnosing Problems Running Accpac Part1 Diagnosing Problems Running Accpac Part3 As we move to the Web, a Web Server will replace the Citrix/Terminal server and then the same advice would apply for the Web Server. When complete, remove or rename the data files on C:\WINACCT. 3.

smist08 September 9, 2011 at 12:06 am Reply Hi Stephen, I know it's a while since this blog, but on reviewing I have a question.

However with the introduction of the SQL Native Client, this wasn’t included in MDAC and now requires the client software be installed. If the signon manager doesn’t run as part of the desktop startup process, you may have a problem with the Accpac COM components. I don't see the red arrow. We have had Sage Africa on site and still no solution.

The login failed. Now that a user is signed-on to a company, Accpac will read the accpacshareddirectory\user\userid\orgid.wsp file. A very common cause of support calls are the result of people running client software that is older than the version of the database server. Check This Out Thanks.

Run ScanIsam to ensure the various ism files are ok. at ACCPAC.Advantage.Server.RemotingManagerService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) Karen April 12, 2012 at 6:37 pm Reply On the web it indiates a permission issue, but I have done the registry suggestions and others The desktop is now ready to start constructing the tree of icons it displays. RE: ACCPAC error cannot open sql server tuba2007 (Programmer) 10 Mar 09 13:36 Must be an RDC session.Set HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\Utilities Interface\Settings\Restricted Access On WTS client to 0 RE: ACCPAC error cannot

Registration on or use of this site constitutes acceptance of our Privacy Policy. Assign the users Domain Admin rights to the program files directory on the server during workstation installation. 3. Accounts Payable and Accounts Receivable Batch Entry - for Posting to AP and AR Trouble Shooting: "Activation code is not correct for Cashbook." Check the following: a) You have the correct This file can be safely deleted and will be re-created when the user next signs on.

For Pervasive problems are often associated with setting up the workstation and server ODBC datasources correctly. The _BIN means that this is a binary sort order where strings will be sorted using a computer binary order, the upshot is that A-Z are before a-z and things like I changed the permissions (My Computer/Properties/COM Security/Launch and Activation Permissions/Edit Default) to add Network Service, restarted and it worked. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.