Question

Photo of West Jones

0

Database Remote Connection Issue

1

I'm trying to set up a testing enviornment for a client and am running into an issue connecting with the database. This is a externally hosted site on rackspace cloud using a Windows Server 2012 R2 / IIS 8.5 / .NET 4.5 I've checked the name, user and password they are all correct.  So my question is how do I allow this connection to go through? Is this a question I should direct to rackspace? Any good docs on this issue would be appreciated. Thanks all.. Excited to get involved in this community!

Screen Shot 2014-12-30 at 10.45.38 AM.png

  • Photo of Rock RMS

    0

    Could be a couple of different things depending on the specifics of your environment. We'd recommend trying these items first:

    1. Check that your SQL Server is configured for TCP/IP. Looks like it might be using Named Pipes. If you're using SQL Server Express then follow these steps (though the steps should be similar/same for the full version of SQL Server). http://support.webecs.com/kb/a868/how-do-i-configure-sql-server-express-to-allow-remote.aspx
    2. If you're SQL Server is on a separate machine you might check that the Windows Firewall on the SQL Server is configured to allow traffic on the SQL port. http://searchsqlserver.techtarget.com/tip/Configure-Windows-Firewall-to-allow-SQL-Server-connections