Today I was working on some Report and found an issue with transforming the data to a tabular form for reporting.

Need Help...

TCP Provider Error

Recently, I recieved error on my local machine for connecting to SQL Server. I have Windows7 and a freshly installed SQL Server 2005 and a service pack 3 for SQL Server 2005.

The next day when I started my machine I was unable to connect to SQL Server.

I got the following message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.)
(Microsoft SQL Server, Error: 10061)
For help, click: here

I performed following quick steps:

1. Go to All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server Services, and check if SQL Server service status is “Running”.
(If it is Stopped, Right Click and Select Start.)
I found it running.

2. Go to All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager -> SQL Server 2005 Network Configuration -> Protocols for MSSQLServer.
I found TCP/IP was disabled. (Also the error provider was TCP/IP Provider).
I right clicked and made it Enable.

Later on I found interesting checklist from one of my favourite blog on this topic which can be helpful for a quick reference.

IIS Feature Requirement for SQL Server 2005 Setup on Windows7/Vista

I was always having trouble remembering the IIS Requirements for SQL Server 2005. I am working with Reporting Services, and due to the IIS Requirement failure, I was unable to completely configure my Reporting Service.I was unable to get Report Manager and so could not deploy my reports on local host.

Warning message for the IIS Feature Requirement item on the System Configuration Check page in the SQL Server 2005 Setup program:

"Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online."

Here is the solution for successful configuration of IIS.

On Windows 7:

Go to Control Panel -> Programs -> Programs and Features -> Turn Windows Features ON or OFF -> Internet Information Services.

Component	Folder
Static Content	World Wide Web Services/Common HTTP Features
Default Document	World Wide Web Services/Common HTTP Features
HTTP Redirection	World Wide Web Services/Common HTTP Features
Directory Browsing	World Wide Web Services/Common HTTP Features
ASP.Net	World Wide Web Services/Application Development Features
ISAPI Extension	World Wide Web Services/Application Development Features
ISAPI Filters	World Wide Web Services/Application Development Features
Windows Authentication	World Wide Web Services/Security
IIS Metabase	Web Management Tools/IIS 6 Management Compatibility
IIS 6 WMI	Web Management Tools/IIS 6 Management Compatibility

Source: http://support.microsoft.com/kb/920201