Post reply

Invalid user in tempdb

  • July 23, 2007 at 9:01 am

    #119791

    Hi,

     

    We are getting an error message 'Not a valid user in tempdb'. The internet suggests a restart might solve the same, however, there are no explanation as to the 'why' part. All users are affected.

     

    Can anybody help please? It is very urgent. 

     

  • July 24, 2007 at 6:18 am

    #721862

    The user should have necessary permissions in tempdb. Always grant users especially application owners dbo rights in tempdb as the might use temporary tables etc.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • August 6, 2007 at 8:42 am

    #724848

    Thanks for the response....The best part was the las few lines. The issue is solved anyway. The 'guest' user in the tempdb did disappear, the production dbas re-instated the same to solve the issue.

     

    Thanks anyway.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply