Axapta Version - Overview

SQLSYSTEMVARIABLES

When restoring an Axapta 3.0 database from a different server, you might have experienced the following error message:

[Microsoft][ODBC Database Server Driver][SQL Server] Invalid object name ‘SQLSYSTEMVARIABLES’.

The problem is your database user (default bmssa) can not access the SQLSYSTEMVARIABLES table. If the original and new SQL server use the same user id, the following query analyzer command should fix it:

exec sp_change_users_login 'update_one','bmssa','bmssa'

If that doesn’t help or user ids are different, try changing the database and object owners.

exec sp_changedbowner 'bmssa'

changes the owner of the database. I have used this script to change the owner of tables:

DECLARE @oldOwner sysname, @newOwner sysname, @sql varchar(1000)



SELECT

@oldOwner = 'AX30'

, @newOwner = 'bmssa'

, @sql = '

IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES

WHERE

QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''

AND TABLE_SCHEMA = ''' + @oldOwner + '''

)

EXECUTE sp_changeobjectowner ''?'', ''' + @newOwner + ''''



EXECUTE sp_MSforeachtable @sql


And Another one for the views:

DECLARE @oldOwner sysname, @newOwner sysname, @sql varchar(1000)



SELECT

@oldOwner = 'AX30'

, @newOwner = 'bmssa'

, @sql = '

IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.VIEWS

WHERE

QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''

AND TABLE_SCHEMA = ''' + @oldOwner + '''

)

EXECUTE sp_changeobjectowner ''?'', ''' + @newOwner + ''''



EXECUTE sp_MSforeachtable @sql

Problem during Com connector startup

Exact Error Message
"Server process could not be started because the configured identity is incorrect. Check the username and password"

Details:
The error, as displayed in the Figure above, can occur if an incorrect username and/or password have been assigned to the Navision Axapta Business Connector

To resolve this issue, follow the steps below:
1. Click Start > Run, input dcomcnfg in the Open: box and click OK

2. For Windows 2003 and Windows XP
Component Services will open. Expand Component Services > Computers > My Computer > COM+ application

3. Right click AxaptaCOMConnector.Axapta.1 or AxaptaCOMConnector.Axapta2.1 and select Properties

4. select the Identity tab, place the bullet in This user: (if not already), input the correct user name and password. If the correct username already appears, erase what is currently displayed and use the Browse: button to reselect the correct user, and then input the correct password in the Password and Confirm password fields. Finally click Apply and OK

Command-line parameter ... is invalid. Check spelling and start Microsoft Axapta again.

The following error message appeared to a client of me yesterday.

Situation problem:
Axapta is installed on a Server and the client accesses the axapta icons on a shared directory. There was only one user that cannot open axapta. For all the other users was axapta still available.

Solution:
The problem was a security issue linked to the user. The user logged on automatically to the directory with the wrong user name and password. So you have to changes the stored user names and passwords on the computer.

How to Manage Stored User Names and Passwords
To manage stored user names and passwords, follow these steps:

1. Log on to the computer as the user whose account you want to change.
2. Click Start, and then click Control Panel.
3. In Control Panel, click User Accounts under Pick a category to open the User
Accounts dialog box.
4. Open the Stored User Names and Passwords dialog box; to do so, use the
appropriate method:
* If you log on with an account with administrative privileges:
1. Under or pick an account to change, click your user account to
open the What do you want to change about your account? dialog box.
2. Under Related Tasks, click the Manage my network passwords.

Remove an Entry
To remove a credential:

1. In the Stored User Names and Passwords dialog box, click the credential that you want, and then click Remove. The following message is displayed:
The selected logon information will be deleted.
2. Click OK.
3. In the Stored User Names and Passwords dialog box, click Close.