question

sue avatar image
sue asked

how do I access SQL Server 2000 across domains?

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?

sql-server-2000domains
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Blackhawk-17 avatar image
Blackhawk-17 answered

I think the problem occurs because of spaces in the path to EM which is passed as a parameter to MMC. I believe MMC is trying to open C:\Program, which it can't find.

Instead of
"C:\WINNT\system32\mmc.exe /s C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQLServerEnterpriseManager.MSC"

Try running with the 8.3 syntax of
"C:\WINNT\system32\mmc.exe /s C:\PROGRA~1\MICROS~1\80\Tools\BINN\SQLServerEnterpriseManager.MSC"

To determine what 8.3 name the system is using for the SQL directory:

dir "C:\Program Files" /ad /x

On my system it was MI6841~1.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

dvroman avatar image
dvroman answered

I'm not sure what you're doing with your runas program. We use ODBC in house to achieve cross domain attachments. We're using SQLServer 2000 and SQLServer 2005. The proper ODBC setup allows us to run it seamlessly. The utility to set it up is cliconfg.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.