When i open the Reporting Services Configuration Manager on our newly installed SQL 2005 box i get a red X on "Web Service Identity".
The window in question states that "The Web Service runs under the ASP .NET Machine account under IIS 5 or ..." with what looks to be a text entry box that is grayed out with the label "ASP .NET Service Account. The text entry box that is grayed out is blank.
When the Apply button is pressed a Task Status box opens at the bottom that states "There was an error setting the identity for the web service. The previously set identity will still be used."
When the option for "Tell me more about the problem and how to resolve it." is pressed i get a dialog box that has two lines of text reading:
"ReportServicesConfigUI.WMIProvider.WMIProviderException: An unknown error has occured in the WMI provider. Error Code 80070005"
Our report server is non-functional at the moment, and we really need it to work ASAP. Any help would be appreciated, thanks!
*edit*
when i try to open http://localhost/reports i get the message that "The report server is not responding. Verify that the report server is running and can be accessed from this computer.
I have two webservers and another server where the database resides.. and in my webservers i have reporting serverices set up.. in my Report server configuration manager for Webserver 1, in the database setup tab i am specifying the remote the database server which i want to connect and i am providing the correct username and passwords to connect to the remote databse and when i specify the remote database username and password i can see all the databases listed in that server. So in server name i have specified the name of the sql server.. and in the Database name i have specified ReportServer and given credentails type as sql server credentials and given the correct username and password..
But when i give apply i am getting an warning or error saying that The database version (c.0.8.54) does not match the Report service installation. This version cannot be upgraded. You must use a different database.
and in internet explorer if i give http:\localhost eports I get an error saying The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue update the version of the report server database and verify access rights.
I'm Getting "Report Server WMI Provider error: Not Found" when trying to Grant Database Access while configuring the Reporting Sevices Integration. Logging in fine to the DB. Tried all the WMI troublshooting and can't find any issues there. Any tips?
I have installed reporting services for 64 bit SQL and I am having a problem configuring it correctly so that I can access the reports manager on http://localhost/reports.
I have studied various SQL server 2005 bibles and looked at information on the microsoft support site but nothing seems to be helping me.
I get the impression that it could be a problem with the IIS server.
Can anyone give me a complete run down on how to set up and configure the reporting services so that it will actually work. Every step of the way please.
I have been trying to configure SQL Server 2005 Report Services. Every time I create the ReportServer database, the systems asks me if I want to "update" the database. It allows me no other option. When I click "apply", I get the message that the database version does not match my installation version. Does anybody have any insight into what happening with the configuration? What's more, do you have a solution?
hi all i try all date convertion function that u imagen in my asp.net project to insert a date to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00" how can i fix that from sql server plz
I have Visual Studio 2005 Professional installed and SQL Server Express installed. In following along with the Microsoft Visual C# Step by Step book, there is a procedure on page xxi to get access to SQL Server Express. At the 2> prompt, however, when I type in go and then press enter, I get the following message:
Msg 15247 Level 16, State 1, Server MyServerNameSQLEXPRESS, Procedure sp_grantlogin, Line 13
User does not have permission to perform this action.
The computer is my own personal computer, with Window Vista installed and no previous versions of MSDE installed. I also have administrator persmissions. The only guidelines in the procedure regarding what to do in the event of an error message is to ensure that the commands were typed in correctly. What could be causing this message, since I do have administrator permissions?
For some reason I can't seem to be able to add SQL databases to VWD
I receive the following error message:
Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
I have reinstalled SQL server but I still have the same problem, I tried tweaking some of the Server configurations without success.
I searched for hours on the web for answers but couldn't find any.
If anyone has any idea what could be the problem please help me.
My OS is Windows XP Professional SP2 IIS is installed.
I'm trying to configure a ReportServer in a Non-DefaltWebSite in my server. During the Reporting Server Configuration's process, everything works fine! All the informations are accept. But, when I try to access the address http://myserver.com/reportserver (or http://myserver.com/reports) a login message box is shown. I've already tried to enable a lot of user accounts, but with no success! I've read some articles that try to explain how to install a ReportServer in a Non-DefaultWebSite, but its doesn't work too.
Any sugestions?
My server is a Windows 2003 Standard Edition w/ SP1, IIS 6.0, SQL Server 2005 Express Edition Advanced Server.
I have setup a MYSQL server as a linked server in SQL SERVER 2000. I am able to select from a table using OPENQUERY as I understand that you can't use the 4 part qualifier to access an object from MYSQL as the ODBC driver does not expose the proper interface for this. The problem is that I cannot update,delete or insert into the OPENQUERY() table
eg. UPDATE OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') SET id = 0
INSERT INTO OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') VALUES(0)
DELETE FROM OPENQUERY(MySQL_LinkedServer,'select id from msqlTableTest') WHERE id = 0
This is the OLEDB PROVIDER FOR ODBC error I am getting...
The requested operation could not be performed because the OLE DB provider 'MSDASQL' does not support the required transaction interface. OLE DB error trace [OLE/DB Provider 'MSDASQL' IUnknown::QueryInterface returned 0x80004002].
I know there are brilliant Professionals on this forum. Please tell me that this is just an MDAC upgrade or something that is not configured correctly...
Hi all, I am new to SQL Server but I'm trying to learn it.. :) I've created a database on my campus server. Now I want to configure it so that I can access the database from my laptop computer through internet. I have an account in the SQL server installed on my remote server. I can connect to the remote server through remote connection.
I'm new to SQL Server (and databases in general) so I don't know what question to ask. I'll just be explicit about what I want to see.
What I need is SQL Server Express to install silently embedded in my application's installation (The user may already have SQL Server Express installed).
Once this is complete, in the SQL Server Configuration Manager under SQL Server 2005 Network Configuration, there should be an entry: Protocols for SONICI with Shared Memory, Named Pipes, and TCP/IP all set to Enabled.
When logging into SQL Server Management Studio there should be a choice for COMPUTERNAMESONICI and there should be a new folder Program FilesMicrosoft SQL ServerMSSQL$SONICI.
Here's what my installer launches from the command prompt: SQLEXPR32.exe -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SONICI SQLAUTOSTART=1
It doesn't work. And if I remove the /qn and run it, I get the message: "Microsoft SQL Server 2005 Setup was unable to install on your computer."
The log file reads: Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
I have no clue what is wrong and I can't find any helpful information on the web.
I have created profiles in my database as mentioned below. now i want to delete the profile created in database. can some one tell me how to proceed furthur.
i need to delete them permenantly. EXECUTE msdb.dbo.sysmail_add_account_sp @account_name = 'MyMailAccount', @description = 'Mail account for Database Mail', @email_address = 'makclaire@optonline.net', @display_name = 'MyAccount', @username='makclaire@optonline.net', @password='abc123', @mailserver_name = 'mail.optonline.net' ----------------------------------------------------- EXECUTE msdb.dbo.sysmail_add_profile_sp @profile_name = 'MyMailProfile', @description = 'Profile used for database mail' --------------------------------------------------------EXECUTE msdb.dbo.sysmail_add_profileaccount_sp @profile_name = 'MyMailProfile', @account_name = 'MyMailAccount', @sequence_number = 1
Attempting to link Access 2003 to SQL 2005, there is something keeping from doing so.
1 I setup the instance as sqlexpress.
2 I have a database shell there also.
3 It connects when I start the instance service.
4 My remote connections are configured to handle TCP/IP & Named Pipes.
Not in this order, but you get the idea. Now that I have these in place, I went first to the Access 2003 database to link the tables to this. When I came accross trouble in the form of need for a DSN to the domain for the things I created above.
In attempting to create one that looked functional, I came back to the same step. But, unsuccessful to link the tables again because browsing to that domain does not even show that particular file. This is the problem.
I do believe that once I am able to select a DSN, I will have a "healthy baby connection". I will then be the proud father of my first Server-side database setup!!!! But I am trying to get over these labor pains.
When I configure and test and OLEDB connection SQL Server 2005 keeps stopping with an error message as shown below. The problem seems to happen when I open the connection for ediing in Data Flow Window. There is a consistent pattern of errors (in there Event Log) relating to the Evnet Log prior to this error occurring.
Any idea what the problem is?
I have to say that my experience with SSIS has not been very encouraging so far.
Event Type: Error Event Source: MSSQL$SQL2005 Event Category: (2) Event ID: 17311 Date: 23/01/2007 Time: 2:06:41 PM Description: SQL Server is terminating because of fatal exception c0000005. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart).
We have push transaction replication from A database to 2 other B and C database. I have configured email to sent upon failure of subscription job of B and D database on Database A. Is this the way that we need to configure email to send when there is replication break up or failure.
Database is MS sql server 2008 R2 Publication Database: A Replication mode : Transaction Replication Replication used : Push Replication from database A Subscription Database: B and C
after i installed sql server 2005 DM add-ins, i tried using it with office 2007 so i choose (start---->all programs----->microsoft sql 2005 dm add-ins---->getting started) so the getting started wizzard was opened, i selected from it (use an existing instance of microsoft sql server 2005 analysis services that i adminster) because i already had a version of it installed on my computer. then i tried to connect to analysis services by selecting 'server name'=local host, an error appeared which is "unable to discover meta data on the server 'local host' . user noha needs to be adminstrator of the server to run the configuration tool". how can i be the adminstrator of the server?????????.........plz reply me soon,thanks in advance
- Microsoft SQL Server 2005 Standard Edition running on Microsoft Windows Server 2003 Standard Edition - Client Service for Netware installed. - Access 2000 database in a Novell Directory Services (NDS) Environment - SQL Server service running under local Administrator account.
Linked server configured as follow:
Linked server: MyDB Provider: Microsoft Jet 4.0 OLE DB Provider Product name: Access 2000 Data Source: UNC path to my Access database
Security: Admin with no password (default Access behaviour)
I can connect to my access database by following the next steps:
- Open Management studio on the SQL Server itself (where I'm logged in as Administrator) - Connect using Windows Authentication (Administrator) - Create a new query, run EXEC sp_tables_ex 'MyDB'
This will return all the tables from the Access database.
I can also make a view pointing to MyDB...MyTable.
Enough prove to me It can work....
So far so good
But now the tricky part.
When I login as 'sa', I can't connect and will receive the following message:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyDB" returned message "'Full UNC to my access database' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.".Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "MyDB".
(In real life I want to connect to my SQL 2005 Server from a ASP.NET (2.0) application using SQL authentication, but as long as I can't get the above working this is not important for now)
I would like to configure e-mail alerts on my SQL Server 2000 box.However, we also run Exchange on the same machine. I've been told therecould be conflicts/issues having Outlook on the same machine asExchange; and apparently, one needs Outlook to configure a mail profilefor SQL Server Agent.Is there, in fact, anything to worry about? If so, are there anywork-arounds beside moving Exchange to another server? (we've only gotone server, so this is not an option for us at this time).Thanks.- Dana
I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing.
So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running both SQL Server CE 2.0 and SQL Server 2005 CE to sync with either back-end server.
Can someone provide me with guidance as what is possible to set up here? I know that SQL Server 2000 and 2005 can be installed side-by-side on the same server. It also appears that you can set up SQL Server 2000 so that EITHER SQL Server CE 2.0 OR SQL Server 2005 CE can sync with SQL Server 2000 (see www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx), but I don't know if it's possible for BOTH SQL Server CE 2.0 AND SQL Server 2005 CE to sync to the same SQL Server 2000. As for SQL Server 2005 ... it appears to be possible to set up SQL Server 2005 so that BOTH SQL Server CE 2.0 devices AND SQL Server 2005 CE devices can sync to the same SQL Server 2005 (see web page cited above). However, I don't know if it's possible to set up a SQL Server 2005 server installation in this manner while at the same time having a side-by-side SQL Server 2000 installation supporting any level of mobile merge replication.
Hi My project is in .NET 2003 i.e. framework 1.1 and database in SQLServer 2000. But the reports have been developed using SQLServer 2005 Reporting Services. Now when I am trying to deploy them through deployment project of .NET its giving me following error:"Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. Now I am really confused with this. Can any one please guide me regarding this ASAP. Thanks, Falguni
I got through the installation hoops for SQLEXPRESS Reporting Services in Vista and set up the default configurations in Report Services Configuration. I can explore the default directory for "Reports" in IIS7, but I can't browse in IE. I get the "The report server is not responding. verify that the report server..." message in the browser. This is after I migrated the app per the initial http 500 error using the preferred method - %systemroot%system32inetservAPPCMD.exe migrate config "Default Web Site/Reports".
I'm running Vista Ultimate, VS2005, SQLEXPRESS SP2. I've tried running IE as admin and also I've disabled UAC from gpedit.msc - ...Windows SettingsSecurity SettingsLocal PolicySecurity Options and unchecking UAC.
I'm very new new at this. I'm try to deploy a report model and got this message. I have no idea what its going on about.
Can anyone help me?
Aku
------------------------------
System.Web.Services.Protocols.SoapException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> Microsoft.ReportingServices.Diagnostics.Utilities.RPCException: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) ---> System.Exception: Bad Data. (Exception from HRESULT: 0x80090005) --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.DataProtection.ProtectData(Byte[] unprotectedData, String tag) at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage() at Microsoft.ReportingServices.Library.Storage.NewStandardSqlCommand(String storedProcedureName) at Microsoft.ReportingServices.Library.DBInterface.GetAllConfigurationInfo() at Microsoft.ReportingServices.Library.RSService.GetSystemProperties(Property[] requestedProperties) at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.GetSystemProperties(Property[] Properties, Property[]& Values) (System.Web.Services)
Intel D975XBX 930 2GB ram HD 300GB - MatroxVD Windows XP Sp2 + updates Visual Studio 2005 Professional edition SQL Sever 2005 Standard Edition
20070203 Install Practice Files at D:Program FilesMicrosoft PressVisual C Sharp Step by Step.
Configuring SQL Sever Express Edition Hostname - xxxxxxxxx..
At sqlcmd s xxxxx...SQLExpress E got - Pipes error.
Open Microsoft SQL Sever 2005 - Configuration Tools SQL Configuration Manager select Protcols for SQLEXPRESS select Named Pipes enable close.
At sqlcmd s xxxxx..SQLExpress E get Sqlcmd: : Unknown Option. Enter -? for help.
Chdir C:Documents and SettingsAll UsersStart MenuProgramsMicrosoft Server 2005 Sqlcmd s xxxxxx..SqlExpress E Hresult 0x2, Lvel 16, State 1 Named Pipes Provider: Couldnot open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
How do I fix this?
Need to be able to to use the Northwind Traders data base
every 1 hour my server's computer is restarting ! when the windows finish restarting i open the Event viewer and see that what coused it is the error :
"Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database." Event 107 source : "Report Server Windows Service (MSSQLSERVER)"
When I trying to configure Reposrting services in IIS & XP. It hsows me error "The report server is not responding. Verify that the report server is running and can be accessed from this computer."
I also configure with reposrting configuration tools which show all confuguration is perfect.
but when I try to open through IE http://localhost/Reports/Pages/Folder.aspx
or http://localhost/Reportserver
It shows error. I try all ways still not works ..Help me out
I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?
Recently, several of our users have started to experience issues with hyperlinks in a report. I have created a textbox added navigation and selected the report to 'jump to' and the users are getting this error:
The specified server url does not link to the report server for this report manager or is not in the correct format
I have changed this to a an url but the error persists - there is nothing on google or MSDN that i can find which relates to this error so im kinda stuck with this one! The error is not affecting all users, just a small subset of them. Each of the users has different AD rights with one of them being a Domain Admin so i dont think it is a security issue.
*obviously the <SERVERNAME> and <REPORTNAME> are not real server or report names - im just being cautious by not including this detail on a forum post.
Report manager is installed on several machines as part of a webfarm but this has not caused any problems in the past (i have over 200 reports under my belt thus far)
I went to my comp ->rt cick->manage-IIS->default website->rt click->properties->directory security->annoymouse access¦EDIT->under Default domain it was blank, and i added a domain there.
And i was getting error opening up the reports from localhost.
I changed everything to same as it was previosly, and I am getting the error:
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) (rsRPCError) Get Online Help
Cannot open database "ReportServer$SQLExpress" requested by the login. The login failed. Login failed for user 'NGESComputer name$'.