C# .NET - Sql connection - Asked By hiren dhameliya on 11-Jan-13 05:36 PM

I have developed my site . and config in IIS Server . in visual studio  web is working fine but in iis it give me like this 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: 50 - LOCAL DATABASE RUNTIME ERROR OCCURRED. CANNOT CREATE AN AUTOMATIC INSTANCE. SEE THE WINDOWS APPLICATION EVENT LOG FOR ERROR DETAILS. )
Robbe Morris replied to hiren dhameliya on 11-Jan-13 08:42 AM
It is telling you that it cannot connect to your sql server instance.  Is the database on the same server as your IIS?  Need more details to help out.