1

I'm playing around with sql 2008 server. I have already installed an enterprise evaluation instance and i added another one. Installation runs fine, but i cannot connect to the second instance. Server is running for both instances.

Is that a restriction for the evaluation mode ?

Helvick
  • 20,019
  • 4
  • 38
  • 55
PeterMmm
  • 895
  • 16
  • 28

1 Answers1

2

I believe multiple instances of the evaluation edition should work. Do you have the SQL Server Browser running and (if you are trying to connect from a different machine) its port, and the port in use by the second instance, open in your firewall settings? This page has a good reference of how to configure multiple instances for access beyond the firewall.

To confirm that the problem is/isn't the eval edition, add a named instance of SQL Express (you can remove it immediately after this test) - if the SQL Express instance is not connectible either than the eval-ness of the other invisible instance it not the problem.

David Spillett
  • 22,754
  • 45
  • 67
  • SQLExpress instance works fine, SQLBrowser runs but the second instance get not listed when searching. FW is off. – PeterMmm Dec 21 '10 at 09:08
  • That is working now. I was trying to call the default instance as "SERVER\MSSQLSERVER". If i use only "SERVER" it works. – PeterMmm Dec 21 '10 at 09:26
  • 1
    Yeah,. Because MSSQLSERVER is the DEFAULT NAME, i.e. the DEFAULT INSTANCE ;) – TomTom Dec 21 '10 at 10:07