My Reports does not connect to the DB.

What are the connection string you are using. This type of error normally means a network connectivity issue. But since your application resides within our network, I can only assume that the connection string is incorrect. Can you connect directly to your database from your home PC? If you can then we can rule out the db server and focus on the connection configuration on your app.

rcp
DiscountASP.NET
www.DiscountASP.NET

 

the connection string is
Data Source=tcp:sql2k511.discountasp.net,14330;Initial Catalog=SQL2005_419765_sk00lmanager;

and at connect using, i specified SQL2005_419765_sk00lmanager_user as username and my password

 

Select the custom data source option instead of the shared data source and fill in the connection type/string sections.Also,select 'Credentials stored securely in the report server' under Connect Using section and populate the username and password field appropriately.

Vikram

DiscountASP.NET
www.DiscountASP.NET

 

• 
  <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
  • • 
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">I used the customdatasource and specified my creditenatials but I still get the error shown belowwhen i run the report..
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
      • 
        <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error has occurred during report processing.
        • 
          <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">Cannot create a connection to data source 'dsSchool'.
          • 
            <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
            <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
            <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">

 

Hi bruce [DASP]

I have seen your sample report and I followed your steps to createa report viewer on a .net page.

But I have an issue. My application sends a parameter to the page that houses the report.
whenever a browse to the page, i get this error on the report viewer

• 
  <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error has occurred during report processing.
  • 
    <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">Cannot create a connection to data source 'dsSchool'.
    • 
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.)
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">
      <LI style="DISPLAY: inline; FONT-WEIGHT: normal; FONT-SIZE: 8pt; FONT-FAMILY: Verdana">

I went to my report manager to run this report. I have already set up datasource and uploaded by report. I used a shared datasource .
When I run the report there, I get the same result. I believe I have a problem of having setup my reports to connect to my
database.

Please whats the way out

 

I have a support ticket since then I have not received good response


that will help me solve the problem


They keep to telling to send my connection string. Is there a way to contact the system administrator to rectify the issue





Thank you