frosty1
asked on
provider: SQL Network Interfaces, error: 26
I'm getting the following connection error. Search results suggest i'm trying to connect to a remote instance. I'm using the same connection string for ado.net and nhibernate at the same time. ( to connect to sql express) What does remote instance actually imply
##
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)
##
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)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
A remote instance is when the SQL Server you are connecting to running on a different computer than the computer that your software is running on. By default the express versions of SQL Server do not allow remote connections. This is changed in management studio, right click on instance name, properties, connections, allow remote connections.