| Author |
 Topic  |
|
Volnar
Starting Member
USA
20 Posts |
 Posted - 20 June 2009 : 04:18:09
|
I’m getting a rather vague error when I try to run the setup.asp
Server Error
500 - Internal server error.
There is a problem with the resource you are looking for, and it cannot be displayed.
Here is my system information
Operating System: Windows® Web Server 2008 (6.0, Build 6002) Service Pack 2 (6002.lh_sp2rtm.090410-1830)
IIS7
MS SQL 2008 Enterprise
I edited the config file as so (username and password changed to protect the innocent)
strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
strConnString = "Provider=SQLNCLI;server=****;database=****;uid=****;pwd=************;" '## MS SQL Server 2005 w/ SQL Native Client
I’m really not sure why I’m getting this error so any help would be appreciated. This is my first time setting up a database so I would not rule out a really boneheaded mistake.
This is a personal server so I’m trying to run this all locally.
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 June 2009 : 05:52:49
|
| You need to configure the server and the browser to show error messages. You can also check the server log, as the error message likely is being written there. Once determined the actual error message, you can determine how to fix it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 20 June 2009 : 14:04:53
|
I have unchecked show friendly http error messages (I should have previously stated that). Is there a setting in IIS I need to change?
I did look though the application log and there is nothing there that explains the error. I also checked the system and hardware logs. I'm more than willing to send you the logs on request.
quote:
Originally posted by ruirib
You need to configure the server and the browser to show error messages. You can also check the server log, as the error message likely is being written there. Once determined the actual error message, you can determine how to fix it.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 20 June 2009 : 17:33:29
|
OK I turned on the send errors, I even turned everything on, still no change in the error. I do have a new log in the application log but it just states the script is timing out
error message
File /changed name here/setup.asp Script timed out. The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
Any reason why the script could be timing out? Again this is my first time seting up a data base so I might have botched something on that end. sorry for all the hand holding I'm asking for but if there is any log or settings you need I'll be happy to provide them.
quote:
Originally posted by ruirib
You need to run IIS Manager, then choose the ASP icon, then in Debugging Properties, set Send Errors to Browser to True.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 June 2009 : 17:49:41
|
You will need to set your browser to show error messages and that will depend on the browser, but the error seems a timeout one.
Is SQL Server configured to allow SQL Server authentication? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 20 June 2009 : 18:13:53
|
I beleive it is, but to be honest I'm not sure how to verify
I looked in the security properties and these are the settings
In server authentication
SQL server and windows authentication is selected
Login auditing is logging both successful logins and failed
I enabled a proxy account out of desperation, not even sure what that is or if I should leave it.
Let me know if there is a specific place I should look. Also don't assume any question is too dumb. if I can do it wrong I probubly have.
quote:
Originally posted by ruirib
You will need to set your browser to show error messages and that will depend on the browser, but the error seems a timeout one.
Is SQL Server configured to allow SQL Server authentication?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 20 June 2009 : 19:55:27
|
When I setup IIS I did select .asp and from what I can tell the server is setup to run .asp. However when I ran a test it seems to have failed.
I created a simple asp page called test.asp with the following code
<%@ Language="VBScript" %>
<% Option Explicit %>
<!--- This page should display "ASP is working!" --->
<!--- if ASP is available to you. --->
<HTML>
<HEAD>
<TITLE>ASP Test Page</TITLE>
</HEAD>
<BODY>
<% Dim TestString %>
<% TestString = "ASP is Working!" %>
<H1>
<% Response.Write TestString %>
</H1>
</BODY>
</HTML>
the page just seems to sit there and does not return the expected asp is working.
Here is the setting showing it is enabled
quote:
Originally posted by ruirib
Can you run normal ASP pages, without database connections?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 June 2009 : 20:34:33
|
| That's your problem then. Check HTTP handlers and maybe check folder permissions. Not too sure about that OS, maybe someone else can offer some ideas. I know I had to change permissions on site folders to run ASP on my Vista laptop. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 21 June 2009 : 03:50:22
|
Well the good news is that I got asp working by uninstalling asp and reinstalling it in IIS7
http://www.wow-silentheroes.com/test.asp
the bad news is that I still have the same "500 - internal server error" when I try to run the setup.asp
quote:
Originally posted by ruirib
That's your problem then. Check HTTP handlers and maybe check folder permissions. Not too sure about that OS, maybe someone else can offer some ideas. I know I had to change permissions on site folders to run ASP on my Vista laptop.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 21 June 2009 : 13:52:40
|
I believe I have
quote:
Originally posted by ruirib
You need to make sure your browser does not show friendly error messages.
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Volnar
Starting Member
USA
20 Posts |
Posted - 21 June 2009 : 16:39:38
|
ok with ODBC I get this error
There has been an error !!
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
I tried OLEDB and got this error
There has been an error !!
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
quote:
Originally posted by ruirib
Hmmm... not sure what else to suggest. Can you try to create an ODBC connection to the database and then test it?
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
