Cannot Deploy Report Model

I'm going through the 2005 SSRS tutorial for creating a report model and I
cannot deploy the model. The message I get is:
The permissions granted to user 'DOMAIN\USER' are insufficient for
performing this operation.
Both the SQL Server 2005 and SSRS are deployed on my machine on which I am
an administrator (both within the windows environment and in SQL Server).
Can someone please help?
Thanks,
JimI would imagine you are part of the Content Manager role on the report
server? Make sure your role on the report server has permission to Manage
Models and View Models. I had this problem when I upgraded from SSRS 2000 to
2005. For some reason none of the report model permissions were set after
the upgrade.
"Jim" wrote:
> I'm going through the 2005 SSRS tutorial for creating a report model and I
> cannot deploy the model. The message I get is:
> The permissions granted to user 'DOMAIN\USER' are insufficient for
> performing this operation.
> Both the SQL Server 2005 and SSRS are deployed on my machine on which I am
> an administrator (both within the windows environment and in SQL Server).
> Can someone please help?
> Thanks,
> Jim

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
David
Check the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||I'm also experiencing the same problem. I've checked the permissions on the related key in the registry, and have given Full Permission to all users, but to no avail. Any other suggestions?
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Cannot Create System DSN

Hi,
I'm having some difficulty creating a system DSN on a
win2K machine for connecting to a SQL 2000 server. I'm not
sure if this may be a better question for the windows
group, but... Anyway, when I go through the odbc setup in
windows, the DSN does not appear in the list of system
dsn's that are already created. I begin to create it, and
it says it already exists, "overwrite?". (this is because
I have already tried creating it with that name, and am
using the same dsn name. If I use a new name, I don't get
the "already exists" message, but the following problem
still occurs.) I do so, and continue through creating the
dsn and successfully testing the connection. When I
finish the creation, the dsn name still does not appear in
the list of system dsn's. Is this a corrupt odbc database
on the win2K machine? I have no idea!!! PS I am tryiing
to create it with local Administrator priveledges.
Any help would be appreciated.
Thanks
DavidCheck the permissions on the following registry key:
HKLM\Software\ODBC\ODBC.INI
Rand
This posting is provided "as is" with no warranties and confers no rights.|||I'm also experiencing the same problem. I've checked the permissions on the
related key in the registry, and have given Full Permission to all users, bu
t to no avail. Any other suggestions?
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Cannot Create Subscription

Using RS Standard, SP2, I am prevented from creating a subscription on
reports that I am able to schedule for snapshots. The error message says
"Subscriptions cannot be created because the credentials used to run the
report are not stored, the report is using user-defined parameter values, or
if a linked report, the report is no longer valid." There are no linked
reports involved, and there are both report parameters and query parameters,
but all have supplied values or defaults. (Since a snapshot works fine, it
would seem that criteria for a subscription would be satisfied). This is a
major problem for my users who believe subscription delivery is an essential
feature. Please help!
--
Bob RogersThen the only part of the error message your response didn't cover is the
credentials... They must be stored securely in the database... Go to the
datasource, and you may set the connection stuff to be stored in the
database... Then subscriptions can be made.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> Using RS Standard, SP2, I am prevented from creating a subscription on
> reports that I am able to schedule for snapshots. The error message says
> "Subscriptions cannot be created because the credentials used to run the
> report are not stored, the report is using user-defined parameter values,
> or
> if a linked report, the report is no longer valid." There are no linked
> reports involved, and there are both report parameters and query
> parameters,
> but all have supplied values or defaults. (Since a snapshot works fine,
> it
> would seem that criteria for a subscription would be satisfied). This is
> a
> major problem for my users who believe subscription delivery is an
> essential
> feature. Please help!
> --
> Bob Rogers|||Thanks for your reply. The database credentials were good; the problem
turned out to be user id being included in the template for report footer --
user id is apparently considered a parameter.
--
Bob Rogers
"Wayne Snyder" wrote:
> Then the only part of the error message your response didn't cover is the
> credentials... They must be stored securely in the database... Go to the
> datasource, and you may set the connection stuff to be stored in the
> database... Then subscriptions can be made.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Bob Rogers" <BobRogers@.discussions.microsoft.com> wrote in message
> news:1D97E909-7A7A-4617-ABF0-0610CF43B863@.microsoft.com...
> > Using RS Standard, SP2, I am prevented from creating a subscription on
> > reports that I am able to schedule for snapshots. The error message says
> > "Subscriptions cannot be created because the credentials used to run the
> > report are not stored, the report is using user-defined parameter values,
> > or
> > if a linked report, the report is no longer valid." There are no linked
> > reports involved, and there are both report parameters and query
> > parameters,
> > but all have supplied values or defaults. (Since a snapshot works fine,
> > it
> > would seem that criteria for a subscription would be satisfied). This is
> > a
> > major problem for my users who believe subscription delivery is an
> > essential
> > feature. Please help!
> > --
> > Bob Rogers
>
>

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..

|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe
|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe
|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..

|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe
|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe
|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..

|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe
|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe
|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe
|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create new or change existing subscriptions

We are having problems when creating new subscriptions or when trying to edit existing subscriptions. When editing an existing subscription, the report manager displays "An Internal error occured" message and when I look in the log the error says
Only members of sysadmin role are allowed to update or delete jobs owned by a different login

When trying to create a new subscription the report manager displays "An internal error occured" and the log says
System.Data.SqlClient.SqlException: The schedule was not attached to the specified job. The schedule owner and the job owner must be the same or the operation must be performed by a sysadmin.

We are running sql reporting services 2005 sp1. The report server database server is on a different machine to the reporting server. The existing subscriptions were set up previously on another report server which was originally our dev server. These subscriptions are working just can't change them, or create new ones.
Any help is much appreciated.

I had a similar issue only 2 days ago:
There seems to be a problem with the owner of the SQL Server Agent Jobs. In my case ( I couldn't change existing subscriptions but create new ones) the "old" subscriptions had "System" as owner and the new ones had "ASPNET". So I changed all owners to ASPNET and editing subscriptions worked again.
I got the same error as you when I tried to edit subscriptions, though System is also in the sysadmin-role of the server?!

Maybe somebody of microsoft can give some information whats the problem with the Agent Job Owners..

ps: I also moved the database from one server to another..
Calling RSKeyMgmt -a -f keyfile\key.snk -p report creates the Agent-Jobs but with the wrong owner..|||

Thanks for that. I played around with the owner of the jobs but still had the same problem. What I've done for now is delete the encryption key and create a user with sysadmin role on the database server and use that user to connect to database server from report server. I don't recall if the original user I set jobs up as had sysadmin role or if this is a prerequisite for subscriptions to work. I can deploy reports and users can view reports just have the issue with subscriptions. Can anyone let me know if running subscriptions requires a user with sysadmin role?

Thanks

|||

I had the same kind of problem !
Just open a newly created job (created by the reportmanager). Lookup the account, at my case 'NT AUTHORITY\NETWORK SERVICE' and replace the SYSTEM account with this one. (just replace it by hand not via the browse button).
From now on you can delete or update any report or its subscriptions etc

|||

I had a similar problem.

I guess only subscriptions created on a dev server were impacted. Subscriptions created on the prod server are fine.

Since the dev server subscriptions were only a few test made on dev that got transfered to prod when I restored the ReportServer db, I simply deleted them from the subscription table.

I also deleted as many As I could of the associated jobs but the UID makes this un-easy.

They sure is a way to create a query that gives you a list of subscriptions, there ID and the correpsonding job ID and the other way around also.

I always found very aggravating to have the job list filled with these reporting jobs. That is un-manageable and noisy.

Does anybody can share such nice to have management tool?

Thanks,

Philippe

|||

Just encountered the same problem with RS 2005 and this resolved my problem.

It is curious why one job out of four was running with the System account. Changed it to Network Service as you suggested and my changes worked! Thanks for the post.

|||This is a known issue with the RS subscriptions. Jobs are created with the owner set to the account specified for Database Connection setting (Windows account or RS service account). If this account is changed, then the problem occurs for existing subscriptions because SQL Server does not allow editing another owner's subscriptions without special rights. This issue is planned to be fixed in the next RS version.|||

I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

|||Hi,
This looks like a permission issue. Couple checks:
- Do you want your users (browser role) being allowed right to create subscriptions
- Is your userid linked to the correct role, i.e. Built in administrators or some other role with access to subscriptions.
Check the permissions, your problem should be there.
Philippe|||

Thanks Phillippe. I have logged in as admin and tring to create new subscription, the option is diabled for me. Is there anything I missed out while installation?

Please advice

|||Did you enabled Scheduled events and report delivery in the surface area configuration for Reporting services?
Philippe|||

Now I get error "Credentials used to run this report are not stored"

I am logged in as admin, what changes i need to make in order to create the subscription?

Please help

|||

Finally I was able to create a subscription, but still under Properties --> general folder I dont see any email options, what am i missing?

Please guide

|||Hi,
Getting closer.
Is it a data-driven subscription? I would guess it is not.
Now, how did you set-up the execution account, is it a (or your) windows account?
On my side, not able to get the thing to work as I initially thought it should with a Windows app account, I finally opted for the following model.
- Local SQL Server login "ReportingServices" with adequate read and execute rights
- All reports datasources use this local SQL server login (securely stored on the database :-)
- All reports use a User parameter so I know who runs the report and can control wether I serve data and what data I serve. The execution account remain the local "app" login which is stored in the database.

Next you have the problem of the email settings security. You have to enable the emails domains you want or you have to enable the emails domain alias property or you have to go though cumbersome AD complex querying scheme. I personally settled for the easy path of editing the XML config file to allow people typing complete email addresses.

I must admit that as I am not a MS insider and was just under the gun to get the thing out of the door, I may have settled for something less than best practice optimal security practice. i would not advertise my shortcuts as to be the way to go
It does not really matter in my case since I am behind lot of firewall and security and does not have the luxury of time to get it done 100% compliant. It works for me My point is;

If Microsoft could help us in an user friendly fashion make good use of security best practice without having to go through all the painful discovery process, it would certainly avoid a lot of us spending time just breaking the security until the basic functionality finally works.

So I call MS gurus to the rescue. And feel free to tell others not to do any of what I did to get it to work. I will surely be very humble and correct my mistakes ASAP.

Philippe|||

You are really kind to answer all my questions. I am going to meet our NT guy, to take his opinion. Will keep you updated.

Thanks once again

Cannot create index, timeout expires (SQL Server Express 2005)

I am having trouble creating a primary key on a large table (6 mil
rows)... on a SQL Server Express 2005 database...
After I make the changes to the table and Save, the operation starts
but times out after about 30 seconds, saying that the timeout has
expired.
I tried looking for a timeout that would govern this but I have not
been able to find one...
My query execution timeout is set to 0 (which is unlimited), though it
should be irrelevant because this is not a query.... (in fact, I have
no problem running quries that take a few mins)...
Any idea where/what I need to change to resolve this?
Thanks in advance.
<sdragolov@.gmail.com> wrote in message
news:1159639554.270613.108730@.c28g2000cwb.googlegr oups.com...
>I am having trouble creating a primary key on a large table (6 mil
> rows)... on a SQL Server Express 2005 database...
> After I make the changes to the table and Save, the operation starts
> but times out after about 30 seconds, saying that the timeout has
> expired.
> I tried looking for a timeout that would govern this but I have not
> been able to find one...
> My query execution timeout is set to 0 (which is unlimited), though it
> should be irrelevant because this is not a query.... (in fact, I have
> no problem running quries that take a few mins)...
> Any idea where/what I need to change to resolve this?
>
What tool are you using to run the query? Can you get a script of the
change and run it in a query window in SQL Server Management Studio?
David
|||Well, in theory it's not a "query", right? It's a DDL...
I am using Management Studio - I right click on the table,and do
Modify, then I select the two fields and right click and do "Primary
Key"... Then I finally do Save and that's where the error comes after
about 30 seconds...
I guess I could get the DDL text of adding these PKs and then try to
run that in a query window... though why would that be any
different...?
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159639554.270613.108730@.c28g2000cwb.googlegr oups.com...
>
> What tool are you using to run the query? Can you get a script of the
> change and run it in a query window in SQL Server Management Studio?
> David
|||<sdragolov@.gmail.com> wrote in message
news:1159647740.250757.210120@.c28g2000cwb.googlegr oups.com...
> Well, in theory it's not a "query", right? It's a DDL...
> I am using Management Studio - I right click on the table,and do
> Modify, then I select the two fields and right click and do "Primary
> Key"... Then I finally do Save and that's where the error comes after
> about 30 seconds...
> I guess I could get the DDL text of adding these PKs and then try to
> run that in a query window... though why would that be any
> different...?
Because it's the client tool that generates the timeout, not the server. If
Management Studio will give you the DDL, just run it in a new query window.
David
|||David - your suggestion did work... Thanks!
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159647740.250757.210120@.c28g2000cwb.googlegr oups.com...
> Because it's the client tool that generates the timeout, not the server. If
> Management Studio will give you the DDL, just run it in a new query window.
> David

Cannot create index, timeout expires (SQL Server Express 2005)

I am having trouble creating a primary key on a large table (6 mil
rows)... on a SQL Server Express 2005 database...
After I make the changes to the table and Save, the operation starts
but times out after about 30 seconds, saying that the timeout has
expired.
I tried looking for a timeout that would govern this but I have not
been able to find one...
My query execution timeout is set to 0 (which is unlimited), though it
should be irrelevant because this is not a query.... (in fact, I have
no problem running quries that take a few mins)...
Any idea where/what I need to change to resolve this'
Thanks in advance.<sdragolov@.gmail.com> wrote in message
news:1159639554.270613.108730@.c28g2000cwb.googlegroups.com...
>I am having trouble creating a primary key on a large table (6 mil
> rows)... on a SQL Server Express 2005 database...
> After I make the changes to the table and Save, the operation starts
> but times out after about 30 seconds, saying that the timeout has
> expired.
> I tried looking for a timeout that would govern this but I have not
> been able to find one...
> My query execution timeout is set to 0 (which is unlimited), though it
> should be irrelevant because this is not a query.... (in fact, I have
> no problem running quries that take a few mins)...
> Any idea where/what I need to change to resolve this'
>
What tool are you using to run the query? Can you get a script of the
change and run it in a query window in SQL Server Management Studio?
David|||Well, in theory it's not a "query", right' It's a DDL...
I am using Management Studio - I right click on the table,and do
Modify, then I select the two fields and right click and do "Primary
Key"... Then I finally do Save and that's where the error comes after
about 30 seconds...
I guess I could get the DDL text of adding these PKs and then try to
run that in a query window... though why would that be any
different...'
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159639554.270613.108730@.c28g2000cwb.googlegroups.com...
> >I am having trouble creating a primary key on a large table (6 mil
> > rows)... on a SQL Server Express 2005 database...
> >
> > After I make the changes to the table and Save, the operation starts
> > but times out after about 30 seconds, saying that the timeout has
> > expired.
> >
> > I tried looking for a timeout that would govern this but I have not
> > been able to find one...
> >
> > My query execution timeout is set to 0 (which is unlimited), though it
> > should be irrelevant because this is not a query.... (in fact, I have
> > no problem running quries that take a few mins)...
> >
> > Any idea where/what I need to change to resolve this'
> >
>
> What tool are you using to run the query? Can you get a script of the
> change and run it in a query window in SQL Server Management Studio?
> David|||<sdragolov@.gmail.com> wrote in message
news:1159647740.250757.210120@.c28g2000cwb.googlegroups.com...
> Well, in theory it's not a "query", right' It's a DDL...
> I am using Management Studio - I right click on the table,and do
> Modify, then I select the two fields and right click and do "Primary
> Key"... Then I finally do Save and that's where the error comes after
> about 30 seconds...
> I guess I could get the DDL text of adding these PKs and then try to
> run that in a query window... though why would that be any
> different...'
Because it's the client tool that generates the timeout, not the server. If
Management Studio will give you the DDL, just run it in a new query window.
David|||David - your suggestion did work... Thanks!
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159647740.250757.210120@.c28g2000cwb.googlegroups.com...
> > Well, in theory it's not a "query", right' It's a DDL...
> >
> > I am using Management Studio - I right click on the table,and do
> > Modify, then I select the two fields and right click and do "Primary
> > Key"... Then I finally do Save and that's where the error comes after
> > about 30 seconds...
> >
> > I guess I could get the DDL text of adding these PKs and then try to
> > run that in a query window... though why would that be any
> > different...'
> Because it's the client tool that generates the timeout, not the server. If
> Management Studio will give you the DDL, just run it in a new query window.
> David

Cannot create index, timeout expires (SQL Server Express 2005)

I am having trouble creating a primary key on a large table (6 mil
rows)... on a SQL Server Express 2005 database...
After I make the changes to the table and Save, the operation starts
but times out after about 30 seconds, saying that the timeout has
expired.
I tried looking for a timeout that would govern this but I have not
been able to find one...
My query execution timeout is set to 0 (which is unlimited), though it
should be irrelevant because this is not a query.... (in fact, I have
no problem running quries that take a few mins)...
Any idea where/what I need to change to resolve this'
Thanks in advance.<sdragolov@.gmail.com> wrote in message
news:1159639554.270613.108730@.c28g2000cwb.googlegroups.com...
>I am having trouble creating a primary key on a large table (6 mil
> rows)... on a SQL Server Express 2005 database...
> After I make the changes to the table and Save, the operation starts
> but times out after about 30 seconds, saying that the timeout has
> expired.
> I tried looking for a timeout that would govern this but I have not
> been able to find one...
> My query execution timeout is set to 0 (which is unlimited), though it
> should be irrelevant because this is not a query.... (in fact, I have
> no problem running quries that take a few mins)...
> Any idea where/what I need to change to resolve this'
>
What tool are you using to run the query? Can you get a script of the
change and run it in a query window in SQL Server Management Studio?
David|||Well, in theory it's not a "query", right' It's a DDL...
I am using Management Studio - I right click on the table,and do
Modify, then I select the two fields and right click and do "Primary
Key"... Then I finally do Save and that's where the error comes after
about 30 seconds...
I guess I could get the DDL text of adding these PKs and then try to
run that in a query window... though why would that be any
different...'
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159639554.270613.108730@.c28g2000cwb.googlegroups.com...
>
> What tool are you using to run the query? Can you get a script of the
> change and run it in a query window in SQL Server Management Studio?
> David|||<sdragolov@.gmail.com> wrote in message
news:1159647740.250757.210120@.c28g2000cwb.googlegroups.com...
> Well, in theory it's not a "query", right' It's a DDL...
> I am using Management Studio - I right click on the table,and do
> Modify, then I select the two fields and right click and do "Primary
> Key"... Then I finally do Save and that's where the error comes after
> about 30 seconds...
> I guess I could get the DDL text of adding these PKs and then try to
> run that in a query window... though why would that be any
> different...'
Because it's the client tool that generates the timeout, not the server. If
Management Studio will give you the DDL, just run it in a new query window.
David|||David - your suggestion did work... Thanks!
David Browne wrote:
> <sdragolov@.gmail.com> wrote in message
> news:1159647740.250757.210120@.c28g2000cwb.googlegroups.com...
> Because it's the client tool that generates the timeout, not the server.
If
> Management Studio will give you the DDL, just run it in a new query window
.
> David

Cannot create database

I am getting the following message while creating SQL Database on my local machine in Visual Studio:

An error has occured while establishing a connection to the server. When connecting to SQL Sever 2005, this failure may be caused by the fact that under the default settings SQL Sever does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Sever/Instance Specified)what address are you trying to connect via?

Cannot Connect to SSAS using Reporting Services 2005

I am creating a report in Reporting Services 2005 that is using a data cube that has been created in SSAS 2000. I cannot connect to the Cube. If I preview the cube in Reporting Services, I can see the data, however, after deploying the report, I cannot view the data on the webpage. The following error is displayed :

An error has occurred during report processing.

Cannot create a connection to data source 'Conn_FR'.

A connection cannot be made. Ensure that the server is running.

No connection could be made because the target machine actively refused it

I have also tried to connect to the analysis server using SSMS and the connection failed stating

No connection could be made because the target machine actively refused it

I read another post that said that connection from SSMS to SSAS 2000 is not supported, is this the same case for Reporting Services 2005 to SSAS 2000?

Since you can see the cube in the RS designer I assume that you have a problem with the security credentials in Reporting services 2005. You must supply a valid windows account in Report Manager and map that account to a role in AS2000 or AS2005.

Regards

Thomas

|||

Thanks for the reply,

I have been set up as administrator on the server that analysis services is installed on. But still no access.

I am still concerned that the connection between SQL 2005 and Analysis Services 2000 is not supported.

Thanks

|||You have to make sure that all the accounts line up with the right credentials. What account is SSRS running under? Does that account have permissions on the cube?|||

Is the webserver and reporting services on a separate server than AS2000? If so you you will also have to consider the use of Kerberos for security and account validation.

Check what you have been recommended to do, previously, and check Kerberos authentication after that.

Regards

/Thomas

|||

First, the SSRS and SSAS are on different servers. The user that is being used is a domain account with admin rights on both servers.

I am not sure if this helps, but below is the error details that are beind displayed:

===================================

Cannot connect to DBServer2.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)

at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

No connection could be made because the target machine actively refused it (System)

Program Location:

at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

Thanks for the feedback thus far...

|||

Check out the connection troubleshooting guide: http://www.sqljunkies.com/WebLog/edwardm/

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.