Sql server 2005 mgr studio on windows server 2008 r2

  • I have installed sql server 2005 (x64) on a Windows Server 2008 R2. I am unable to connect to the local database instance on the local server console. I can only connect to integration instance, no other option are available locally. I can connect to the instances from a remote system.

    I have applied sql sp3 and visual studio sp1 to the server?

    any ideas?

    Simon

  • Can you post the error that you get when you try and connect to the local instance?

    Joie Andrew
    "Since 1982"

  • Don't actually get an error message. When I click to browse local server no list appears. If I manually add server I can connect.

  • so there isn't an error. You can connect to the local server via SSMS.

  • Yes I can connect if a manually add the server\instance in, normally you can click <browse> and a list of local instances is generated.

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

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