Installing DBXL on Web Server with Separate SQL Machine - Patrick Halstead
in

InfoPath Dev

Patrick Halstead

Installing DBXL on Web Server with Separate SQL Machine

If you are installing DBXL on a Web Server and setting it up to access a separate SQL server machine on your network, you need to add a security login to that separate SQL server machine that enables the machine running DBXL to access it. Use DOMAIN\MACHINENAME$ where DOMAIN is the domain in which both machines are joined and MACHINENAME is the machine name for the server on which DBXL is being installed. You will need to add the $ sign to the end of the machinename.

The prefered authentication method for this scenario is SQL Authentication. Windows Authentication will work, but you will need to give the server machine account where the Web Service is installed sysadmin access to the SQL instance. In addition, run ASPNET under a domain account.

Comments

No Comments

About Patrick Halstead

Hello! I am the founder of Qdabra Software, a small bootstrap software company focused on electronic forms for customers of all stripes. We help organizations design and implement solutions using off-the-shelf technologies such as Office 365, SharePoint and InfoPath. We help you build form solutions in the cloud or on premises. My hobbies include running, hiking, independent film, and Japanese culture.
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.