I am trying to get started with Reporting Services, and I am trying to configure the report server on my local computer running vista and sql server 2005.
I am trying to configure according to the following instructions:
But I got stuck on the step 11 to 13, I get the following error when I click on Apply (STEP 13)
ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 800708AC
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)
do I need to create a user for the reporting services or can I use my own user, which has admin rights on my laptop? Do I need to to do anything before I follow the instruction from http://msdn2.microsoft.com/en-us/library/aa545752.aspx ?
I also need to know how to delete the dabatases I ended up creating using Reporting Services Configuration Manager.
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
I'm having problem with initialization tab on Configure Report Server
All tabs are checked and green , but when I click initialize I got this error:
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
There are some complex reports in my report server, so I want use scheduled snapshot to improve the performance. But I don't want the generation of snapshot effect other report. Is it possible I create another report server, and use the same reportservertempdb database but the reportserver database is different. Then I can configure the second server create the snapshot automatically. In other words, I want to configure 2 report server share the same snapshot or cache. Is it possible?
And another question is if I can configure the parameter value which will be used in snapshot generation.
I'm trying to set up SharePoint Integration for our report server. The setup we have is: 1. SQL server hosting the SharePoint databases and the Reporting Server, 2. SharePoint web front end hosting all SharePoint services. I've installed the reporting services SP2 on the SQL server and the reporting services add-in on the SharePoint server.
I configured the report server following the directions here: http://download.microsoft.com/download/f/d/c/fdcb3a53-0cb1-4e67-a1b6-45b89b3c59cf/readme_rsaddin.htm and here: http://www.sharepointblogs.com/helloitsliam/archive/2007/02/21/19801.aspx
Everything seems to be set up correctly, but when I open the Reporting Services Configuration Manager, the SharePoint Integration option shows the error, "The report server cannot access setting in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model...."
I do have WSS 3.0 installed on the report server.
When I look in the logs on the report server it says the login failed for the account I have set as the Windows Service Identity however, when I look at the logs on the SharePoint server it shows that it is granting the account read and write access to each of the SPWebApplications I have set up.
When I opened "Reporting Service Configuration Manger" from SQL server configuration tool list, The "Report Server Installation Instance window came out. It showed my local machine name on the field of Machine Name. When I click "Find" button, a message box came out. It says: "No report server were found on the specified machine. Details: Invalid namespace
I'm having a world of trouble with the Reporting Services Server. The install went fine. I went in to configure the Report Server and when creating the Report Server and the Report Manager virtual directories I get the following error: "The virtual directory could not be created. The previously set virtual directory will still be used." The problem with this is that I have not previously set a virtual directory. When clicking on the link I get the additional error information: "System.IO.FileNotFoundException: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObject.InvokeMethod(String methodName, ManagementBaseObject inParameters, InvokeMethodOptions options) at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"
When I check IIS the directories were created but the Reporting Services Configuration Manager does not see them unless I attempt to recreate them again without deleting them from IIS.
I have SQl Server 2005 installed in local computer. I am planning to create report by Report Service so a report server is needed by which I can deploy report from my local computer to that server. How to intall the report server in another computer/
We've A2k db which we plan to migrate to SQL 7.0 very soon. Though am familiar with upsizing wizard BUT don't know how to configure Access forms, reports etc. to talk to SQL back end tables. So that information entered via Access forms can be stored in sql and reports can be generated using sql tables..
What are the steps in configuring sql server 6.5 to have excellent performance? what are the items that I should think of and based on what condition I can set up the configuration?
Hi All,Here is my questionWhat might you configure on a SQL Server so that a Web server runningon the same machine, with limited memory, will continue to performoptimally?Thank youRaju
I'm having a problem configuring one of my SQL servers as a distributor. I've done it successfully on another server, so I know that it's nothing procedural and there must be an issue with the way the server is set up. When I click 'finish' on the Configure Publication and Distribution Wizard, I get the following error message:
Enterprise Manager could not configure 'ABEL' as the distributor for 'ABEL'.
Error 20017: Cannot add the remote distributor at this time. Make sure that the local server is configured as a Distribution Publisher at the Distributor.
Can anyone point me in the right direction? I'm fairly new to SQL Server, so feel free to explain things in a condescending manner. ;-)
I have a SQL Server version 7.0 and want to configure IBM DB2 on OS 390 as a linked server on it . I installed DB2 clients on the SQL Server and thru DB2 Connect ,I am able to access the mainframe data using the clients . However I am having problems configuting the Mainframe server using IBM DB2 OLE DB Driver .I am not sure if we need to use Microsoft OLE DB Driver .
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
hi there! i have been trin to configure my network for the sql server 6.5 but in vain.Actually i have two pc in the network , one is server and the other is workstation.i install SQL server on the NT server and then install the sql client oon the workstation but i donno how to configure that client for the server. so i just want u leet me that what particular steps should i follow to make that network work properly for the sql server 6.5. i just wanna use sql server 6.5 in a simple situation. i am not an advance user of the sql server 6.5. i will be greatful to GOD if uu help in this problem. sincerely, romanafroz@hotmail.com
Server: Msg 18030, Level 16, State 1, Line 0 xp_sendmail: Either there is no default mail client or the current mail client cannot fulfill the messaging request. Please run Microsoft Outlook and set it as the default mail client.
How to configure Outlook and SQL Server Email next?
Hi, I have installed MS SQL Server on a win XP and a MS SQL Server client on a win2000. I don’t know how to configure this client to access the server remotely. Any pointer? Thanks. I am very new to SQL Server.
Hi All, I am new to SQL server 2005. I have installed SQL server 2005 which came along with the visual studio 2005 package. Now i could see the visual studio 2005 in the installed programs list. I really dont know how to configure the the installed SQL server. how to create tables and veiw. frankly speaking i could not see where is the head and tail.
To be straight forward, i havent used any database to a great extent. earlier during the starting of my career, i developed a small application using VC++, which used to interact with the DB server on a very minor scale; whenever i wanted to create a table for used to do it with sql client which was also installed in my machine.
currently i am againg devoloping a small apliccation using VC++, this time for devlopment and testing purposes, I have SQL server 2005 installed in the same machine which i am using for development. Now as i said eralier i am not even aware how to configure, how to start creating table...... :-(
all i have done is i have installed SQL server 2005 and all i could see is SQL Server 2005 listed in the installed programs list :-( some one please help me.... :-(
Hi everybody,I'm installing a network monitoring tool (OpManager). Duringinstallation I reached the following step: Configure the SQL Serverdetails.Host Name: ???Port: 1433Database Name: xxxUser Name: ???Password: ???I don't know which host name I need to put in and also I don't knowwhich user name and password is required.Please can anyone help me with this.Thank you!
I installed Micrsoft Server Desktop Engine from the CD I received in my ASP.net book. The installation went fine and then I went to the DOS prompt and did the "setup SAPWD..." and it ran. I restarted my computer and opened ASP Matrix and went to the Data tab and proceed to connect to the server. It gave me an error message it couldn't connect.
So I uninstalled MSDE and made sure the sql2ksp3 folder was gone. So I went ahead and installed the MSDE again from the CD again and then went to DOS to do the setup. It ran through the setup until the very end with 11 seconds remaining and received error message " Setup failed to configure the server. Refer to the server error logs and setup logs for more information. I have tried it several times and it always stops around 11 seconds. I have tried to install the download from microsoft.com instead the CD and that didn't work also. So at this point I am stuck. PLEASE HELP!
I also checked my Registry keys for a file called PendingFileRenameOperations and it wasn't in the registry keys.
If anyone has any suggestions I would appreciate it.
could anyone guide me on how to allow, ceate rule for sql server 2005 remote connections to work. i already configured my sql server to allow remote connections and also my router, it is only in isa that is blocking the connections.
While using aspnet_regsql.exe to configure SQL Server for application services, the following error pops up: Failed to query a list of databases names from the SQLserver. Cannot initilaize SSPI package". The page is "Select the Server and Database". Please advise. Thanks.
Hi I am trying to install SQL server 7 on XP. I did not install any prerequisite such as service pack 4. During the installation process, I received a error message that says:
'Setup fail to configure the server. Refer to server errorlog and cnfigsvr.out for more information. '
In Errorlog file, the last part of it says:
. . . SQL server's unicode collation is: 'English' (ID =1033) Comparison style =196609
SQL server's non-unicode sort order is: 'no case_iso'(ID=52)
SQL servers non-Unicode character setn is 'iso_1(ID=1)
I have a question. When my SQL server was originally configured, it was only setup to use named pipes. Now I am needing to setup a P&M server (through Site Server 3.0), but I must have my SQL server to accept tcp/ip network connections. I don't know how to enable named pipes & tcp/ip. Any help would be greatly appreciated.
1-We have sql server 2008 with 2 nodes with cluster(Active/Passive). 2-Due to performance problem we are going to separate the reports from database. 3-I want to create reporting server,as i am new for this pls let me know the step by step process to create reporting server. 4-Is it possible to create new instance for reporting in passive node and shear the cluster resources??
Login failed for user ''. The user is not associated with a trusted SQL Server Connection.
Ive got this error... I have just installed the SQL Server 2005 Standard Edition. Could anyone encounter and solve this problem.. please til me how to solve this. I google this but couldnt find a reliable solution for this..
Thanx...!
------------------- Real Programmer dont document
If its hard to write Then its easy to undertand. End If
I already asked this question at the MSDN forums, but I'm asking it here because I got conflicting answers.
I want to configure my server to allow remote connections. For some unknown reason, I'm unable to do this with the Surface Configuration Tool. My understanding is that I can accomplish this using the sp_configure stored procedure. Is this correct? If so, can someone please give me an example of the correct syntax? BTW, I'm running SQL Server 2005 on winxp pro sp2.
I am working on setting up our new SQL Server 2005 servers. One ofthem will eventually be our Replication Distributor. However when Iattempt to set this up within the wizard, I get the following error:------------------------------TITLE: New Publication Wizard------------------------------SQL Server could not configure 'ServerInstance' as a Distributor.------------------------------ADDITIONAL INFORMATION:Property LoginSecure cannot be changed or read after a connectionstring has been set. (Microsoft.SqlServer.ConnectionInfo)------------------------------BUTTONS: OK------------------------------In the "Specify the Domain or Machine account under which the Snap ShotAgent will run" page, I designate a Windows Auth. domain user; The sameuser that is used to start SQL Service. Any idea as to why I amgetting this error?