...
The export to New Roads SQL Server will require a SQL login. The SQL Server will need "SQL Server and Windows Authentication mode" enabled. Your IT administrator can use the following SQL script to create a SQL user that only has access to the import table(s). The script will create a SQL user named RtVision with a password determined by your IT administrator, just replace "password-here" where the script sets the password (...PASSWORD=N'password-here'). To run the script below, open SQL Server Management Studio from the New Roads SQL Server, click the "Connect" button when prompted, select File => New => Query, and paste the script in the query window. Then run the script by clicking the "Execute" button or pressing the F5 key.
USE [NRSDTA]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE name = N'RtVision')
BEGIN
CREATE LOGIN [RtVision] WITH PASSWORD=N'password-here', DEFAULT_DATABASE=[NRSDTA], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
EXEC sp_grantdbaccess N'RtVision', N'RtVision'
END
GO
...