Configure Map Network Drive using T-SQL

GO
xp_cmdshell "net use Z: \\ServerName\drive$\FolderName <password> /user:domainusername
GO

Disconnect Mapped Network drives

GO
Exec master.dbo.xp_cmdshell 'net use Z: /delete'
GO