Possible problem with SQL 2000 on W2K Terminal Server in application mode.

  • Thread starter Thread starter Jeff Tulley
  • Start date Start date
J

Jeff Tulley

Hi

I have installed SQL 2000 Standard on a Windows 2000 application mode
terminal server.

'Users' get a message stating " The drive or network connection that the
shortcut 'Service Manager.lnk' refers to is unavailable. Make sure that the
disk is properly inserted or the network resource is available and try
again."

Logging in via TS under an admin account does not produce the error.

Additionally, most of the MS SQL Server program group is unavilable and
Enterprise manager displays an MMC snap-in error staing the file could not
be found. Again it works fine for the admin account login.

Any ideas? SQL was installed using the control panel, add remove programs
option.

Cheers

Jeff
 
Sounds like some permissions problems with some files.
Try running filemon from www.sysinternals.com as an admin
while a normal user accesses these files/programs and gets
the error your described. Look in the output of filemon
for access denied error messages, since those files most
likely have incorrect NTFS permissions on them.

Oh, by the way, in most cases, unless you have a very ligh
load on your server, you don't want to run terminal
services and SQL server on the same machine.

-M
 
Thanks Matthew

Great utility. I have set the NTFS perms and we are up and running. Its
only a 4 user system so performance isnt a worry.

Jeff
 
Back
Top