I have been trying to install BizTalk 2010 standard edition using the SQL Alias and in my case I have defined a new SQL Alias on the Biztalk server and I did not had any issues in connecting to the SQL server but then the problem is that when I am trying to configure the Biztalk by pointing the database server name to the SQL alias then I am getting an error message saying the below thing:
I have found that when I am changing the name of the database server to databaseservername\databaseinstance then the configuration is appearing to be working out, I just wanted to know if I am missing anything, I have checked out the SQL server and have made sure that the pipe and the TCP/ICP are enabled, is there anyone who has an idea of this issue??The database server you specified cannot be reached. <ale sure you have specified the correct name and that server os currently running. A network-related or instance-specific error occured while establishing connection to sql server. The server was not found or accessible. Verify that the instance name is correct and the SQL server is configured to allow remote connections. (provider: Name Pipe Provider, error:40 - Could not open a connection to SQL server).
Bookmarks