connect MS SQL database to railo datasources
I'm having a heck of a time getting a MS SQL datasource connected through my railo installation. I can connect fine through Adobe ColdFusion, but railo keeps throwing an error
In Adobe ColdFusion I have my server set as mycomputername\sqlexpress and port 1433. In Railo using the same server, database, username and password. I'm getting the following error
The TCP/IP connection to the host myservername, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port."..
I've also tried connecting via the IP address listed in SQL Server Configuration Manager IP4 is set to active and enabled with an IP address of 127.0.0.1 but that throws the same error as above
I have IPv6 turned on and that shows up as IP1 in my TCP/IP settings, but I don't know why that would be causing an issue.
Port 1433 is open as I can connect through Adobe ColdFusion. I hope I'm missing something obvious, but I'm stumped.
I finally got this working by changing the Listen All setting to no in SQL Server Configuration Manager > TCP/IP Propertiest
and setting the TCP Port to 1433 and enabling the datasource in IP2 below
- How to increase the performance of a Database?
- What is the best way to create and populate a numbers table?
- Generate CREATE scripts for a list of indexes
- SQL Server error on update command - "A severe error occurred on the current command"
- Alter table add multiple columns ms sql
- SQL Server String or binary data would be truncated
- Natural (human alpha-numeric) sort in Microsoft SQL 2005
- Determine what user created objects in SQL Server
- How to drop a unique constraint from table column?
- SQL Server Temp Tables and Connection Pooling
- How to add a column with a default value to an existing table in SQL Server?
- How to copy and paste script text from SSMS to Outlook or Word without garbling it?
- SQL Server compare results of two queries that should be identical
- Parse usable Street Address, City, State, Zip from a string
- SQL Server Agent Job Timeout
- Calculate data based on days and weeks in SQL
- What are row, page and table locks? And when they are acquired?
- How can I find sql server port number from windows registry?
- SQL Mangement Studio Cannot show requested Dialog
- varbinary to string on SQL Server
- How to upsert (update or insert) in SQL Server 2005
- Issue with bulk insert
- How to rollback or commit a transaction in SQL Server
- SP taking 15 minutes, but the same query when executed returns results in 1-2 minutes
- What's the best way to select the minimum value from several columns?
- Base64 encoding in SQL Server 2005 T-SQL
- How to print VARCHAR(MAX) using Print Statement?
- Are SQL execution plans based on schema or data or both?
- Export table data from one SQL Server to another
- Generate a resultset of incrementing dates in T-SQL