i'm using asp.net membership, iis 7 , sql server 2008.
i can connect tables in remote sql server except membership ones.
i error:
a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server)
- i can connect fine when click website\asp configuration visual studio, using exact same connection string.
- others in office using exact same code connect iis.
- the exact same code works fine if change connection string point sql server 2005 database.
it weird can't figure out. appreciated.
by way read asp.net membership + sql server 2008, use sql authentication.
Comments
Post a Comment