Hi Forum,

Heres the scenario.

I have VS2008 and SqlServer Enterprise Edition installed in my machine.

I connect to the database inside the same machine using VS2008.

I opened the project my client gave me inside vs2008.

When I ran the project, the it runs.

but the aspx page to be displayed shows error like

 'Problem in Connecting Database. error " SQL Server does not allow remote connections." '

I have db and vs in the same machine ( no remote machine involved).

Why does this error came?

How to Rectify it?

Any guidelines are deeply appreciated.

Check your web.config file and make sure that the database connection string doesn't refer to a remote machine...

Hi KeleyThornton,

No it is not so.

Shame - that is  aproblem I have runinto myself before now...

You say that the project works in VS, but not when you run it from IE?

that would maybe imply that hte SQL server is treating ISS as "external"?!?

Not sure if you have solved it. Try control panel/administrative tools/services and verify your local SQL Server is started. Hope that works.

Hi guys,

Incorrect Installation was the culprit.
ReInstalled the same and all is working fine.

Thanks a lot for your time guys.

hi friends

what is different between enterprise and express version of SQL ? which one should i use ?

cheers

Hi there.

See this page (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) and this webcast for (http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032306509&EventCategory=5&culture=en-US&CountryCode=US) suggestions...