JSI Tip 7177. When you attempt to retrieve the security context on a SQL Server 2000 cluster, you receive the cluster service context instead of the SQL Server 2000 service context?

When you run the EXEC master..xp_cmdshell('SET USER') extended stored procedure, it returns the security context of the cluster service, NOT the SQL Server 2000 service account.

NOTE: When you run a CmdExecJob job step that has SET USER on a SQL Server 2000 cluster, it also returns the wrong context.

To workaround this behavior, download and use the Windows 2000 Resource Kit Tool: Whoami.exe.

The Whoami.exe command in a xp_cmdshell extended stored procedure returns the SQL Server 2000 service account.

NOTE: When you run a CmdExecJob job step that has Whoami.exe on a SQL Server 2000 cluster, it returns SQL Server Agent service context.



Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish