Change web API to look at different server

Can you ping that IP from the Tessie server?

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Lori Field
Sent: Friday, January 13, 2012 2:46 PM
To: Gloria Ormsby
Subject: [Tessitura Technical Forum] Change web API to look at different server

Trying to test web API access on our SQL 2008 server but keep getting error:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.TypeInitializationException: The type initializer for 'Tessitura.WebAPI.Tessitura' threw an exception. ---> System.TypeInitializationException: The type initializer for 'Tessitura.WebAPI.Config' threw an exception. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)

All we're doing is changing the IP address in connection string of web.config for the web API.  I've tried restarting the service, recycled the app pool, ensured that SQL Server does allow remote connections, and verified the ports enabled in Windows firewall...not sure what else to check.  Any suggestions? 

Thanks, Lori

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!