Issue with connecting to databse on IIS 6.0

[SP]

I have upgraded Windows 2000 to Windows 2003 server with
IIS 6.0 and now I am getting an error when asp page tries
to connect to the database. This is the error that I am
getting:

An error occurred on the server when processing the URL.
Please contact the system administrator.

There was nothing in the event log, DSN was tested fine
and browser was set to display any error.

Thank you for any help.

[Aaron Bertrand [MVP]]

>I have upgraded Windows 2000 to Windows 2003 server with

> IIS 6.0 and now I am getting an error when asp page tries
> to connect to the database.

[url]http://www.aspfaq.com/2476[/url]
[url]http://www.aspfaq.com/2205[/url]

> An error occurred on the server when processing the URL.
> Please contact the system administrator.

The real error would help.
[url]http://www.aspfaq.com/2109[/url]

> DSN was tested fine

Stop using a DSN! Right now!
[url]http://www.aspfaq.com/2126[/url]

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

I tried all of them. None of them worked. Even viewer
still does not show anything.

I'm thinking in reformatting the server and install
Windows 2003 from the scratch.

I still can't believe that IIS 6 is not working for ASP
pages with upgrade from Windows 2000 to Windows 2003.

Has anyone out there had similar problem?

Please help.

>-----Original Message-----

>>I have upgraded Windows 2000 to Windows 2003 server with
>> IIS 6.0 and now I am getting an error when asp page

tries

>> to connect to the database.

>
>[url]http://www.aspfaq.com/2476[/url]
>[url]http://www.aspfaq.com/2205[/url]
>

>> An error occurred on the server when processing the

URL.

>> Please contact the system administrator.

>
>The real error would help.
>[url]http://www.aspfaq.com/2109[/url]
>

>> DSN was tested fine

>
>Stop using a DSN! Right now!
>[url]http://www.aspfaq.com/2126[/url]
>
>--
>Aaron Bertrand
>SQL Server MVP
>[url]http://www.aspfaq.com/[/url]
>
>
>.
>

[Aaron Bertrand - MVP]

If you find out the real error, we can help you. Please go over all of the
steps in [url]http://www.aspfaq.com/2109[/url] again, and determine the true error.
Also, make sure it is an explicit database problem, for example does the
following page work:

<%
response.write "foo"
%>

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




<anonymous@discussions.microsoft.com> wrote in message
news:9e7f01c43453$bceb8ca0$a601280a@phx.gbl...

> I tried all of them. None of them worked. Even viewer
> still does not show anything.
>
> I'm thinking in reformatting the server and install
> Windows 2003 from the scratch.
>
> I still can't believe that IIS 6 is not working for ASP
> pages with upgrade from Windows 2000 to Windows 2003.
>
> Has anyone out there had similar problem?
>
> Please help.
>

> >-----Original Message-----

> >>I have upgraded Windows 2000 to Windows 2003 server with
> >> IIS 6.0 and now I am getting an error when asp page

> tries

> >> to connect to the database.

> >
> >[url]http://www.aspfaq.com/2476[/url]
> >[url]http://www.aspfaq.com/2205[/url]
> >

> >> An error occurred on the server when processing the

> URL.

> >> Please contact the system administrator.

> >
> >The real error would help.
> >[url]http://www.aspfaq.com/2109[/url]
> >

> >> DSN was tested fine

> >
> >Stop using a DSN! Right now!
> >[url]http://www.aspfaq.com/2126[/url]
> >
> >--
> >Aaron Bertrand
> >SQL Server MVP
> >[url]http://www.aspfaq.com/[/url]
> >
> >
> >.
> >

I tried all that and it didn't work, returning same error
message

An error occurred on the server when processing the URL.
Please contact the system administrator.

Funny is that even though I do the following

Open Internet Services Manager, go to the home directory
tab of your default web site or application, click on
configuration, go to the Debugging tab, and make
sure "Send detailed error messages to the client" is
selected. Click Apply/OK/OK etc. to get out of there and
try your page again.

I get the same error without any additional detailed
error message.

>-----Original Message-----
>If you find out the real error, we can help you. Please

go over all of the

>steps in [url]http://www.aspfaq.com/2109[/url] again, and determine

the true error.

>Also, make sure it is an explicit database problem, for

example does the

>following page work:
>
><%
> response.write "foo"
>%>
>
>--
>Aaron Bertrand
>SQL Server MVP
>[url]http://www.aspfaq.com/[/url]
>
>
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:9e7f01c43453$bceb8ca0$a601280a@phx.gbl...

>> I tried all of them. None of them worked. Even viewer
>> still does not show anything.
>>
>> I'm thinking in reformatting the server and install
>> Windows 2003 from the scratch.
>>
>> I still can't believe that IIS 6 is not working for ASP
>> pages with upgrade from Windows 2000 to Windows 2003.
>>
>> Has anyone out there had similar problem?
>>
>> Please help.
>>

>> >-----Original Message-----
>> >>I have upgraded Windows 2000 to Windows 2003 server

with

>> >> IIS 6.0 and now I am getting an error when asp page

>> tries

>> >> to connect to the database.
>> >
>> >[url]http://www.aspfaq.com/2476[/url]
>> >[url]http://www.aspfaq.com/2205[/url]
>> >
>> >> An error occurred on the server when processing the

>> URL.

>> >> Please contact the system administrator.
>> >
>> >The real error would help.
>> >[url]http://www.aspfaq.com/2109[/url]
>> >
>> >> DSN was tested fine
>> >
>> >Stop using a DSN! Right now!
>> >[url]http://www.aspfaq.com/2126[/url]
>> >
>> >--
>> >Aaron Bertrand
>> >SQL Server MVP
>> >[url]http://www.aspfaq.com/[/url]
>> >
>> >
>> >.
>> >

>
>
>.
>

[Aaron Bertrand [MVP]]

All right, since even after multiple pointers to an article that describes
how to configure detailed error messages for server *AND* browser, how about
pointing us to a URL where this is happening, and *WE* can tell you what
error your server is having???

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]


<anonymous@discussions.microsoft.com> wrote in message
news:9e1701c43480$ac3095e0$a401280a@phx.gbl...

>I tried all that and it didn't work, returning same error
> message
>
> An error occurred on the server when processing the URL.
> Please contact the system administrator.
>
> Funny is that even though I do the following
>
> Open Internet Services Manager, go to the home directory
> tab of your default web site or application, click on
> configuration, go to the Debugging tab, and make
> sure "Send detailed error messages to the client" is
> selected. Click Apply/OK/OK etc. to get out of there and
> try your page again.
>
> I get the same error without any additional detailed
> error message.
>
>
>
>

>>-----Original Message-----
>>If you find out the real error, we can help you. Please

> go over all of the

>>steps in [url]http://www.aspfaq.com/2109[/url] again, and determine

> the true error.

>>Also, make sure it is an explicit database problem, for

> example does the

>>following page work:
>>
>><%
>> response.write "foo"
>>%>
>>
>>--
>>Aaron Bertrand
>>SQL Server MVP
>>[url]http://www.aspfaq.com/[/url]
>>
>>
>>
>>
>><anonymous@discussions.microsoft.com> wrote in message
>>news:9e7f01c43453$bceb8ca0$a601280a@phx.gbl...

>>> I tried all of them. None of them worked. Even viewer
>>> still does not show anything.
>>>
>>> I'm thinking in reformatting the server and install
>>> Windows 2003 from the scratch.
>>>
>>> I still can't believe that IIS 6 is not working for ASP
>>> pages with upgrade from Windows 2000 to Windows 2003.
>>>
>>> Has anyone out there had similar problem?
>>>
>>> Please help.
>>>
>>> >-----Original Message-----
>>> >>I have upgraded Windows 2000 to Windows 2003 server

> with

>>> >> IIS 6.0 and now I am getting an error when asp page
>>> tries
>>> >> to connect to the database.
>>> >
>>> >[url]http://www.aspfaq.com/2476[/url]
>>> >[url]http://www.aspfaq.com/2205[/url]
>>> >
>>> >> An error occurred on the server when processing the
>>> URL.
>>> >> Please contact the system administrator.
>>> >
>>> >The real error would help.
>>> >[url]http://www.aspfaq.com/2109[/url]
>>> >
>>> >> DSN was tested fine
>>> >
>>> >Stop using a DSN! Right now!
>>> >[url]http://www.aspfaq.com/2126[/url]
>>> >
>>> >--
>>> >Aaron Bertrand
>>> >SQL Server MVP
>>> >[url]http://www.aspfaq.com/[/url]
>>> >
>>> >
>>> >.
>>> >

>>
>>
>>.
>>