.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

my username not shown in reportserver.dbo.user table

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

I would like to change ownerID in a subsciption table from old dba to mine. But in report server dbo.users table I cannot find my username.

I tried all kinds of things like loging using my account to upload files from report manager, create me as a system user in SSMS reporting server, but my username just not shown up in the users table. I'm also a member of local administrators.

Why it is not shown up in the user table?

Please help, Thanks


View Complete Post

More Related Resource Links

=User!UserID from windows authentication using table from another database



i'm using sql server 2005, sql server business intelligence development studio for my reports and deploy them in my wss3.0 site.

what i'm trying to do is i'm trying to restrict wich users can see specific data within a report.

now, the thing is. the report gets the data out of my DB1 database and my windows authenticated user are in the WSS_content database.

when i deploy my report in my wss3 site. it gets the user that is loged in. but of course it does not display any data because the tables are not in the same database.

does someone knows how to do this?

System.Data.SqlClient.SqlException: Login failed for user . Reason: The account is disable


Hi All,

Thank you for advance.

I created a widows service for mail schedule with c#.net and sql server 2005 and it is working fine for past one year.

now sometimes i am getting the "System.Data.SqlClient.SqlException: Login failed for user '<UserName>'. Reason: The account is disabled." error.

then i restarted the windows service manually and working.

what is the problem in my sql server connection and how to fix that issue?

How to setup db diagram to automatically insert username into table?

 I have a table setup in the database for users who are basically going to create a classified listing.  How can I setup a diagram that would easily create a table relationship with the Users table, so that it automatically inserts the users username when they submit a new ad?  If so, how?  I've tried adding a UserName row to my table and creating a relationship with the Users table "UserName" row, but it wasn't accepting the relationship when I tried to save the diagram...apparently because the UserName row in the Users table isn't a primary key?Also, one this is setup, what's the best way to provide the user a way to see a list of their ads and have the ability to edit them?

Creating a table-valued function on a user defined type in SQL Server CLR

We would like to be able to create a table-valued function on a user defined type.  We would like the syntax in SQL to look like it works for the XML nodes function:   DECLARE @myXml XML = '<a><b>1</b><b>2</b><b>3</b></a>' ; SELECT  node.query('text()') FROM    @myXml.nodes('a/b') nodes (node) ;   In other words, in the FROM clause, we can access the "nodes" method of the xml variable and it returns a rowset. Thanks!

how to include a user defined table type as input for stored procedure

Hi ,  I have a user defined table type which i need to pass as input parameter to the stored procedure .How can i do that?

Insert and Edit Pages with Web User Control Template for another table

Hi, I have an Address template(web user control) which holds the fields of the Address table.  The Address template is embedded in the School Insert Page.  I want to insert a new school together with its address(which means I have to insert a record into the address table).  Can you let me know how I can pass the newly generated addressId to update school table?  Also, how can I associate the Address.cs in the App_Code with the Address template?  I want it to be able to scaffold columns which needs to be hidden from user in the address table.  When I click on Insert School, the Address template shows in "insert" mode, I just need to link the two together. Thanks for your help! CC  

The specified user account "domain\username" is a local account. Local accounts should only be used

HI Im getting this error when trying to set a new Service account for my performance point services. SharePoint is installed in a single server enviroment. I can´t get a new service account configured and I think this is causing my server to run slowly. Any help would be highly appreciated thanks

Get inserted ids when inserting from User Defined Table Type

Imagine this procedure:   CREATE PROCEDURE [dbo].[insertActive] ( -- Add the parameters for the stored procedure here @p_data dbo.activeUpdate readonly) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. insert into dbo.active (name,stateid) select name,stateid from @p_data END How can I get the ids of the rows that have been inserted?  I tried searching the net and the forums but could not find anything. Thanks for any and all help, Gareth.

Execution Log table shows only one user

Hi,     Im trying to get a list of users who have accessed and run reports. Im using executionlog table to get this information but strangely all the reports are being run by a single username which same as the windows service login for reporting services. Is user logging when report is accessed and executed from Report manager different from running it through report server? Does this have any impact on users being entered in execution log table? One basic question: Does the service running SSRS need access rights to datasource for running a report? Any pointers to how the execution flows from a users desktop to the logging to that user in execution log table would be very useful..   Thanks Rakesh    

display of username in "domain/user" instead of "surname givenname"



we have a Sharepoint server 2010 running and at the top right of the website the username is showing like domain\username.

The same thing in documentlibraries and lists.

How can I change this to "surname givenname"?


I have configured a userprofilsync with our Domaincontroller and all of our users can be found in the Sharepoint Central Admin User Profils section with the correct Name.



inserting data to Users Table in ASPNETDB from Create User Wizard


When a user starts a membership using the Create User wizard supplied by the aspnetdb profile service, I need to add a field to a table in aspnetdb and upon clicking the ContinueButtonClick insert some data.  The field I'll add is "SubscId".  My first question is what table is best for this - Users or Membership?

Secondly, what is the best way to insert new data for this scenario?  code behind?  markup?  Can someone provide basic syntax of insert code in code behind for this scenario?

Why "sa" account is trying to obtain lock on user table?



I'm monitoring Lock:Timeout value on SQL database for specific table and specific type of lock (lock number 8). I'm seeing a lot of lock acquired/released as well as Lock:Timeout from "sa" account and listed as IsSystem=1.

Why is it happening. How do I catch in profiler specific details related to those locks?





P.S. This is on SQL 2008 x64 SP1.

filtering table contents shown in datalist


i am using this code to fill my datalist:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim myConnection As SqlConnection
        Dim myCommand As SqlDataAdapter
        myConnection = New SqlConnection("mydb")
        myCommand = New SqlDataAdapter("SELECT * FROM Posts", myConnection)
        Dim ds As DataSet = New DataSet()
        DataList1.DataSource = ds

    End Sub

it works and fills the datalist with the whole table..

when this page opens the address bar is like "www.example.com/threads.aspx?thread ID=123"

i would like the datalist to show all contents in the table with this specific thread ID.. thank you in advance :)

Hide Html table according to User Group

in my site i would like to hide an html table for specific user group , how do i do that with out using Visual Studio environment and with out using c# code is there any way that it can be done like in JavaScript , need a clear picture ....

Find User Password by Username Before Login


hi guys,

I have only username. and want to check and grab the password from the database. It is BEFORE LOGGING IN. so I don't think the build-in asp.net functions could be used, right?

thanks a lot!!

Get Username for logged in user

I am having trouble getting a logged in username to use on an intranet site. If I use User.Identity.Name.ToString I get a blank.

 If I use Environment.UserName.ToString  I get "Network Service".

If I run the application in debug locally I get the Domain\username but not when I run it on our intranet.




Referencing the membership user table


When creating a foreign key to the membership user table, is it better to refer to the user_id column or is it ok to use the username column?  I assume that the Membership spec enforces uniqueness in the username since there is a method Membership.GetUser(username) that returns one user.  Using the id is a bit awkward in code because I have to end up casting all over the place like (int)user.ProviderUserKey.  The username would give more information quickly when viewing raw data as well.  Just wondering if someone knows a reason why I shouldn't use it as the foreign key.



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend