Single User Mode in NAV 2013 R2

navuser1 · 2014-07-22

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 · 2014-07-22

make sure to stop the service tier.

geordie · 2014-07-22

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

navuser1 · 2014-08-09

ara3n wrote:

make sure to stop the service tier.

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

ara3n · 2014-08-09

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

navuser1 · 2014-08-10

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 · 2014-08-10

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

Howdy, Stranger!

Quick Links

Categories

Single User Mode in NAV 2013 R2

Comments