Showing posts with label userid. Show all posts
Showing posts with label userid. Show all posts

Thursday, March 8, 2012

Change the username in Active Directory

We use extended properties of Active Directory to filter the data in reporting services throw a web services. We send the userid (User!UserId) to the webservices and retrieve some information about the user.
But if we change the name of one user (rename not recreate), he lost all this properties. When try to execute a report show an error:
  • Parameter validation failed. It is not possible to provide valid values for all parameters. (rsParameterError) I know this issue is in the border of reporting services, but we have spent a lot of time without results and we need any help.

    Thanks in advance

    How are you doing your rename? Because that's where your issue is <s>.

    If you're doing it through some GUI interface and that interface doesn't transfer your extended properties on a rename, then that interface has a bug in it <sigh>.

    I do some AD coding but don't have an example I can throw in here. Basically, when any consumer queries AD for a user object, it is allowed to say what properties it's interested in retrieving. If it doesn't know about yours and doesn't retrieve them, it probably doesn't clone them along with the rest of the object. (I think, under the covers, a rename likely does a clone-and-delete.)

    So you have to write something that does know about your extended properties and write a better rename...

    >L<

    |||We rename the user in Active directory but i supposed that in some part of reporting services store the previous username, guid or something to refers to the old user. When we use the user!userID functions, reporting services get the old value instead the new value.

    Our process is:
    We have two parameters, one with the user and other with the information to retrieve and send to another queries. Send this two parameters to the web services and retrieve a parameter (a custom property defined in AD) to send in another query.

    We use directly in web browser the reporting services. And it is the default configuration of report server web.

    Thanks for your patience

    |||

    >>We rename the user in Active directory

    I know that's what you did. I asked you *how* you did this (through what interface).

    But, yes, if you're getting the old version when you look at user!userID, it doesn't matter.

    I don't see why the report server would be caching the previous user name etc, unless you have put this information in as the credentials of the user to run the report in the report configuration?

    Could this possibly be an AD refresh type of problem, instead? IOW, you do the rename and all the domain servers don't know about it?

    >L<

  • Friday, February 24, 2012

    Change SQL Server Connection from Enterprise Manager

    How can we change the login userid by SQL Server Enterprise Manager. I
    login with my Windows userid but the last time I used a SQL Server account it
    still uses that account when start SQL Server Enterprise Manager.
    How do I change Enterpise Manager to use my windows userid.
    Thanks,
    Hi Joe,
    In Enterprise Manager, right click on the registered server
    that you want to change the login for. Select Edit SQL
    Server Registration Properties. You can change the login
    information from there.
    -Sue
    On Wed, 26 Jan 2005 13:03:09 -0800, Joe K. <Joe
    K.@.discussions.microsoft.com> wrote:

    >How can we change the login userid by SQL Server Enterprise Manager. I
    >login with my Windows userid but the last time I used a SQL Server account it
    >still uses that account when start SQL Server Enterprise Manager.
    >How do I change Enterpise Manager to use my windows userid.
    >Thanks,