SQL server 2008 express in window 7 development machine which is not wired to internet through router, enabled wire network but no 127.0.0.1 display in ipconfig
success to find instance in network services of management studio after SQL browser service enabled
but asp .net application has connection 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:
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
then i find no surface configuration, then i open configuration manager, one of item in left panel 's TCP/IP is disabled, then i try to enable it said will be saved change until service stop and restart.
and then stop the services of SQL server's intance services and SQL browser services
then try ...
Go to the complete details ...