SQLEXPRESS / SQL 2000 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

SQLEXPRESS / SQL 2000

Author

Topic

Steve2106
Posting Yak Master

183 Posts

Posted - 2008-05-08 : 16:41:24

Hi Guys,
Don't know if this is in the right place.
I have developed a web app in Visual Studio 2005. When I choose "view in browser" default.aspx from within Visual Studio it works perfectly. If I go directly to Internet Explorer and type in http://localhost/testapp it gives me an error of:

"Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur."

This is because in IIS Virtual Directory for TestApp if I choose the asp.net tab and the choose "Edit Cofiguration" Button in the Connection String Manager LocalSqlServer is set to "data source=.\SQLEXPRESS;Integrated Security=SSPI; AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"

Which is making it use SQLExpress. If I Type "http://localhost:1323/testapp" it works because SQLExpress is still running. I want to be able to type "http://localhost/testapp" and it uses Sql Server 2000 How do I get it to do that.

I appreciate any help you can give.

Best Regards,
Steve.

Steve

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-08 : 22:07:45

You need different connection string for sql2k.