Hi I have installed Axapta 3.0 in Windows 2003 server using domain controller. Also i have installed the SQL 2000 with Service pack 4. After the configuration of the database and login details. The service is not getting started. The service which is showing in Windows services is showing the status as started. But if checked through Control Panel- Navision Axapta Object Server option, the Object Servers Status is showing stopped. I have tried different ways but the service is not getting started. Can anyone help me out, where i have missed the configuration. Regards Srini
Dear Srinivasan R,
I have the same problem on my installation also. Have you find thte answer or resolved it… or else clear me one thing, can we use Windows authentication in axapta 3.0 or we can use SQL authentication only. Kindly confirm and get back to me soon.
Hello,
Are there any entries in event viewer of AOS or SQL Server? If there are, please can you post them here.
Thanks,
When i try to connect three tier architecture, the following error showed in SQL server
"Object Server AOS1: Fatal SQL condition during login. Error message: “[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘EAPLERP\AOSADMIN’. The user is not associated with a trusted SQL Server connection.”
After that i hv changed to Mixed Mode Authentication and tried the following error occured, and i dont know what is the data source name for SQL 2000 Server instance,
“Object Server AOS1: SQL diagnostics: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Connect information was: Userid = [sa], Database = [AXDB], Server = [EAPL-E04S\SQL2000], DSN = [LocalServer], Other = []”
After that i tried to install SP4 and SP5 axapta 3.0 sp3. and then it is asking for username and password. Whatever username or password i am giving it is not accepting. and it is displaying that “User does not exist, Enter a valid username and password, Only users registered with Microsoft Business Solutions Axapta can be used”
Kindly give your suggestions on this,
regs,
george
Hai Harish,and in event viewer the following message also apperas,
When i try to connect three tier architecture, the following error showed in SQL server
"Object Server AOS1: Fatal SQL condition during login. Error message: “[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ‘EAPLERP\AOSADMIN’. The user is not associated with a trusted SQL Server connection.”“Object Server AOS1: SQL diagnostics: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. Connect information was: Userid = [sa], Database = [AXDB], Server = [EAPL-E04S\SQL2000], DSN = [LocalServer], Other = []”
After that i hv changed to Mixed Mode Authentication and tried the following error occured, and i dont know what is the data source name for SQL 2000 Server instance,
After that i tried to install SP4 and SP5 axapta 3.0 sp3. and then it is asking for username and password. Whatever username or password i am giving it is not accepting. and it is displaying that “User does not exist, Enter a valid username and password, Only users registered with Microsoft Business Solutions Axapta can be used”
The description for Event ID ( 182 ) in Source ( Axapta Client ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .
Kindly give your suggestions on this,
Hello,
Essentially it looks you have multiple issues. The second issue ‘user does not exist …’ is straight forward. As the error message states the login you are using does not exist in Ax. To resolve this do the following -
- In SQL Server, connect to Ax database
- Open ‘USERINFO’ table. This table will have list of all Ax users.
- And use an user from this table to log into Ax. Important thing to check is whether the user is enabled or not. The field ‘ENABLE’ should have 1 against the user.
Hope this works,
Harish
Dear Harish,
You gave me a good suggession. I have checked My Database created in SQL 2005 (For axapta 3.0), BUT there is no users available in the database.
I have installed one Database in SQL 2000 also, but there i dont find the table ‘USERINFO’ there. How do i create users in the database. I dont have any previous databases with users table ‘USERINFO’.
Kindly send your valuable suggestion.
Regs,
George
Hello,
Perhaps you might want to stick with one database. My preference would be SQL Server 2005.
My question is - how did you install Ax in the first case? Because when you start Ax for the first time, it will automatically assign this user as ‘administrator’.
Any way, in USERINFO table (SQL Server 2005), create a new record and use that login to log into Ax.
Regards,
Dear Harish,
I have created a New SQL 205 database using MSDE setup of Axapta 3.0 and attached to SQL 2005 server.
I have been found an user in USRINFO table, with ID = Admin and NAME = Administrator and No Password.
But when i give the user as Administrator and blank password it says password is incorrect. So i manually entered the password in SQL 2005 User info Table and tried with that password then also the same error appears.
My windows login is eaplerp\george and password = PASSWORD. is the windows login relates anything.
When i start the Axapta Object Server in the AOS is started and stopped. when i go to event viewer the following message shown,
Object Server Axapta: Fatal SQL condition during login. Error message: “The internal system table version number stored in the database is higher than the version supported by the kernel (31/30). Use a newer Microsoft Business Solutions-Axapta kernel, or start Microsoft Axapta using the -REPAIR command line parameter to enforce synchronization.”
Kindly give me your suggestions,
Regs
george
Hello,
You get this error because as the message indicates there is a mismatch between Ax kernel version and SQL server. It looks you are trying to attach an already existing SQL database.
- Create new empty database.
- Attach this database through server configuration utility and start AOS.
Regards,
Hi
I need a help, in my Windows Server 2008/SQL 2005 the Axapta 3.0 is working fine with one AOS instance. i wanted to configure one more AOS instance on the same server. Can i get a help or any document steps available for this.
Thanks & Regards
Srini