I am facing an issue while connecting to MsSql2005 through my Application. The server is installed on my local machine itself. If I am using the name of my machine in the connection string like - Data Source=hostname\sqlexpress;Initial Catalog=test;Max
Pool Size=500;Integrated Security=True;as
then in that case it is working fine. but if I am using ipaddress in place hostname in the connection string then in that case it is throwing the following error
'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.)'
I have checked the ip address of my machine and it is the same which I am providing in the connection string. I have checked the
SQL Server Configuration Manager and TCP/IP is enabled there for the IP address of the machine. I have allowed the remote connections for the DB server also.
Please suggest me some more trouble shooting steps which can be done from my side
View Complete Post