mibuso.com
Home› SQL General
Options

Windows Authentication not working on SQL 2005

jdavisjdavis Member Posts: 7
edited 2007-07-28 in SQL General
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!

Answers

  • Options
    ara3nara3n Member Posts: 9,255
    I would not recommend using sp1 with sql 2k5. Please get the sp3 executables.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Options
    nunomaianunomaia Member Posts: 1,153
    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.
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    jdavisjdavis Member Posts: 7
    That worked! Thanks for the help. Is there an SP3 for the NAS or will the SP1 NAS work fine?
  • Options
    nunomaianunomaia Member Posts: 1,153
    NAS must be the same version of navision client, in your current case SP3
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    andy76andy76 Member Posts: 616
    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
  • Options
    nunomaianunomaia Member Posts: 1,153
    In Client CD, there is a document about installing Navision in SQL Server
    Nuno Maia

    Freelance Dynamics AX
    Blog : http://axnmaia.wordpress.com/
  • Options
    andy76andy76 Member Posts: 616
    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
  • Options
    andy76andy76 Member Posts: 616
    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
  • Options
    andy76andy76 Member Posts: 616
    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
  • Options
    krikikriki Member, Moderator Posts: 9,089
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

This discussion has been closed.