Problem while trying to login to admin

Server Error in '/' Application.

---

Syntax error converting character string to smalldatetime data type.

Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: Syntax error converting character string to smalldatetime data type.

Source Error:

An unhandled exception was generated during the execution of thecurrent web request. Information regarding the origin and location ofthe exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException: Syntax error converting character string to smalldatetime data type.]
 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +180
 LEInternational.admin.login.btnLogin_Click(Object sender, EventArgs e) in W:\le-international\admin\login.aspx.cs:87
 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33

 System.Web.UI.Page.ProcessRequestMain() +1292

---

Version Information: Microsoft .NET Framework Version:1.1.4322.2407; ASP.NET Version:1.1.4322.2407

Try to identify the T-SQL/stored proc that is causing this erros and post it here.

|||

I agree, it would help to see some code... It may be that you have some bad data in your database that won't convert to a smalldatetime. But it's impossible to know if the problem is in the stored procedure or your data without seeing the SP

Problem when accessing RS using fully qualified name or IP.

Hi,
I am using Reporting Services 2000 running on Win2k3. I have admin rights
for this machine.
Everything works just great if I am accessing Reporting services in our
intranet using http://server1/reports or http://server1/reportserver
But, When I view reports using fully qualified name e.g.
http://server1.mydomain.com/reports after entering username/password it shows
first page and when I click on any report item I get "The page cannot be
displayed" in the bottom frame.
Weird thing is if I access reports using
http://server1.mydomain.com/reportserver (simple file browse view) instead
of http://server1.mydomain.com/reports everything works fine.
Here is what I have tried after reading several posts.
I edited RSWebApplication.config located at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
Old setting:
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
New Setting:
<ReportServerUrl>http://server1.mydomain.com/ReportServer</ReportServerUrl>
When I apply the above setting I get the following error on the very first
page.
"The request failed with HTTP status 401: Unauthorized. "
I also edited RSReportServer.config located under \ReportServer folder but
still same error.
"The request failed with HTTP status 401: Unauthorized. "
Any help will be greatly appreciated.
Thx!
--
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing PlatformHelloooo guys, I found the solution.
After reading MSDN I found that <ReportServerExternalUrl> tag must be added
to use FQDN so you can access RS over internet. Report manager will use this
URL to redirect to the report server.
Modify the RSWebApplication.Config file located under \ReportManager folder
as below
e.g.
<UI>
<ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
<ReportServerExternalUrl>http://server1.mydomain.com/ReportServer</ReportServerExternalUrl>
</UI>
Correction to MSDN statement.
====================MSDN has half way correct information. MSDN states <ReportServerURL> must be
added but it has to be <ReportServerUrl> instead <ReportServerURL> (Note:
XML is case sensitive).
If you enter <ReportServerURL> instead <ReportServerUrl> you will get the
following error.
"The configuration file contains an element that is not valid. The
ReportServerExternalURL element is not a configuration file element."
Nayan Patel (MCSE, MCDBA, MCSD.net)
www.binaryworld.net
A Powerful Knowledge Sharing Platform
"Nayan" wrote:
> Hi,
> I am using Reporting Services 2000 running on Win2k3. I have admin rights
> for this machine.
> Everything works just great if I am accessing Reporting services in our
> intranet using http://server1/reports or http://server1/reportserver
> But, When I view reports using fully qualified name e.g.
> http://server1.mydomain.com/reports after entering username/password it shows
> first page and when I click on any report item I get "The page cannot be
> displayed" in the bottom frame.
> Weird thing is if I access reports using
> http://server1.mydomain.com/reportserver (simple file browse view) instead
> of http://server1.mydomain.com/reports everything works fine.
> Here is what I have tried after reading several posts.
> I edited RSWebApplication.config located at
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\
> Old setting:
> <ReportServerUrl>http://server1/ReportServer</ReportServerUrl>
> New Setting:
> <ReportServerUrl>http://server1.mydomain.com/ReportServer</ReportServerUrl>
> When I apply the above setting I get the following error on the very first
> page.
> "The request failed with HTTP status 401: Unauthorized. "
> I also edited RSReportServer.config located under \ReportServer folder but
> still same error.
> "The request failed with HTTP status 401: Unauthorized. "
> Any help will be greatly appreciated.
> Thx!
> --
> Nayan Patel (MCSE, MCDBA, MCSD.net)
> www.binaryworld.net
> A Powerful Knowledge Sharing Platform
>