Single User Mode in NAV 2013 R2

navuser1

Dear All,

I want to set the Live Database to Single User Mode. I have removed all the User from the current DB & tried to set the same from the Developer's Environment but unfortunatelly I have received the error message like that someone is accessing the DB.

I have rechecked the Session windows but have not found any user. :-k

Is the NAV tier accessing the DB ? :-k

What is the reason behind that, kindly inform ?

ara3n

make sure to stop the service tier.

geordie

And if I remember properly there must be no sessions with the database opened with Development Environment as well.

navuser1

ara3n wrote:

make sure to stop the service tier.

Is it possible to compile the object when no service tier is running ?

ara3n

You can compile them but it won't change any table restructuring on sql server.

navuser1

Actually I want to import some objects* into the database then I have to perform few batch process when the system is in single user mode.

* it may change the table definition

mohana_cse06

I guess you can start the service after setting Single User Mode
Do your job and stop the service and change setting to multi user mode and start service again