SQL Server - SSRS 2008 lost ReportServer Users

Hi,
we have installed SSRS 2008.
In the dbo.users (from the ReportServer Database), are 501 records.
But if i open the web gui from the ReportServer web
i can only see about 100 users, where are the other ones?

2 Days ago everything was ok, in the meantime nothing has changed.
whats wrong? Any Idea?


Thanks a lot for any help!

  vinuthan replied to Ivo

Hi

can you check whether the users have been removed from the ReportServer DB,
dbo.Users table.

should be between minimum and maximum. thanks ujjp SQL Server Discussions Shrinkfile (1) Dbcc (1) Database (1) AndrewYes (1) LinchiHe (1) HiCan (1) Terabyte (1) SHOWFILESTATS (1) Hi Can you show the exact statement you use to shrink? Forget about SSMS. Use T-SQL DBCC SHRINKFILE directly. First, make the database your current database. Run DBCC SHOWFILESTATS to see which data file(s) has how much free space, and run DBCC SHRINKFILE accordingly. Linchi Linchi He / She tries to shrink 5TB database , I agree that the best is using T-SQL but I would try first with target size otherwise it may take forever (from my last experience to shrink 1.4TB database) Uri, The Truncate option means to not attempt to move any data, just chop off of trying the TRUNCATE option and see how was it going. . . We had 1.4T database with almost 500GB empty space, and running DBCC SHRINKFILE took 60 hours before we canceled two cents I used the dbcc shrinkfile command it was running for more than two days. We can use the truncate option for log file. Can we use the truncate option

Create view to get data from multiple databases SQL Server I have 26 databases database, Database, . . . . . . Database. I have a view as below that I want to modify so that it can Thanks sunny SQL Server Programming Discussions SQL Server (1) CREATE VIEW (1) UNION ALL (1) Database (1) Unpostedallcompany (1) Periodpost (1) Trandate (1) Assuming all database are on the same server, you can use UNION ALL: CREATE VIEW dbo.Unpostedallcompany AS dang / keywords: Create, view, to, get, data, from, multiple, databases description: I have 26 databases database, Database, . . . . . . Database. I have a view as below that I want to modify so that it can

Server Management Studio I open the Connect to Server box with these values: Server Type: "Database Engine"; Server name: "ICHIBAN \ SQLEXPRESS" which is the correct name for the computer and the No user action is required. 2008-12-27 11:28:20.90 spid7s Starting up database 'master'. 2008-12-27 11:28:21.09 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 00000003 2008 was started by login "sa". 2008-12-27 11:28:21.24 spid7s Starting up database 'mssqlsystemresource'. 2008-12-27 11:28:21.28 spid7s The resource database build version is 10. 00.1600. This is an informational message only. No user action is required. 2008-12-27 11:28:21.57 spid15s Starting up database 'model'. 2008-12-27 11:28:21.57 spid7s Server name is 'ICHIBAN \ SQLEXPRESS'. This functionality will not be available. 2008-12-27 11:28:21.81 spid7s Starting up database 'msdb'. 2008-12-27 11:28:21.87 spid15s Clearing tempdb database. 2008-12-27 11:28:22.23 Server A self-generated certificate was successfully loaded

Restore my live database as a test database SQL Server Hello, I have a live database and a test database on my sql 2000. I need to restore a backup of my live database to my test database. I want to make sure I have all the settings correct in Enterprise manager. This is what I have set. 1. I right clicked on my test database and went to restore. 2. In the restore database window, I have Restore as database set to the name of my test database 3