SQL2000 SP4

• R.van.Sloten

  Valued Member

  Points: 71

  More actions

  July 3, 2009 at 6:42 am

  #202024

  I am running SQL2000 SP4 on Windows2003:

  Authentication: SQL Server and Windows

  All LOGIn ID's are associated with a user ID in the Database.

  When I run the query

  USE master EXEC sp_who

  I get many QUEST LOGINNAME's and some domain login's and there is no different between the LOGIN's in SQL!!

  Can somebody explain why I get GUEST LOGINName's and how I can change this?

  950sleeping GUEST

  960sleeping GUEST

  970sleeping GUEST

  980sleeping GUEST

  990sleeping E.Nahumury@rvdk.minjus.nl

  1000sleeping GUEST

  1010sleeping GUEST

• rajganesh.dba

  SSCrazy

  Points: 2538

  More actions

  July 3, 2009 at 11:34 am

  #1019833

  check whether guest is eanbled in any of the user dbs mentioned inthe process and revoke it