# Epicor 10.1.600.29 get error adding company in admin console **URL:** \ **Category:** Epicor ERP 10\ **Tags:** e10\ **Created:** [September 6, 2018, 4:58pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558 "2018-09-06T16:58:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![dpenn](https://www.epiusers.help/user_avatar/www.epiusers.help/dpenn/32/9690_2.png) [@dpenn](https://www.epiusers.help/u/dpenn)\ **Post date:** [September 6, 2018, 4:58pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/1 "2018-09-06T16:58:16Z")
I’m setting up a test server for 10.1.600.xx . I have added the license but when I try to add the company I get the following error ''Incorrect syntax near the keyword ‘FROM’. I have a call into support but thought I would run it by you guys also. Thanks David ---
**Author:** ![aidacra](https://www.epiusers.help/user_avatar/www.epiusers.help/aidacra/32/17997_2.png) [@aidacra](https://www.epiusers.help/u/aidacra)\ **Post date:** [September 6, 2018, 5:05pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/2 "2018-09-06T17:05:50Z")
1. What is the exact name of your database as shown in SSMS? 2. Which SQL version are you using? ---
**Author:** ![dpenn](https://www.epiusers.help/user_avatar/www.epiusers.help/dpenn/32/9690_2.png) [@dpenn](https://www.epiusers.help/u/dpenn)\ **Post date:** [September 6, 2018, 5:59pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/3 "2018-09-06T17:59:52Z")
The database name is ‘Test’ in SSMS and the sql version is “SqlServer 2014 version 12.0.2000.8 (X64)”. ---
**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\ **Post date:** [September 6, 2018, 9:37pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/4 "2018-09-06T21:37:59Z")
What version are you coming from? I wonder if there is a required extension for the admin console. ---
**Author:** ![Hally](https://www.epiusers.help/user_avatar/www.epiusers.help/hally/32/1263_2.png) [@Hally](https://www.epiusers.help/u/Hally)\ **Post date:** [September 6, 2018, 9:57pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/5 "2018-09-06T21:57:39Z")
Might be worth performing a SQL profiler and trying to add, capture the results and see exactly what the TSQL query is being generated when you add a company. Still not going to help you fix the admin console, but it will surely help Support. I had a sort of similar issue on my test environment. I had 10.1.600 and upgraded to 10.2.100.22. When I tried to register the appservers I got a assembly missing error. I ended up uninstall the new admin console and reinstalling just to the point release, then it was all happy, as soon as I ran the update I got the error again. and sorry @aidacra I have not logged this with support, from my readings It doesn’t seem correct to have 10.1.600 and 10.2.100 appservers running on the same machine. So I didn’t think it merited using up precious resources on this. Apologies for the hijack. ---
**Author:** ![dpenn](https://www.epiusers.help/user_avatar/www.epiusers.help/dpenn/32/9690_2.png) [@dpenn](https://www.epiusers.help/u/dpenn)\ **Post date:** [September 7, 2018, 12:16pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/6 "2018-09-07T12:16:10Z")
We are currently on 10.1.500.27 but this is a new install and I have not brought in a database yet. Not sure if it matters but 10.2.200.8 was running on this system with no issues. I uninstalled it and deleted all the directories before starting the install for 10.1.600. I wonder if there are still some settings pointing to 10.2 and causing some issues? I have tried to uninstall 10.1.600 and all components and reinstall and am getting the same error. This is the sql its having trouble with. ![image](https://epiusers.help/uploads/default/original/2X/3/3e46d7f9b7c797299f376a677d483049f7a615f0.png) ---
**Author:** ![Chris\_Conn](https://www.epiusers.help/user_avatar/www.epiusers.help/chris_conn/32/93797_2.png) [@Chris\_Conn](https://www.epiusers.help/u/Chris_Conn)\ **Post date:** [September 7, 2018, 2:33pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/7 "2018-09-07T14:33:02Z")
If this system is setup for 10.2, it will require an extension for the AdminConsole to work with 10.x ![image](https://epiusers.help/uploads/default/original/2X/c/cd1e54f15a2a06cbb1cb027a1d6b116b2e076ca5.png) ![image](https://epiusers.help/uploads/default/original/2X/e/e3830c67bef6f7e9f38ee1ed81cf430309568612.png) ---
**Author:** ![dpenn](https://www.epiusers.help/user_avatar/www.epiusers.help/dpenn/32/9690_2.png) [@dpenn](https://www.epiusers.help/u/dpenn)\ **Post date:** [September 7, 2018, 2:50pm UTC](https://www.epiusers.help/t/epicor-10-1-600-29-get-error-adding-company-in-admin-console/47558/8 "2018-09-07T14:50:25Z")
Chris thanks for info. I uninstalled all Epicor components and deleted the database. I then did a complete new install and I’m now able to add the company. Not sure what the problem was but its working now. Thanks for all the help everyone. ![image](https://epiusers.help/uploads/default/original/2X/3/3bc598bb02d788d3dc57fe54730d02d9537ca753.png)