RSS

Ax error " A user session on the server could not be created. Try to start the client again. If the problem continues contact Ax Administrator

09 Oct

 

 

today we are having trouble with logging onto our Ax system.  The following errors occurs:

A user session on the server could not be created.  Try to start the client again.  If the problem continues contact Ax Administrator

 

this error is coming because of  AOS has no access to createusersessions stored procedure in the database.

 

finally got the conclusion that  the transaction log of the dbase is full, which will cause your login session to fail as well and throw the error

” A user session on the server could not be created. Try to start the client again. If the problem continues contact Ax Administrator”

 

 

the solution of this problem for

 

SQl Server 2008



EXEC sp_helpdb [DatabaseName]
ALTER DATABASE [Database Name] SET RECOVERY SIMPLE
go
DBCC
SHRINKFILE(Database_log)
go
Alter Database [Database Name] Set Recovery Full

EXEC sp_helpdb [DatabaseName]

 

 

SQL Server 2005

USE [DatabaseName];
GO;
SELECT file_id, name FROM
sys.database_files;

Backup log [DatabaseName] with Truncate_only;

DBCC Shrinkfile(DatabaseName_log)

 

SQL SERVER – Find Current Location of Data and Log File of All the Database

SELECT name, physical_name AS current_file_location

FROM sys.master_files

Advertisements
 
4 Comments

Posted by on October 9, 2012 in Microsoft Dynamics AX, SQL SERVER

 

Tags: ,

4 responses to “Ax error " A user session on the server could not be created. Try to start the client again. If the problem continues contact Ax Administrator

  1. Henrik

    September 12, 2015 at 3:06 pm

    Thank you so much for posting this. Our main SQL ran out of disk space on the tempdb-drive because of templog.db. A restart of the server had the templog.db come down again to its initial size, so we’re back online with AX, but we’ll have to investigate what transaction caused the abnormal templog-growth.

     
  2. Ravi Theja Madisetty

    February 15, 2016 at 8:48 am

    Very useful post. In my case sql drive is full.

    Thanks.,
    Ravi Theja Madisetty
    https://techguns.wordpress.com
    https://tech-guns.blogspot.com

     

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: