I need to access a SQLServer 2000 living in another domain.
My runas command is as follows: runas /netonly /user:domain2\userabc "C:\WINNT\system32\mmc.exe /s C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQLServerEnterpriseManager.MSC"
my error is as follows: MMC cannot open the selected file
The error seems to be between the runas.exe and the need for SQLServer2000 to use mmc.exe.
My workaround is to use windows explorer to navigate to C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQLServerEnterpriseManager.MSC and manually right click Runas.
This works just fine in SQLServer2005. C:\WINNT\system32\runas.exe /netonly /user:domain2\userabc "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
Does anyone know of a way to program the runas for SQLServer2000?