When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join " how i can change it.
please help me how i can change the configuration user and password for my singel farm server
Thanks , i fixed it ??
Hi All,
I want to deploy my reports in a Sharepoint site. So I need to change the Deployment mode from Native to Sharepoint Integrated mode. When go to Reporting Services Configuration and in Database Setup - the Server Mode option is not visible. Anyone help me what is the reason for this or How to get Server Mode option in Database Setup in Reporting Services Configuration menu. However the system installed with Sharepoint and SSRS SP2.
Thanks in advance,
Senthil
I need to install SSIS/SSRS in SSMS. I have connected the SharePoint list view to excel for reporting purpose but due to data size the performances is very slow in excel and now I would like to connect the SharePoint List to SSIS/SSRS
I have windows 8, 64 bit system
I have installed SQL Server Management studio 2012 but I am unable to enable the Integration and Reporting Services
May be I have missed to choose the option during installation.
Hello,There's information on my Internal SharePoint DataBase that I want to access. How can I do this? Could you help me or at least point me in the right direction.The information I am requesting is just text.Thank you,Mark
View 4 Replies View RelatedWhen trying to open the sharepoint webpage I'm getting this error - cannot connect to the configuration database sharepoint 2010.Database is on SQL server 2008.Tried opening the site on server - got the same error.Googled and tried to start the mssqlserver services (browser and sql server) but they fail to start with error code 17058.
Googled what this error was about and some solutions led me to check the error log in event viewer. For mssqlserver I got following message in the event proverties window - Could not open error log file <path of log file> ''. Operating system error = 5 (access denied).When I tried to login on the sql server management studio, it does not let me login and gives error -
I got to know that this can happen due to unexpected reboot of server. I checked my server and it had actually restarted unexpectedly.URL...
I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:
System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.
Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?
Many thanks to anyone who can help!
I am trying to load data from sharepoint to Database. WhenI try to execute the package, am getting below error.
[SHAREPOINT_SRC_SLTS_FIELDS [286]] Error: Microsoft.Samples.SqlServer.SSIS.SharePointUtility.SharePointUnhandledException: Unspecified SharePoint Error. A possible reason might be you are trying to retrieve too many items at a time (Batch size) ---> System.ServiceModel.FaultException: Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.
I was wondering if anyone else has come acress this iss or not...
I have a distrbuted environment....I have installed SP2, .NET 3.0, and the WSS Object Model on the SSRS server and setupa database for sharepoint integration. But, my issue is with the front end web server for MOSS. I install the sharepoint add in and go to Central Administration to configure the connection and other steps, but I do not see the Reporting Services section in the Applicaiton Management section of the Central Admin tool. Any ideas?
All of the SSRS steps are complete and when I view the RS config MGR everything looks good.
Thanks!
Erik
While trying to "Set Configuration Database Server" for Windows SharePoint Services I receive the error:
"Cannot open database "SharePoint" requested by the login.
The login failed. (Error code: 4060)"
I set up a test bed server 'SNET' with WinServer03 SP1, IIS 6. SQL Server Express, and SharePoint Services.
In "Set Configuration Database Server" I used:
Database server: snetsqlexpress
SQL Server database name: SharePoint (I know real imaginative)
Database connection type: * Use Windows authentication
X Connect to existing configuration database.
If I try "Use SQL Authentication"
"Login failed for user <username>. The user is not associated with a trusted SQL Server connection. (Error code: 18452)"
First let me say that while I'm not a newbie, as usual I've bitten off more than I can chew comfortably. Server '03, Active Directory, IIS 6, SQLExpress, and SharePoint are all relatively new to me, hence the test bed server, and I'm on a pretty steep learning curve.
But what's life without a challenge.
So the short and sweet of it is can somebody point me in the right direction to find the root cause of this error. I do have other programs running with this instance of SQLExpress and doing so quite happily. And I've given myself god privileges in AD just to try to get around this.
Hi,
I want to configure my Reporting Service.
And if I want to configure the Database Connection I the action
"Create a Grants Rights Script" fails.
I tried all credential types by it doesn't work.
Does anybody have an idea? Thanks for your help!
Jo-Jo
I have SQL 2008 R2 instance and would like to install SSRS 2012. I have below query related to database configuration...Is there any performance impact while using SQL 2008R2 instance?Once configured SSRS database on 2008 R2, Will there any issue if we move our SQL instance from 2008R2 to SQL 2012 in future?
View 3 Replies View RelatedHi!
I'm configuring now Reporting Services on SQL Server 2005 in Office Sharepoint Server 2007 integration mode. In the beginning of the process, I had already installed SQL Server 2005 with RS and Office SPS 2007. I used following guides to make further steps:
How to Configure Reporting Services to Use a Non-Default Web Site (Reporting Services Configuration)
How to Configure Service Accounts (Reporting Services Configuration)
How to Configure SharePoint Integration on a Standalone Server
How to Configure the Report Server Integration Feature in SharePoint Central Administration
Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services
So I installed RS add-in for SPS, made RS configuration and almost all SPS configuration. I stopped with error
"An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found. " in "Set server defaults" command.
My servers configuration is following:
1. Both RS and SPS are running on the same server.
2. I cannot change port of default web site, so I made different web site "Reporting services" under same web server with port 8086 (http://mtx-sps2007:8086/reportserver)
3. RS Windows service runs under domain system account that is a member of local Administrators group (account name sql2k5sps7)
4. RS Web service runs under NT AuthorityNetworkService account
5. Database connection configured using mentioned above account sql2k5sps7
6. Report Server Web Service URL in SPS is set to http://mtx-sps2007:8086/reportserver
7. Authentication Mode in SPS is set to "Trusted account"
8. My account, under which I make a connections through terminal services to SPS and RS servers and through http to reportingservices page is a member of local administrators group of both my PC and server.
9. I'm not familiar with SPS (honestly speaking, with RS too, but at least I learning this quickly, but SPS is out of my responsibilities scope)
10. ReportServer runs under separated app pool that runs under NT AuthorityNetworkService account
And now I'm fighting with this error on "Set server defaults" command. It's interesting that from my PC there is no credentials prompt when entering SPS administrations page and error is following:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode
But from terminal client, connected to SPS and RS server, there is a credentials prompt (I enter my credentials) and error is as mentioned abowe:
An unexpected error occurred while connecting to the report server. Verify that the report server is available and configured for SharePoint integrated mode. --> Server was unable to process request. ---> The request failed with HTTP status 404: Not Found.
Also, the same error I got when I tried to add a report to report viewer web part on SPS test page.
Can anyone help me with this? I would be greately appreciated to any help on resolving this issue.
Hi,
I tried to install sharepoint server 2007 as a standalone in my computer. When i run the sharepoint products and technologies configuration wizard, i get the following error,
Failed to create sample data.
An exception of type System.Data.Sqlclient.SqlException was thrown. Additional Exception information:
Cannot open database "SharedServices2_DB_28aa01d8************************" requested by the login. The login failed.
Login failed for user "domainAdministrator"
Please advice me to solve this issue.
Thanks,
Magesh S
I have installed SSRS 2012 Standard Edition in our DR site. We replicate over the reporting server databases over from our Production server via storage replication. It is on a different server than the reporting service. When I configure the SSRS in DR it is still seeing the SSRS from our Production server and tries to make it a scale out deployment which it is obviously not allowed to be because of the edition.Is there something in the database itself I need to change so it doesn't think the production server is still connecting?
View 0 Replies View Relatedhi all
i get the following message error when installing sql server 2005 express :
<< sql server setup could not connect to the database service for server configuration the error was :[microsoft][gestionnaire de pilotes odbc] source de données introuvable et nom de pilote non spécifié >>
is there any help
thanks and best regards
OS: XP-SP2
Not able to install SQL Express 2005.
------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x80090325
Needles to say, above link is useless..
I had managed to install previously, but ran into problems while trying to upsize an MS-Access database, I've tried everything from creating certificate to hacking away at the registry...Log-on with a different account, etc...Anybody knows how to get around this?
Here's part of the log file:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Sat Jun 03 20:09:53 2006
Machine : YANICK
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : YANICK
Product : SQL Server Database Services
Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The certificate chain was issued by an authority that is not trusted.
Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine : YANICK
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.00.1399.06
Install : Failed
Log File : e:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_YANICK_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}SSL Provider: The certificate chain was issued by an authority that is not trusted.
Error Number : 29515
--------------------------------------------------------------------------------
Yesterday, literally I was banging my head to the wall, kept getting this error:
A Connection could not be established with the information provided. Hit OK to change your connection settings.
Invalid object name 'sysdatabases'.
I uninstall and re-install back the reporting services couple times and I kept getting the same error.
I have 2 instances of SQL Server on the same Server:
SQL Server 2000
SQL Server 2005
The 2 instances work side by side, I was wondering if this causing the error.
Can anyone help out with this problem?
Thanks - John
Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks
hi,
I set up Reporting Services about 9 months ago when I installed Microsoft CRM 3 (Dynamics?), but these problems have only just started occurring. Lost count of how many hours have been wasted looking for answers!
Apologies if this rambles on like a cheap book but i don't want to miss out any of the detail..
CRM stops working within an hour of IIS starting up, but if somebody logs in to CRM before it goes down then it's fine for the rest of the day. However the next day it's back to square one. Looking through Event logs it seems to be caused by SQL Reporting Server, because;
Report Server errors show it starting up after IIS, but within an hour throws up "Exception: System.Runtime.Serialization.SerializationException - Message: Unable to find assembly 'Microsoft.ReportingServices.Diagnostics". It's at this point that IIS stops responding altogether, hence CRM stops working.
Running iisreset from the command line makes IIS work again, but this becomes a pain in the backside running it every morning before my colleagues get in. I have set up a schedule to run it for me, which works, but as i said if nobody logs in within the hour (which does happen at least once a week), then CRM won't work until i manually run iisreset again.
Also Reporting Services Configuration Manager does not start properly, so i can't even go through that to see if it's a config problem - when launching it i get an alert box with "An unknown error has occurred in the WMI Provider. Error Code 800706B3". That's with the default server name already in the box, but no matter what server name or IP I try to get it to connect to, it just will not have it. Also that error code seems to be unique to me, since not one webpage exists with the same code.
Other things i've gone through;
- SQL Server Configuration Manager shows everything Running, including Report Server
- SQL Management Studio shows all CRM & Reporting Services databases exist and are online.
- The Report Server error log shows this: "w3wp!library!1!29/03/2008-12:34:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerServiceUnavailableException: The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server."
- http://localhost/ works fine.
- http://localhost/Reports/ shows up a .Net error page with Security Exception error: "The application attempted to perform an operation not allowed by the security policy".
- http://localhost/ReportServer/ shows up a page with "localhost/ReportServer - / ---- Microsoft SQL Server Reporting Services Version 8.00.1038.00" which i assume is lacking correct content.
- When CRM was configured the setup wizard moaned that it could not use the existing Reporting Services database or IIS directories, so for that purpose there are two more virtual directories in IIS..
- https://localhost/ReportsSQL/ shows up an error: "Unable to connect to the remote server"
- https://localhost/ReportServerSQL/ shows up an error: "Reporting Services Error - The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable)"
- While trying everything i am logged in as server admin
- Software specs: Windows 2003 Small Business Server (SP2), SQL Server Standard 2005 (9.0.3054 / SP2), all patches from Microsoft Update (not just Windows Update) have been applied.
If you managed to read this far then thank you.. I'm nearly bald with frustration so if someone could please suggest things worth looking into or trying, that would be very much appreciated.
Cheers
how can I connect SSIS 2005 to Progress database?
View 4 Replies View RelatedGetting following error while trying to connect to ORACEL database using OLEDB manager.
Error at RADAR [Connection manager "RADAR_Updated"]: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered. Error code: 0x00000000.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".
[code]....
We have an Enterprise setup with multiple domains.
We a Domain A with SQL server 2008R2 say SQL-A and Domain B with SQL server 2008R2 ( SQL-B). It will be like SQL-A will always access SQL-B. Reverse is not required.
In Domain A we have a .Net Application which accesses SQL-A to perform CRUD operations which ultimately come to SQL- B since all SQL tables exist in SQL- B only.
Need to know the right way to implement Linked Server from SQL-A to SQL-B, so that Domain issues as well as DML execution work smooth.
I need not worry about DDL in SQL-A And SQL-B as it will taken care of by network and H/W team. I just need to focus on as developer.
Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.
View 4 Replies View RelatedHi, I'm new to the forum and also to SQL Server.
Has anybody implemented SharePoint Windows Services on top of SQL Express? I'm trying just that, but i'm encountering some problems when trying to enable Full-Text search. The configuration page for this option says that the database i'm running on does not support full-text search.
Thanks in advance,
Ulises
I have installed SharePoint Services 3.0 and have problems with backup.
Backup from SharePoint Central Administration never starts.
Application log:
Source: Windows SharePoint Ser
Event ID: 6398
The Execute method of job definition Microsoft.SharePoint.Administration.SPUpdateWorkerProcessGroup (ID d21cabd8-068c-487d-bc3c-4627fa542e26) threw an exception. More information is included below.
1387
and
The Execute method of job definition Microsoft.SharePoint.Administration.SPUpdateWorkerProcessGroup (ID e4b33475-e88b-49dc-ae4d-0447fa390518) threw an exception. More information is included below.
1387
Have tried with stsadm.exe but is stops (below are last three lines from CMD)
Progress: [Windows SharePoint Services Search] 50 percent complete.
Verbose: Starting object: Search instance.
Progress: [Search instance] 50 percent complete.
and in the application log:
Source: Windows SharePoint Ser
Event ID: 2442
The index was paused.
Context: Application 'Search', Catalog 'index file on the search server Search'
Regards, Iztok
Hello all, I hope someone can help me with this.
This is a new SQL Server 2005 cluster that we just installed for the first time, with SP2. I am trying to use a stored procedure with xp_cmdshell to run a script to backup the databases. I get the following error: locked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.
So I started Surface Area Configuration on the local SQL Server itself, and clicked on "Surface Area Configuration for Features". I then got the following error:
"Failed to connect to localhost. (Mirosoft.SqlServer.ConnectionInfo)
Additional information: 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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I am logged onto the server as a user with Admin privs; I installed SQL Server using that id. I am logged in via remote connection, so I know it allows remote connections... and I am logged into the server itself when I try to run the tool, so I don't understand why it's saying that it's trying to connect remotely.
Has anyone else ever experienced this problem? Thanks for any help you can give.
Best, Amy
I try to import my SSIS packages which are created using the Business Intelligent studio into SQL server 2005 but I cannot do that.
I am running SQL server 2005 enterprise edition.
Also when i tried to connect to Integration services using Object explorer, it only prompt me for server name. I cannot change the username and password which is disabled.
Then how am i supposed to connect to Integration services on a server in this case?
The description is as follows... The necessary network binding may already bein use. The site has been deactivated. The data field contains the errornumber. If anyone can help I would greatly appreciate it. Thanks!Mendy
View 1 Replies View RelatedI have installed SP2 on my report server and configured for Sharepoint access.
This is all ok.
I am able to use the webpart to create a report view but it wants the report. Is there a way to manage the report server (they way I did with reportmanager) in sharepoint. If so I have not found out how.
any ideas or links to show how I can have teh reports listed in Sharepoint?
Thanks
Hello. After I have installed Sharepoint Services 3 on the same machine as SSRS2005, I have configured both SSRS2005 and Sharepoint 3. Still I do not know if I have done this correct but a SSRS webpart is available within Sharepoint.
First question. When I deploy a report project should I still deploy to http://localhost/reportserver? This is not working but I would like to confirm that this is the correct way to do it.
Last question. Anyone who can point me to a site with good information regarding this setup? SSRS2005 SP2 and Sharepoint 3?
Kind regards
Thomas Ivarsson
Hi
I've recently upgraded from MSDE (SBS 2003 SP1 with .NET 2.0) to SQL Express SP1.
I am trying to enable full text sarching on the Sharepoint instance but whenever I go to Sharepoint central administaton and text sarching it reports that the SQL server installed does not suport this.
I can't find any documentation on this anywhere.
Admidatley the machine is a domain controller and I know this isn't recommended but surely this shouldn't stop this from working?
All components where selected when installing SQLExpress and I recieved no errors.
Any sugestions would be greatly appreciated.
Many kind thanks
Gareth
Gareth.Hunter@gmail.com
Hi my current setup is:
Server 1 - Office sharepoint server 2007
Server 2 - SQL Server 2005 with Service Pack 2 and reporting services
When I try to install the Reporting Services Add-in for Sharepoint on Server 1, I get an error - "Setup was interrupted"
Would you know how to fix it?
Thank you
If I upgrade my sharepoint Database from MSDE that comes with sharepoint, to SQL 2005 Express, will I lose my no limit on the Database size?
Normally MSDE has limit of 2GB but I guess it doesn't when installed with Sharepoint services. So if I upgrade to 2005 express, will I then get a 4 GB limit on size?
Thanks for your help