Problem in logging in Navision database

Business Central/NAV Technical Forum
1

Hello Experts,

I have Nav 2009sp1 installation and sql server 2008 running on same machine.
Yesterday while trying to make some changes in navigation pane i got an error that i don’t have user rights to do so.I was logged in on nav 2009 sp1 classic client with windows authentication. I was a super user and hence had all rights. I tried to check on database login on nav and by mistake changed the role to super(Navipane).

Now the problem is when i try to login i cannot see anything in object designer. and i only have rights to make changes in navigation pane. Can you please suggest me if there is any way i could correct this mistake and change my role back to super.

Thanks in advance

2

Hi,

Try login using Sql server username and Password

3

Hi amol…

Thanks for the answer.But i tried that and it is not working. It still gives an error.

6403.Error.JPG
6403.Error.JPG905×341 40.8 KB

4

super(Navipane) is a role for navigation pane only…except this you will have a super user of database…

5

Thanks mohana for the reply.

But i was the only user.I tried some more changes and now somehow suceeded in opening the database with SQL authentication as suggested by Amol.

Now i am extracting all the changed files from my last backup and will try to restore the fob in new database.

PS. after creating a new account in SQL database with admin rights i successfully opened my database and now i can even reverse back the role of my username in windows authentication.

Thanks both of you for help