SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 web config
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

moggy4
Starting Member

United Kingdom
3 Posts

Posted - 02/10/2013 :  11:13:28  Show Profile  Reply with Quote
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.

<!-- Web.Config Configuration File -->

<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
Flowing Fount of Yak Knowledge

3707 Posts

Posted - 02/10/2013 :  11:27:03  Show Profile  Reply with Quote
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?
Go to Top of Page

moggy4
Starting Member

United Kingdom
3 Posts

Posted - 02/10/2013 :  12:32:28  Show Profile  Reply with Quote
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.

Edited by - moggy4 on 02/10/2013 14:23:04
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3707 Posts

Posted - 02/10/2013 :  17:06:38  Show Profile  Reply with Quote
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
Go to Top of Page

moggy4
Starting Member

United Kingdom
3 Posts

Posted - 02/10/2013 :  17:39:53  Show Profile  Reply with Quote
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
Go to Top of Page

James K
Flowing Fount of Yak Knowledge

3707 Posts

Posted - 02/10/2013 :  21:50:04  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000