Post reply

system database cannt see while connected remotely

  • August 7, 2006 at 7:08 pm

    #169379

    Hi,

    I am new on SQL server 2005 and have recently installed SQL server 2005 dev edition. Installation was successfully completed. now, i am trying to connect that server from remotely it is connecting fine but i can only see user database. Not sure why? Can anyone tell me about my problem.

    Thanks,

    SShah

     

     

     

  • August 7, 2006 at 11:05 pm

    #653764

    Permissions is always the first place to look.

    Are you logging in as the same user that you use when not remote?

    I presume you could see all that you wanted when you installed SQL?

    Regards,

    Steve

    Life without beer is no life at all

    All beer is good, some beers are just better than others

  • August 8, 2006 at 5:14 am

    #653804

    Steve,

    In SSMS open options under the tools menu. Under Environment>General check if the option "Hide system objects" is selected.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • August 8, 2006 at 10:38 am

    #653890

    Thanks mark..

    I unchecked that check box and restart SSMS and i can see all the system databases.  Thanks again!!!

    sshah

     

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

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