User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account
Control (UAC) restrictions have been addressed.
First time when you are configuring SQL server 2008 /R2 repoting server through Business Intelligence and try to access the server URL it throws this error message.
If you are not logged in as administrator it will throw this message.
Workaround:
Goto Internet Explorer (Run as admininstrator) enter the report server URL
http://"server name"/Reports"report server instance"/Pages/Folder.aspx
Enter the administrator credentials with domain name.
GOTO
1) Folder settings->New role assignment
2) Add the user name which is in the Domain to view the reports.
Now you can access the report URL with your credentials without administrator credentials.
If you know column name but to find out which table has that Do this: Select Name from sysobjects where id in (select id from syscolumns where name like '%userid%')
When you click on the expand button to view the child nodes the font of the child nodes are increased for each node. And you dont want to display in the increasing order and everythign should be in xx-small, Ex: Root(xx-small) - Child1(x-small) -Child1-1(Small) - child1-1-1(Medium)
Even if you give the Font-size XX-small in div or inside the telerik :radtreeview tag it wont take it.So assignt the Font size before binding to the each node.
In Sql server when you find ltrim and rtrim is not working.Then it must be some ascii characters added to it. You can find the ascii characters
DECLARE @Val VARCHAR(50) DECLARE @i INT
SET @Val = 'Pastehere ' SET @i = 0
WHILE @i <= DATALENGTH(@Val) BEGIN PRINT SUBSTRING(@Val, @i, 1) + ' : ' + CAST(ASCII(SUBSTRING(@Val, @i, 1)) AS VARCHAR(3)) SET @i = @i + 1 END
Once you find the ascii characters replace it with space '' or char(32) update REPLACE(City,CHAR(160),''),City from tblAddress where id=140 Then Trim it update ltrim(rtrim(City))from tblAddress where id=140