How to set user for deploying reports?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How to set user for deploying reports?

How to set user for deploying reports?

Rate Topic

Display Mode

Topic Options

Author

Message

Jasmine D. Adamson

Posted Wednesday, January 30, 2013 4:55 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

When I deploy my report from BIDS (2008) it doesn't ask me for a user name, it picks a user and tries to use that user to do the upload, but that user doesn't have permissions. So, how to set the user which is used for deployment?

Basically, it's the opposite of this question - he wants to get rid of the login box and I want to see it at least one more time...
http://www.sqlservercentral.com/Forums/Topic523146-147-1.aspx

This is the output I get...
------ Deploy started: Project: VeriservReports, Configuration: Debug ------
Deploying to http://MYSERVER/ReportServer
Deploying data source '/Data Sources/DS_Veriserv'.
Error rsAccessDenied : The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.
Deploying data set '/Datasets/ValidCaseIDs'.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Deploying data set '/Datasets/ValidServiceIDs'.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Deploying report '/VeriservReports/Footer'.
Error rsAccessDenied : The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Cannot deploy the report because the shared data source '/Data Sources/DS_Veriserv' that the report references does not exist on the report server.
Publishing report parts in report 'C:\Users\dadamson\Documents\Visual Studio 2008\Projects\VeriservReports\VeriservReports\bin\Debug\Summary.rdl'
Publishing report part 'Image2' to '/Report Parts'...
Error : Failed to deploy report part 'Image2': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'serviceId' to '/Report Parts'...
Error : Failed to deploy report part 'serviceId': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'caseId' to '/Report Parts'...
Error : Failed to deploy report part 'caseId': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report part 'Tablix9' to '/Report Parts'...
Error : Failed to deploy report part 'Tablix9': 'The permissions granted to user 'MyDomain\MyUserName' are insufficient for performing this operation.'.
Publishing report parts complete -- 0 succeeded, 4 failed, 0 skipped

Question is... how to change the "MyDomain\MyUserName" to a legit user?

Post #1413797

Jasmine D. Adamson

Posted Thursday, January 31, 2013 12:55 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

I found out how to fix it. It's in the Control Panel->User Accounts->Manage Your Credentials

One of the things in the "Vault" was the user it was picking for deployment. Deleting that user allowed me to click "Deploy" in BIDS and have it ask for the login again. Then I could enter a login which works.

Post #1414297

mmartin1

Posted Wednesday, April 17, 2013 10:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192, Visits: 640

So you deleted a local user account? Be careful this does not cause issues in other areas.

Post #1443375

Jasmine D. Adamson

Posted Wednesday, April 17, 2013 11:24 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

Well I hope it doesn't cause any "issues" because I don't have that job any more and I'm never speaking to them again!

Post #1443395

mmartin1

Posted Wednesday, April 17, 2013 11:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192, Visits: 640

Sorry to hear this. I won't ask for details.
Cheers

Post #1443404

Jasmine D. Adamson

Posted Wednesday, April 17, 2013 12:05 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

LOL, better things come up and sometimes you have to irritate someone in order to take advantage. I left in an unprofessional way, but I had to do it that way for my own good.

Post #1443419

Jeff Moden

Posted Wednesday, April 17, 2013 6:53 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 5:33 PM
Points: 32,902, Visits: 26,783

It's not meant as a criticism... just some advice because I've seen what has happened to others when they do such a thing. It's a very small world and even if you're absolutely correct in your reasons for doing such a thing, it can follow you in a very bad way.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1443568

Jasmine D. Adamson

Posted Wednesday, April 17, 2013 9:52 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

Oh yeah I know that, I've been doing this stuff for over 20 years. It isn't maybe as bad as I made it sound. I just didn't like the place. I had good reasons.

Post #1443587

mmartin1

Posted Thursday, April 18, 2013 10:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 4:43 PM
Points: 192, Visits: 640

It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.
Smile

Post #1443991

Jasmine D. Adamson

Posted Thursday, April 18, 2013 10:47 AM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, May 16, 2013 3:56 PM
Points: 280, Visits: 140

I only worked there for two months, and I didn't do anything and didn't get to know anybody - they all hated me for some reason. It really was weird. I've never been hired for a job before, and basically been told to sit there and do nothing all day. When I tried to go find some work to do, I accidentally stepped over some weird cultural boundary and offended someone. I've never encountered that before, but someone I spoke to about it said they thought it was a case of "I violated the caste system" and since 90% of the staff was straight from India, that kind of made sense. I am a take charge kind of person, and I made that clear in the interview, and if they didn't want someone who could take charge and get things done, they should have hired someone else. So, I had problems with the job assignment itself, problems with the people, and they didn't really need me in the first place. So, when I say I quit in an unprofessional way, what I mean is I walked into my supervisor's office at 4pm on a Friday and said "today is my last day here" because it really was the last day I could mentally handle, and I felt like I was wasting their money.

And when I say I didn't do anything, I mean the report this question is about, and some minor web site bug fixes are the only things I did for TWO MONTHS. You don't hire someone with over 20 years of experience and my salary requirements to post on Facebook all day. I need a challenge, and I'm worth it :)

Post #1444001

« Prev Topic | Next Topic »

Permissions