Navision - SQL Logins

anilkumar
anilkumar Member Posts: 136
edited 2007-04-11 in SQL General
hi! Experts..............

we are planning to migrated from Navision Native Database to SQL Server,

Problem facing :1. how to transfer all native database logins to SQL Server, in user table it is show all the users, but unable to login.

right now creating sql logins manually same as native database logins.

any right direction please.
Anil Kumar Korada
Technical Consultant

Comments

  • lzr
    lzr Member Posts: 264
    You need to create them as database logins in the SQL server, after that you need to add them and their rights in Nav, and then synchronize them.
    Navision developer
  • DenSter
    DenSter Member Posts: 8,307
    I think you can have the Enterprise Manager automatically write a script to create those users. Search books online, I'm sure it's in there somewhere.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • ara3n
    ara3n Member Posts: 9,258
    Hello Here is an example query on how to create a login.
    CREATE LOGIN [user1] WITH PASSWORD='', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [user1] DISABLE

    You can write a quick report to generate the file, then you can run it on sql. The users will have blank password, so they have to change it.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • anilkumar
    anilkumar Member Posts: 136
    Thanks a lot... Mr. Rashed,
    Working ...........

    I used following procedure at SQL Query Analyser


    use test
    go

    sp_addlogin @loginame = 'user1',@passwd = 'user1', @defdb = 'test'
    go

    sp_grantdbaccess 'test'
    go



    Thanks!!
    Anil Kumar Korada
    Technical Consultant
  • kriki
    kriki Member, Moderator Posts: 9,124
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories