I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I? This is a 40 GB database so that would take quite some time to do.
Re: 3vl 2vl and NULL ...reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL... where I cannot leave MV behind unless I can find a better data model.... screen to be identical to the logical data model of the database.... (comp.databases.theory)
Re: Reporing service failure ... I understand that when you tried to configure your database for your SQL ...Server Reporting Services, you encountered the logon failure error.... And then configure your SSRS databases via Reporting Services Configuration... (microsoft.public.sqlserver.security)
RE: Reporing service failure ... I understand that when you tried to configure your database for your SQL ...Server Reporting Services, you encountered the logon failure error. ... it was strange that the audit failure was for another user account NT ... And then configure your SSRS databases via Reporting Services Configuration... (microsoft.public.sqlserver.security)
Re: Need an expert advice ... This is the only database used for both OLTP and custom reporting.... Even with the reporting load moved to a different server,... (microsoft.public.sqlserver.datawarehouse)
Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database ... directly at the SQL 2005 database, ... Document List) must update the database directly with the GMT0 ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ... (microsoft.public.sharepoint.windowsservices)
