I have setup an APP server on Win Server 2008 R2 and my SQL server( SQL server 2008 R2) on a separate server Windows Vista. When I host my ASP.net application on App server and trying to connect to SQL server it doesnt connect. Not sure if I have missed some settings. Could you please suggest if there are any settings that I need to make for this to work.

thanks in advance Sai

link|improve this question
you might want to give some more details about your configs & settings – Mihai Oprea May 17 '11 at 8:43
Please provide the error message and code depicting how you connecting with the SQL server? – Abdul Muqtadir May 17 '11 at 8:44
Connection string is taken from web.config file and I use Ent lib 4.0 to connect to sql server. I'm unable to get the error displayed. I will retry by changing the code and publish it again and capture the error. – Sai May 17 '11 at 8:52
feedback

migrated from stackoverflow.com May 19 '11 at 3:30

This question came from our site for professional and enthusiast programmers.

1 Answer

The Vista firewall might be blocking. Follow this:

http://techpint.com/programming/error-26-%E2%80%93-error-locating-serverinstance-specified-sql-server

link|improve this answer
feedback

Your Answer

 
or
required, but never shown