January 30, 2013 at 4:55 pm
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...
[font="Courier New"]------ 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[/font]
Question is... how to change the "MyDomain\MyUserName" to a legit user?
January 31, 2013 at 12:55 pm
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.
April 17, 2013 at 10:32 am
So you deleted a local user account? Be careful this does not cause issues in other areas.
----------------------------------------------------
April 17, 2013 at 11:24 am
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!
April 17, 2013 at 11:41 am
Sorry to hear this. I won't ask for details.
Cheers
----------------------------------------------------
April 17, 2013 at 12:05 pm
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.
April 17, 2013 at 6:53 pm
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
Change is inevitable... Change for the better is not.
April 17, 2013 at 9:52 pm
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.
April 18, 2013 at 10:30 am
It's good if you still have friends there that can give you a reference. So don't burn your bridges completely.
🙂
----------------------------------------------------
April 18, 2013 at 10:47 am
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 🙂
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply