IIS issue?

hotspex

Hi,

I just installed SQL Monitor 2.2 but I can't reach the website either locally on the server or remotely.

The url changes to:
http://myserver.com:8080/Account/LogIn? ... fault.aspx

And says page can't be found. (IE)

Port 8080 is open, and my server firewall is disabled for testing. I didn't experience any problems or errors during installation.

I'm using Windows 2003 64bit with IIS6. The base service is running.

Any ideas?

Chris Spencer

Hi

My initial ideas are:
1. Anonymous authentication might not be turned on for the website. Right-click the website in IIS manager > select Properties > Directory security tab > Authentication and access control > Enable Anonymous authentication.
2. Check that the website is started correctly and there are no port number clashes. When you installed did you select the IIS option? If not then our XSP webserver would be installed and possible also listening on port 8080.
3. "Default.aspx" exists in the list of default content pages (found at website properties > Documents tab).
4. The ASP.NET version for the website is set to 2.0.50727. This can be found at website properties > ASP.NET tab.

The setup on IIS6 is not straightforward for ASP.NET MVC apps (like SQL Monitor). We have some troubleshooting information at:
http://www.red-gate.com/supportcenter/C ... 140287.htm

Hope this helps?
Chris

hotspex

Thanks Chris.

It turns out (probably) due to our 2003 64bit server has enable32bitapponwin64 turned on in II6. I dont have access to the .NET tab in IIS.

So I re-installed SQL Mon with the provided web server and now it works fine.

Another questions: I have 2 SQL server instances that I added to monitor. One works fine, the other works for 10 seconds then throws a "Bad Data" exception. The detail of the exception is this:

The supplied DateTime represents an invalid time. For example, when the clock is adjusted forward, any time in the period that is skipped is invalid. Parameter name: dateTime

I'm assuming this is not the host clock since one of my sql instances is running ok.

Any ideas?

Chris Spencer

Hi

This issue has come up before and there is a very thorough explanation on the following thread that I think will help you:
http://www.red-gate.com/MessageBoard/vi ... hp?t=13034

Hope this helps
Chris

hotspex

Like the person in the other thread, my servers are now all connect. THanks for the explanation!