web config - 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

General SQL Server Forums

New to SQL Server Programming

web config

Author

Topic

moggy4
Starting Member

3 Posts

Posted - 2013-02-10 : 11:13:28

hi was wondering if anyone could help me.
i have just moved hosting server
old server had mssql 2005
new server has mssql 2008
Dont know if this may be the problem

Every time i try to launch my website i recieve the following error

Server Error in '/' Application.
Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.



<configuration>
<system.web>
<customErrors mode="Off"/>
</system.web>
</configuration>]

I have edited the config file with new sever details but still get this error .

Hope someone can help here
Thanks
moggy4

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-10 : 11:27:03

Try if you can connect from a browser on the server. Even if you cannot, view the error messages as suggested in the current error description. Are you able to connect to the new server from SSMS?

moggy4
Starting Member

3 Posts

Posted - 2013-02-10 : 12:32:28

am able to connect to the database in mssql 2008 on the server.
but cannot seem to get the website to load in my browser.
I am not sure if this could be because of new server is running mssql 2008 and the site used to work on old server mssql 2005

Or is it my web config file thats wrong

?xml version="1.0" encoding="UTF-8"?>
<configuration>
<configSections>
<section name="neatUpload" type="Brettle.Web.NeatUpload.ConfigSectionHandler, Brettle.Web.NeatUpload" allowLocation="true" />
</configSections>
<appSettings>
<add key="SqlConnection" value="Initial Catalog=*******; Password='*****';User ID='******'; Data Source=213.175.208.3;pooling=false" />
<add key="smtp_server" value="213.175.208.6" /> 
<add key="mail_user" value="admin@********.info" />
<add key="mail_password" value="*******" />

</appSettings>
<system.web>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb information)
into the compiled page. Because this creates a larger file that executes
more slowly, you should set this value to true only when debugging and to
false at all other times. For more information, refer to the documentation about
debugging ASP.NET files.

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-10 : 17:06:38

I can't see anything that stands out in the web.config, assuming that the IP address is correct, and that the same config file worked for the previous server. Can you check if remote connections are enabled on the new server? See here how to see: http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx

moggy4
Starting Member

3 Posts

Posted - 2013-02-10 : 17:39:53

Hi James
thanks for your help yes remote connections are enabled.
and i am able to log into the database from my pc via ms sql manage just seems to fail when in browser

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-02-10 : 21:50:04

Are you able to run it through debugger or deploy a debug build to see what the error message is? And, while it may seem obvious, check each value in your connection string to make sure that there are no typos etc. Other than those, I am not able to suggest anything without seeing the error messages.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources