Announcement

Collapse
No announcement yet.

SQL 2k8 R2 Express named instance vs default instance IP connect

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL 2k8 R2 Express named instance vs default instance IP connect

    Hello All,

    can somebody tell me if this statement is true or not:

    You cannot connect to a SQL Server Express instance with IP only unless you have installed Express as the default instance.

    I have a Named instance on SQL 2k8 R2 express, and i cannot access it via IP\SQLEXPRESS.

    Hostname\SQLEXPRESS works as well as localhost\SQLEXPRESS.

    I've ran through all possible suggestions, but still not working.

    Trying locally and remotely as well. LAN, no FW enabled.

    Any suggestions are welcome.

    Thanks,

    T.

  • #2
    Re: SQL 2k8 R2 Express named instance vs default instance IP connect

    I take it that you are using SQL Studio Manager Express Edition to try and connect to it?

    Comment

    Working...
    X