218
Dear Team,
I am moving data from Production Server (With Domain) to Standalone (Development & Test) where Domain users are not available.
In Production server data is accessed through 'Windows Authentication' and all configuration is done through 'DOMAIN\Administrator'
Can anyone guide how to access data without domain users on Standalone System.
Warm Regards,
Ashish
*This post is locked for comments
Thanks
Jonathan
Thanks
This is a common scenario if you take a backup of the database from one domain and try to restore it for development or testing. One thing you could do is delete the data from user tables or inject the user using SQL
Please check this link
sbinesh.blogspot.com/.../add-users-in-nav-2016-from-sql-server.html
if you can't login into the database on the standalone pc, add a (local) nav user using this sql script:
USE [YourDatabase]
DECLARE @USERSID uniqueidentifier, @WINDOWSSID nvarchar(119), @USERNAME
nvarchar(50)
SET @USERNAME = 'Domain\user' -- your local pc user e.g. pc-name\youruser
SET @USERSID = newid()
SET @WINDOWSSID = 'Your SID'
INSERT INTO [dbo].[User]
([User Security ID],[User Name],[Full Name],[State],[Expiry Date],
[Windows Security ID],[Change Password],[License Type],
[Authentication Email])
VALUES
(@USERSID,@USERNAME,'',0,'1753-01-01 00:00:00.000',@WINDOWSSID,0,0,'')
INSERT INTO [dbo].[User Property]
([User Security ID],[Password],[Name Identifier],[Authentication Key],
[WebServices Key],[WebServices Key Expiry Date],[Authentication Object ID])
VALUES
(@USERSID,'','','','','1753-01-01 00:00:00.000','')
INSERT INTO [dbo].[Access Control]
([User Security ID],[Role ID],[Company Name])
VALUES
(@USERSID,'SUPER','')
GO
to get your windows sid, start command shell and run:
wmic useraccount where name='your-username' get sid
you could also use powershell:
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (