• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

SQL Server Remote Connection Problem

I am running SQL Server 2008 R2 Express on a dedicated server and I'm having problems connecting to it from an ASP script on another server.

I can connect to it fine via ASP scripts on the dedicated server and via a remote copy of SQL Server 2008 MS.

The remote SQL Server 2008 MS connects using servers IP, the ASP scripts use the server name ".\sqlexpress"

If I run
TELNET IP 1433 on the dedicated server I connect fine.

If I run
TELNET IP 1433 on a remote PC I can't connect.
"Could not open connection to host, on port 1433"

I've attached screen grabs of my firewall settings.



 Firewall settings
0
benners70
Asked:
benners70
1 Solution
 
Ramesh Babu VavillaCommented:
did u try to acces it by ip ?
0
 
Ryan WeaverInfrastructure ManagerCommented:
I believe you need to turn on remote connections in Express: http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/
0
 
benners70Author Commented:
sqlservr: did u try to acces it by ip ?
What do you mean? A ping gives a reply.

Fryguy: I've enable TCP/IP and SQL Server browser. I've attached a screen grab as I'm wondering if there's some kind of conflict to do with 32bit configuration. SQL Server Config SQL Server Config
0
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please check this article to start the troubleshooting:
http://www.experts-exchange.com/A_1881.html
0
 
Alpesh PatelAssistant ConsultantCommented:
Please make sure exception is added in Firewall
Remote connection is enabled from Surface area
TCP/IP and pipelines are enabled.


0
 
benners70Author Commented:
I can now connect via telnet on a remote PC. I can also use SQLCMD on remote PC and can connect to a DB and run a query, but I still get errors using the ASP connection, see below.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid connection.

Application("connectionString") = "Driver={SQL Server};IP;Database=DBNAME;Uid=USER;Pwd=PWD;"
set globalConn = Server.CreateObject("ADODB.Connection")
globalConn.connectionString = Application("connectionString")
globalConn.Open

I can connect to other SQL DBs with the code above.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now