Windows Authentication not working on SQL 2005

jdavis

Hi All-

I am in the process of converting from the proprietary db to SQL Server 2005. We are running NAV 4.0 SP1.

I added the xp_ndo_enumusersids and xp_ndo_enumusergroups extended stored procedures. With EXEC permissions to public & guest.

I create a new database using the SA account.

I go to security and add a windows user with super role and sync security.

I then open a seperate Navision instance and try to connect with windows authentication and get an invalid username/password combination error.

Am I missing any steps? This is the first time I have tried this on SQL 2005 so I'm not sure if I am missing anything.

Thanks in advance!

ara3n

I would not recommend using sp1 with sql 2k5. Please get the sp3 executables.

nunomaia

SQL Server 2005 with any version below Navision 4.0 SP3 isn’t recommended, you will have problems with security model from sql and other stuff.

jdavis

That worked! Thanks for the help. Is there an SP3 for the NAS or will the SP1 NAS work fine?

nunomaia

NAS must be the same version of navision client, in your current case SP3

andy76

Good morning,

I don't have a lot of experience with SQL 2005 setup, better for SQL 2000.

I would like to know if there are some special settings to remember for an installation of SQL 2005 for Navision 4.0 and where I can find them.
For Example, which is the right collation?

Thank you

Andrea

nunomaia

In Client CD, there is a document about installing Navision in SQL Server

andy76

Do you mean this document: Installation & System Management SQL Server Option.pdf - 13.09.2004?
Or there is a new one?
In the one that I have there is nothing about version 2005 of SQL Server

andy76

Hello,

I have the following message when I log in in NAV5.0 with SQL Server 2005 with windows authentication in the case the Windows User has not SUPER role.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The select permission was denied on the object 'MYDB$License Agreement', database 'MYDB', schema 'dbo'.

Thank you very much

Andrea

andy76

I inform you that if to the same user I add the role super I don't have this message and it works fine.

NAV5.00 CH

I am quite new to Navision but it would seem that for SQL I have to add some particular role : ALL and P&P-VENDOR are not enought?

Thank you

Andy

kriki

andy76 wrote:

Hello,

I have the following message when I log in in NAV5.0 with SQL Server 2005 with windows authentication in the case the Windows User has not SUPER role.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The select permission was denied on the object 'MYDB$License Agreement', database 'MYDB', schema 'dbo'.

Thank you very much

Andrea

[Topic closed (andy76 created a new topic with same posting AND this topic is marked solved)]
See http://www.mibuso.com/forum/viewtopic.php?t=19848 for the topic of andy76.