credentials type - service credentials missing

Hi All,

On my 64bit itanium cluster, how come when I open up my Reporting Services Configuration Manager and go to the "Database Setup", under "Credentials Type" I am missing the option "Service Credentials"? This is how I have my dev server set up and would like it to be the same.

This was due to us connecting to the individual node rather than to the cluster when opening up the reporting services configuration manager.

Credentials problem or deployment puzzle or permission problem?

Hi,All:

I had development a reporting service home page for our intranet . And I deployed this home page at "domain.server1" (for example) and my sql server database and reporting service is at another server "domain.server2"(for example). on the "domain.server1" , the Authentication methods is Integrated windows authentication. and on the "domain.server2" , with the reportingservice server properites and home folder, in the "permissions" tab, I had add the "domain.server1$" as system user role. so I can view my report via my home page and it works fine. If I remove the "domain.server1$" from the reporting service, there could be encountered an error "The permissions granted to user 'domain.server1$' are insufficient for performing this operation".

I used

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

in my home page to list the reports. I think this must be a problem, so I change this code as

System.Net.NetworkCredential myCreds = new System.Net.NetworkCredential();
myCreds.Domain = "domain";
myCreds.UserName = "UserName";
myCreds.Password = "Password";
rService.Credentials = myCreds;

and add this "UserName" to a local group "group1" on "domain.server2" , and grant this group "group1" to access the reporting service server. It works fine.

but now , I'm confused how to get the user's information (especially the password infomation , even though encrypted )?

Does any one can give me some feedbacks?

T.I.A

henry

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx?CommentPosted=true#commentmessage

I got the this scenarios a few days ago, after a few day's research.

I found that we must configurate the webServer as a trusted server so it can pass the credentials to the SSRS.

Allow a computer to be trusted for delegation

http://technet2.microsoft.com/WindowsServer/en/library/b207ee9c-a055-43f7-b9be-20599b694a311033.mspx?mfr=true

in the web applcation , we just set the Report viewer control credential like this:

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

we must configurate the webServer to support the Kerberos Authentication and Delegation

How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

http://support.microsoft.com/kb/215383

and It works.

Good luck!

Henry

Credentials problem or deployment puzzle or permission problem?

Hi,All:

I had development a reporting service home page for our intranet . And I deployed this home page at "domain.server1" (for example) and my sql server database and reporting service is at another server "domain.server2"(for example). on the "domain.server1" , the Authentication methods is Integrated windows authentication. and on the "domain.server2" , with the reportingservice server properites and home folder, in the "permissions" tab, I had add the "domain.server1$" as system user role. so I can view my report via my home page and it works fine. If I remove the "domain.server1$" from the reporting service, there could be encountered an error "The permissions granted to user 'domain.server1$' are insufficient for performing this operation".

I used

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

in my home page to list the reports. I think this must be a problem, so I change this code as

System.Net.NetworkCredential myCreds = new System.Net.NetworkCredential();
myCreds.Domain = "domain";
myCreds.UserName = "UserName";
myCreds.Password = "Password";
rService.Credentials = myCreds;

and add this "UserName" to a local group "group1" on "domain.server2" , and grant this group "group1" to access the reporting service server. It works fine.

but now , I'm confused how to get the user's information (especially the password infomation , even though encrypted )?

Does any one can give me some feedbacks?

T.I.A

henry

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx?CommentPosted=true#commentmessage

I got the this scenarios a few days ago, after a few day's research.

I found that we must configurate the webServer as a trusted server so it can pass the credentials to the SSRS.

Allow a computer to be trusted for delegation

http://technet2.microsoft.com/WindowsServer/en/library/b207ee9c-a055-43f7-b9be-20599b694a311033.mspx?mfr=true

in the web applcation , we just set the Report viewer control credential like this:

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

we must configurate the webServer to support the Kerberos Authentication and Delegation

How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

http://support.microsoft.com/kb/215383

and It works.

Good luck!

Henry

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

privatevoid Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = newDataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= newNetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

privatevoid Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = newDataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= newNetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials in Reporting Services?

I have created several reports in SQL Server 2005 reporting services and I am viewing those reports in my C# application using a report viewer control. I want to pass the credentials for each report through my applications. I do not want to use any web service.

Is it possible?

Any help will be appreciated!!!

TIA

YOu can use the URL Parameters to pass the username and the password, look in the BOL for more information, the syntax for that is:

prefix:datasourcename=value

as the prefix is dsu (for user) or dsp (for password)

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for your reply Jens!!!

But I am using a Report Viewer control in my application. How can I pass the username and password in this case?

|||Hi,
Hope this could help you

System.Net.CredentialCache myCache = new System.Net.CredentialCache();
myCache.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic", new System.Net.NetworkCredential("user", "pass"));

reportViewer.ShowCredentialPrompts = false;
reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache;
reportViewer.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
reportViewer.ServerReport.ReportServerUrl ="http://localhost/reportserver";
reportViewer.ServerReport.ReportPath = "/yourReportFolder/" + "yourReportName";
reportViewer.PromptAreaCollapsed = false;
reportViewer.RefreshReport();

|||

I am trying to use the example code provided for a simialr problem but the line (in VB)

reportViewer.ServerReport.ReportServerCredentials.NetworkCredentials = myCache

always shows as read only. How do I get round this please?

|||Hi ,
I think your using report viewer web control ofr asp.net. I had same problem.
Its won't work for Microsoft.Reporting.WebForms.ReportViewer.


But i hope this link could help you..

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=373983&SiteID=1

If you found the way please post back here.


Thanks & Best Regards|||

I am attempting to secure my reports with Windows Authentication, but allow users of my application to access it from the www and supply credentials through my app. My app is a .Net 2.0 Windows SmartClient, and I am using the ReportViewer control.

I tried the following suggestion:

reportViewer1.ServerReport.ReportServerUrl = new Uri(_txtServer.Text);

reportViewer1.ServerReport.ReportPath = _listBox.Items[_listBox.SelectedIndex].ToString();

reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;

CredentialCache cc = new CredentialCache();

cc.Add(new Uri("http://localhost/ReportServer/ReportService.asmx"), "Basic",

new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text));

reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = cc;

reportViewer1.ShowCredentialPrompts = false;

reportViewer1.RefreshReport();

...But I still get "The request failed with HTTP status 401: Access Denied." I am able to authenticate with the web service directly when requesting a list of available reports like this:

ReportingService rService = new ReportingService();

rService.Credentials

= new NetworkCredential(_txtUsername.Text, _txtPassword.Text, _txtDomain.Text);

CatalogItem[] catalogItems;

catalogItems = rService.ListChildren("/", true);

Why can I pass windows credentials to the web service directly, but not through the reportViewer call to reporting services? Any help would be very much appreciated!

|||

Hi Glenn,

You might have got the solution for your problem, If not and/or for other developers who might visit this blog, please find the solution at following link. Actually you can get it work by setting ImpersonationUser instead of NetworkCredentials property.

http://blogs.msdn.com/bimusings/archive/2005/11/05/489423.aspx

|||

You can refer following link.

http://msdn2.microsoft.com/en-us/library/microsoft.reporting.webforms.ireportservercredentials(VS.80).aspx

|||

Hi, you can try this, might help.

I pass the datasource credential through ReportViewer. It is the acutal database login credential instead of a net work credential. So in my application, which login user has nothing to do with Windows

network login user, I am using my application's user id and password to connect to datasource.

By doing this way, I can view a report using diffirent user id/password as long as they exist in the actual database.

It works for me.

private void Form1_Load(object sender, EventArgs e)

{

.............................

Microsoft.Reporting.WinForms.DataSourceCredentials myCredential = new Microsoft.Reporting.WinForms.DataSourceCredentials();

myCredential.UserId = "myuserid";

myCredential.Password = "mypassword";

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

DataSourceCredentials[] myCredentials=null;

if (reportdatasourcecollection.Count > 0)

{

myCredentials = new DataSourceCredentials[reportdatasourcecollection.Count];

}

for (int iIndex = 0; iIndex < reportdatasourcecollection.Count; iIndex++)

{

ReportDataSourceInfo datasourceinfo = reportdatasourcecollection[iIndex];

myCredential.Name = datasourceinfo.Name;

myCredentials[iIndex] = myCredential;

}

this.reportViewer1.ServerReport.SetDataSourceCredentials( myCredentials );

...............................

}

|||

Hi,

I am facing the same problem.

I used ReportDataSourceInfo then it gives error that DataSource doesnt support it. Error of rsdatasource

So what should be the Connection Methods in Shared DataSource?

Nilesh

|||

Me too there's an error here.

ReportDataSourceInfoCollection reportdatasourcecollection = this.reportViewer1.ServerReport.GetDataSources();

any thoughts please?

thanks.

|||

Ishwar,

Thanks for the link. That is awesome. I got it working using the following code.

ServerReport.ReportServerCredentials.NetworkCredentials

= new NetworkCredential(properties.Username, properties.Password, properties.Domain);

Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Credentials for Data Sources - Changing Authentication

I have Visual Studio installed on my local laptop, as well as on the report server. The only place reporting services is installed is on the report server.

I have a solution called “Performance Monitoring”, and within that solution is a report of the same name. That report uses 2 data sets, “DSOne” and “DSTwo” and these data sets are pulled from 2 shared data sources. I can edit the report locally and preview it just fine and the results are what we’re looking for.

Right now, the data sources are all set to Windows authentication. We would like to tie the data sources to a specific user ID and password, so that I or anybody else is able to view the report without having to have a separate login for all those people. I have tried changing the data sources' properties in Visual Studio to reflect using a specific login/pass (my own). I have tried this in Report Manager too – editing the data sources there to use my login and pass. Both of these methods have not worked.

In Visual Studio, in the Solution Explorer, I double click on one of the data sources and go to the credentials tab. “Use Windows Authentication” is checked, so I check “use a specific user name and password” instead and then enter my login and password. When I try to preview the report, it gives me the following error and I am stumped as to why this is:

“An error has occurred during report processing. Cannot create a connection to data source “DSTwo”. Login failed for user “xxx”.”

I have also tried editing the login and password through the “edit” button on the “general” tab of whatever data source I’m working with. The “Use Windows NT Integrated Security” box is checked, so I check the “Use a Specific Name and Password” box and again, type in my login info. When I hit “Test Connection”, I get the following:

“Test connection failed because of an error in initializing provider. Login failed for user ‘xxx.”

Hopefully this provided enough detail as to what the heck is going on here. I’ve been playing with these processes for a few days and for whatever reason, it is not working. I’m hoping somebody may have some insight as to why this is.

Thanks,
Matt

If you're using stored windows credentials, you need to check the "use as windows credentials" checkbox on the data source properties page.

-Lukasz

Creation of reporting database

We have a production database, but due to the crippling load of some
reporting tools, we are looking to have a separate reporting database.
Due to it's nature, the reporting database doesn't need to be as up
to date as the master, perhaps it could be refreshed every evening?
What I wish to know is the best way to go about this. Replicating a
whole database seems excessive as there are 7000+ tables and we don't
need it so closely matching the production database. Log shipping
also seems out as we need the reporting database to be highly
available and if we keep applying transaction logs ever 15 minutes or
so, we need to kick all the users out.
Is there a way of scripting or automatically getting SQL Server 2k to
copy over the last full backup it did and apply this to another
server? Also if we used this method, what would happen to the users
stored in the database? Would I have to keep re-adding them after the
upgrade?
Is there a better way to tackle this problem? All help gratefully
received. We are running SQL Server 2000 Enterprise Edition on a
Windows 2000 Server machine.
Thanks.Jonathan
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q314546#9 -- Move
Databases between computers running by sql server
"Jonathan" <nielsonj1976@.yahoo.co.uk> wrote in message
news:9db42c2b.0310200347.50044387@.posting.google.com...
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.
> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server? Also if we used this method, what would happen to the users
> stored in the database? Would I have to keep re-adding them after the
> upgrade?
> Is there a better way to tackle this problem? All help gratefully
> received. We are running SQL Server 2000 Enterprise Edition on a
> Windows 2000 Server machine.
> Thanks.|||Personally I would
1. Identify the tables that you need to report on.
2. Take them over to the reporting server
3. Create triggers on your Source tables and have them capture the data
that is entered, updated or deleted in those tables to a seperate table.
4. Build a DTS package that is fired by the SQL Server Agent every night
that will pick up those changes and migrate them to your reporting server.
This means that you are only taking across the things you need to. Using
the backup and restore method is easy but you will need to possibly unorphan
logins and also even if nothing changes during the day you are still going
to take across the whole database whereas in the other method you wouldn't.
Just my £0.02
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Jonathan" <nielsonj1976@.yahoo.co.uk> wrote in message
news:9db42c2b.0310200347.50044387@.posting.google.com...
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.
> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server? Also if we used this method, what would happen to the users
> stored in the database? Would I have to keep re-adding them after the
> upgrade?
> Is there a better way to tackle this problem? All help gratefully
> received. We are running SQL Server 2000 Enterprise Edition on a
> Windows 2000 Server machine.
> Thanks.|||Jonathan (nielsonj1976@.yahoo.co.uk) writes:
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.
If you only need a daily refresh, there is no reason to apply logs
every 15 minutes. Once a day would do.
Of course with that low frequency, moving the entire database may
be a more palatable task. As Allan pointed out, you need to fix
users and login each time then, whereas with log shipping you would
only need to cater for new users.
> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server?
Yes, you use the RESTORE and BACKUP commands. Read about them in Books
Online. And then you need to use some COPY command in the command-line
world to copy the backup file as it is not adviceable to backup or
restore from a network device. All this can be handled in a job from
SQL Agent.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Creation of reporting database

We have a production database, but due to the crippling load of some
reporting tools, we are looking to have a separate reporting database.
Due to it's nature, the reporting database doesn't need to be as up
to date as the master, perhaps it could be refreshed every evening?

What I wish to know is the best way to go about this. Replicating a
whole database seems excessive as there are 7000+ tables and we don't
need it so closely matching the production database. Log shipping
also seems out as we need the reporting database to be highly
available and if we keep applying transaction logs ever 15 minutes or
so, we need to kick all the users out.

Is there a way of scripting or automatically getting SQL Server 2k to
copy over the last full backup it did and apply this to another
server? Also if we used this method, what would happen to the users
stored in the database? Would I have to keep re-adding them after the
upgrade?

Is there a better way to tackle this problem? All help gratefully
received. We are running SQL Server 2000 Enterprise Edition on a
Windows 2000 Server machine.

Thanks.Jonathan

http://support.microsoft.com/defaul...en-us;Q314546#9 -- Move
Databases between computers running by sql server

"Jonathan" <nielsonj1976@.yahoo.co.uk> wrote in message
news:9db42c2b.0310200347.50044387@.posting.google.c om...
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.
> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server? Also if we used this method, what would happen to the users
> stored in the database? Would I have to keep re-adding them after the
> upgrade?
> Is there a better way to tackle this problem? All help gratefully
> received. We are running SQL Server 2000 Enterprise Edition on a
> Windows 2000 Server machine.
> Thanks.|||Personally I would

1. Identify the tables that you need to report on.
2. Take them over to the reporting server
3. Create triggers on your Source tables and have them capture the data
that is entered, updated or deleted in those tables to a seperate table.
4. Build a DTS package that is fired by the SQL Server Agent every night
that will pick up those changes and migrate them to your reporting server.

This means that you are only taking across the things you need to. Using
the backup and restore method is easy but you will need to possibly unorphan
logins and also even if nothing changes during the day you are still going
to take across the whole database whereas in the other method you wouldn't.

Just my 0.02

--

---------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Jonathan" <nielsonj1976@.yahoo.co.uk> wrote in message
news:9db42c2b.0310200347.50044387@.posting.google.c om...
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.
> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server? Also if we used this method, what would happen to the users
> stored in the database? Would I have to keep re-adding them after the
> upgrade?
> Is there a better way to tackle this problem? All help gratefully
> received. We are running SQL Server 2000 Enterprise Edition on a
> Windows 2000 Server machine.
> Thanks.|||Jonathan (nielsonj1976@.yahoo.co.uk) writes:
> We have a production database, but due to the crippling load of some
> reporting tools, we are looking to have a separate reporting database.
> Due to it's nature, the reporting database doesn't need to be as up
> to date as the master, perhaps it could be refreshed every evening?
> What I wish to know is the best way to go about this. Replicating a
> whole database seems excessive as there are 7000+ tables and we don't
> need it so closely matching the production database. Log shipping
> also seems out as we need the reporting database to be highly
> available and if we keep applying transaction logs ever 15 minutes or
> so, we need to kick all the users out.

If you only need a daily refresh, there is no reason to apply logs
every 15 minutes. Once a day would do.

Of course with that low frequency, moving the entire database may
be a more palatable task. As Allan pointed out, you need to fix
users and login each time then, whereas with log shipping you would
only need to cater for new users.

> Is there a way of scripting or automatically getting SQL Server 2k to
> copy over the last full backup it did and apply this to another
> server?

Yes, you use the RESTORE and BACKUP commands. Read about them in Books
Online. And then you need to use some COPY command in the command-line
world to copy the backup file as it is not adviceable to backup or
restore from a network device. All this can be handled in a job from
SQL Agent.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Creation of huge logfiles

HELP..
Since lats evening the SQL reporting services are generating huge logfiles
at dir ...\reporting services\Log Files\....
Because of limited space at our C-drive the whole server goes down. Please
does someone know how to configure reporting services to store the log files
at another drive and is it ok to delete the already present logfiles whitout
damaging the system'
ThanksI believe that is a known bug that has been fixed in SP2 or a hotfix from
last fall.
"Ronald de Rosa Spierings" wrote:
> HELP..
> Since lats evening the SQL reporting services are generating huge logfiles
> at dir ...\reporting services\Log Files\....
> Because of limited space at our C-drive the whole server goes down. Please
> does someone know how to configure reporting services to store the log files
> at another drive and is it ok to delete the already present logfiles whitout
> damaging the system'
> Thanks
>

Creation of a Setup Project

Is possible to create a Setup Project of a Reporting Services Project to install it in another Server ?
You may be better asking this Q in the reporting services newsgroup as this
group deals with Replication.
"Asphart" <anonymous@.discussions.microsoft.com> wrote in message
news:EA5A329A-9D6D-4E75-9721-4691A19E8A68@.microsoft.com...
> Is possible to create a Setup Project of a Reporting Services Project to
install it in another Server ?

Creating your own web-part?

I'm doing research on SQL Reporting Services 2005 and saw that for
integration w/ SharePoint Services, Reporting Services had two standard
web-parts. Is it possible to create your own web-part or customize the
existing web parts, using Reporting Services for SharePoint?
Thanks!Amita,
You can write using C# preferably your own. For more info
Visit http://blogs.sqlxml.org/bryantlikes/ Good one.
Amarnath
"amita.sanghani@.gmail.com" wrote:
> I'm doing research on SQL Reporting Services 2005 and saw that for
> integration w/ SharePoint Services, Reporting Services had two standard
> web-parts. Is it possible to create your own web-part or customize the
> existing web parts, using Reporting Services for SharePoint?
> Thanks!
>|||Thanks!

Creating SSRS folders?

New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>

Creating Simple Report using Reporting Services SP2 and SharePoint 2007 Integration

I've been running around in circles all afternoon trying to create one simple report using Reporting Services (with latest SP2 installed) and SharePoint 2007. To the best of my knowledge, I have everything configured correctly:

When I access http://<server>/ReportServer, I see the server name of my SharePoint site.

When I click on the name of my SharePoint site, it shows me the directory structure I have created within my SharePoint Site

When I drill down in the directory, I can ultimately see the forms I created in my forms library (created via InfoPath 2007).

The next step is to create one simple report from the data in one of these forms libraries and a report on all the items within a form library. I'm stuck at the first step of creating a report, namely what to enter as the Data Source and the connection string. With a SQL database this isn't an issue.

How does one create a data source that will allow reporting over SharePoint content with the setup described above? And, if you have information that is found in the SQL Books Online, please be kind and post links so others know where to find this information.

You may want to check out this thread on how to use a SharePoint list as a Datasource:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1154115&SiteID=1

HTH
Prash

|||

I've looked at that thread many times and was able to extract information from a list using web services. But, with Reporting Services SP2 integration with SharePoint 2007, I figured they would have included built-in support to create reports in BIDS that consume SharePoint Lists and Document Libraries.

Perhaps I'm not seeing the full extent to which Reporting Services SP2 integration is supposed to act. My thoughts were that a SharePoint integration mode would allow reports to not only be stored on SharePoint sites, but also allow reports to be about the SharePoint site itself.

|||

Reporting Services SP2 integration with SharePoint 2007 does not include built-in support for consuming SharePoint Site data to be displayed in a Report.

thanx,
Prash

|||

I tried to workaround this issue

by Creating Microsoft Access 2007 Database, using Linked SharePoint List as a tables, then I created Reporting Service Report Using this Database, in Visual Studio the Report is working fine by showing the data correctly but when you try it on the report server reporsitory directly or in the Windows SharePoint Service 3 site It doesn't work at all, it keep loading and loading until the error unexpected error appear if am running it from the sharepoint site. even thougth I configured the data sources correctly in sharepoint for the report

Any help on that

Thanks

Mohd

|||

Hi,

You may be interested by our Reporting Services Data Extension : ERSDE that lets you build reports using SharePoint lists.

Though it was initially built for SPS 2003/WSS V2 lists, most of the features still work with MOSS 2007/WSS V3. We will soon release an update for Moss 2007/Wss V3.

Frdric Latour

Enesys