@shayne - thanks for clarifying. Where I work it's Windows everywhere and I've never had any problems using OS copying with SAS Software depots. If I was moving between operating systems then I would definitely use the SAS utilities.
... View more
Hello @vamsikrishna,
if you are already using the User sync scripts from SAS, they should do this update for you (except SAS external accounts, beware).
Either way, SAS offers a nice tool to change them, please give a look to: sashome/SASPlatformObjectFramework/9.4/ChangeLoginDomain
... View more
As far as I'm aware you don't need SPNs. To connect from SAS to SQL Server we just specify IWA in the database connection string like so:
proc sql;
connect to odbc (noprompt = "server=MyServerName;DRIVER=SQL Server;Trusted Connection=yes;");
create table Want as
select * from connection to odbc
(---- Put your SQL Server query here
)
;
disconnect from odbc;
quit;
As long as you log on to SAS with the service account then the - Trusted Connection=yes - option does the authentication with the database.
If you talking about EG connections to SAS using IWA then indeed SPNs may be involved as @ChrisHemedinger describes.
... View more