Connecting to a SQL Server Database on a Different Azure Server

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  October 29, 2014 at 2:27 pm

  #298006

  I have an application on one Azure server (AppServerTest.cloudapp.net:59181) and a sql server 2014 database on another (DbaseServerTest.cloudapp.net:61181)

  In the application, I need to reconfigure OLE DB connection strings to connect to databases on the database server. The following is a sample of the connection string I currently have (and this is on a different, local machine):

  [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Dbase_DataMart;Data Source=Local2014;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=Workstation1;Use Encryption for Data=False;Tag with column collation when possible=False];

  How do I change this so that the database connection points to the database on DbaseServerTest.cloudapp.net:61181 server?

  The app server does not have a tool such as SSMS installed on it. I tried making a UDL file on the app server, but I was not able to. What else can I use on the app server to test the connection (besides the application)?

  Thank you for your help.