• Replies 12 replies
  • Subscribers 337 subscribers
  • Views 101 views
  • Users 0 members are here
Related

Change web API to look at different server

Lori Field
$organization

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

  • Former Member
    Former Member $organization

    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!

  • $organization in reply to Former Member

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

  • Former Member
    Former Member $organization

    This is how mine is configured. Have you specified “impresario?”

     

    add key="CONNECTION_STRING" value="Data Source=flynnt;Initial Catalog=Impresario;User Id=Web;Password=XXXXX " /><!--  TESSITURA DATABASE CONNECTION STRING -->

     

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

     

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 1:49:12 PM

    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!




    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!

  • $organization

    Lori,

     

    Have you tested the credentials you are using in the connection string on the new server to make sure they work?  Try connecting to the database thru SSMS using the credentials supplied in the connection string.

     

    Gregg Stickney

    Application Support Specialist

    Tessitura Network

    www.tessituranetwork.com

    gstickney@tessituranetwork.com

    Office  +1 888-643-5778 x318

     

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

     

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 1:49:12 PM

    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!




    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!

  • $organization in reply to Former Member

    Yes, impresario is listed.  Here's my connection string: 

    <add key="CONNECTION_STRING" value="Data Source=10.1.1.xx,1xxx;Initial Catalog=impresario;User ID=web;Password=xxx"/><!-- TESSITURA DATABASE CONNECTION STRING -->

    Actually using IP address and port but it doesn't work even when I create a system DSN (which can connect).  I also tried using different ports.

  • $organization in reply to Gregg Stickney

    Thanks, Gregg, already tried that.  User can connect directly in SSMS.

  • $organization

    Also make sure that Windows Firewall is either turned off on the API server, or configured to allow access from machines on the same domain. More often than not lately, I’ve found it’s on by default on new machines.

     

    Jonathan T. Smillie

    Implementation & Training Specialist/Consultant

    Tessitura Network, Inc.

    Universal contact: 1-888-643-5778 ext 326

    Office direct: 812-288-2213   Cell: 502-345-5808

    jsmillie@tessituranetwork.com

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gregg Stickney
    Sent: Friday, January 13, 2012 3:12 PM
    To: Jonathan Smillie
    Subject: RE: [Tessitura Technical Forum] Change web API to look at different server

     

    Lori,

     

    Have you tested the credentials you are using in the connection string on the new server to make sure they work?  Try connecting to the database thru SSMS using the credentials supplied in the connection string.

     

    Gregg Stickney

    Application Support Specialist

    Tessitura Network

    www.tessituranetwork.com

    gstickney@tessituranetwork.com

    Office  +1 888-643-5778 x318

     

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

     

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 1:49:12 PM

    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!




    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!




    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!

  • Former Member
    Former Member $organization

    Your IP address has a comma in it and extra info. Are you using IP4 or IP6?

     

    10.1.1.xx,1xxx

     

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

     

    Yes, impresario is listed.  Here's my connection string: 

    <add key="CONNECTION_STRING" value="Data Source=10.1.1.xx,1xxx;Initial Catalog=impresario;User ID=web;Password=xxx"/><!-- TESSITURA DATABASE CONNECTION STRING -->

    Actually using IP address and port but it doesn't work even when I create a system DSN (which can connect).  I also tried using different ports.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 2:04:12 PM

    This is how mine is configured. Have you specified “impresario?”

     

    add key="CONNECTION_STRING" value="Data Source=flynnt;Initial Catalog=Impresario;User Id=Web;Password=XXXXX " /><!--  TESSITURA DATABASE CONNECTION STRING -->

     

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

     

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 1:49:12 PM

    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!




    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!




    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!

  • $organization in reply to Former Member

    Should be IP4...the extra info is how we're specifying the SQL port to use. 

  • $organization

    Lori,

    Have you tried entering the database instance name in the Data Source string after the IP address?

    Here's what's in my web.config file:

    <add key="CONNECTION_STRING" value="Data Source=servername\instancename;Initial Catalog=impresario;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxxxxx"/><!--  TESSITURA DATABASE CONNECTION STRING -->

  • Former Member
    Former Member $organization

    Did you try it without the port?

     

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

     

    Should be IP4...the extra info is how we're specifying the SQL port to use. 

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 2:29:06 PM

    Your IP address has a comma in it and extra info. Are you using IP4 or IP6?

     

    10.1.1.xx,1xxx

     

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

     

    Yes, impresario is listed.  Here's my connection string: 

    <add key="CONNECTION_STRING" value="Data Source=10.1.1.xx,1xxx;Initial Catalog=impresario;User ID=web;Password=xxx"/><!-- TESSITURA DATABASE CONNECTION STRING -->

    Actually using IP address and port but it doesn't work even when I create a system DSN (which can connect).  I also tried using different ports.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 2:04:12 PM

    This is how mine is configured. Have you specified “impresario?”

     

    add key="CONNECTION_STRING" value="Data Source=flynnt;Initial Catalog=Impresario;User Id=Web;Password=XXXXX " /><!--  TESSITURA DATABASE CONNECTION STRING -->

     

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

     

    Hi Gloria, yes I can ping to/from both gateway server and Tess server.

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 1/13/2012 1:49:12 PM

    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!




    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!




    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!




    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!

  • $organization

    Thanks, David, that worked!  I didn’t even think to try it that way.

     

    From: David Wolfinbarger [mailto:bounce-davidwolfinbarger4280@tessituranetwork.com]
    Sent: Friday, January 13, 2012 3:47 PM
    To: Lori Field
    Subject: Re: [Tessitura Technical Forum] Change web API to look at different server

     

    Lori,

    Have you tried entering the database instance name in the Data Source string after the IP address?

    Here's what's in my web.config file:

    <add key="CONNECTION_STRING" value="Data Source=servername\instancename;Initial Catalog=impresario;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxxxxx"/><!--  TESSITURA DATABASE CONNECTION STRING -->

    From: Lori Field <bounce-lorifield8069@tessituranetwork.com>
    Sent: 1/13/2012 1:44:51 PM

    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!