Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.
Chat Now

Accessing a Shared Database with Web Site Admin Tool

If you currently use Visual Studio’s Web Site Administration Tool while trying to connect to a database hosted on an external server, you may receive the following error:

Login failed for user ”. The user is not associated with a trusted SQL Server connection.

This is due to a default connection string within Web Site Administration Tool’s web.config file. You can modify this default connection string to connect to your shared database by following the steps in this article.

First, browse to the web.config file with in the Web Site Administration Tool’s installation folder and open it using your favorite text editor (such as Notepad).

Then locate the connection string in the web.config file and replace it with your database’s connection string. For example, the block of code containing the connection string should resemble the following:

<configuration>
<connectionStrings>
<add name="MyConnectionString" connectionString="Data Source=(IPADDRESS,PORT);User ID=USERNAME;Password=PASSWORD;Initial Catalog=DATABASENAME" providerName="System.Data.SqlClient"/>
</connectionStrings>
</configuration>

This should resolve the error listed above. If you continue to experience any problems, please feel free to submit a ticket to our technical support department:

https://www.serverintellect.com/contact/

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Chat Now

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.