Navision - SQL Logins

anilkumar

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.

lzr

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.

DenSter

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.

ara3n

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.

anilkumar

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!!

kriki

[Topic moved from Navision forum to SQL General forum]