up vote 1 down vote favorite
share [g+] share [fb]

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 ?

link|improve this question
81% accept rate
feedback

1 Answer

up vote 2 down vote accepted

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.

link|improve this answer
SQLExpress instance works fine, SQLBrowser runs but the second instance get not listed when searching. FW is off. – PeterMmm Dec 21 '10 at 9: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 9:26
1  
Yeah,. Because MSSQLSERVER is the DEFAULT NAME, i.e. the DEFAULT INSTANCE ;) – TomTom Dec 21 '10 at 10:07
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.