PowerPivot Report is unable to connect database after uploading onto SharePoint 2010

Hi, I have a requirement to connect to a webservice from SharePoint 2010 without passing Network credentials explicitly. If i am already logged into the SharePoint 2010 portal , I should be able to click on Search (which is a web service which retrieves search results from Oracle UCM) and retrieve the result. I tried localhost.ServiceX myProxy = new localhost.ServiceX(); myProxy.Credentials = System.Net.CredentialCache.DefaultCredentials; also myProxy.UseDefaultCredentials = True Still i am unable to authenticate. Default credentials returns null value.   Kindly help.

Hi Techies,  we are running 4farm Sharepoint internet site. now a days we are getting the below error very regularly. Event Viewer :The description for Event ID ( 27745 ) in Source ( Windows SharePoint Services 3 ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: #50071: Unable to connect to the database SharePoint_Config on SPPREPROD02VMDK\SPPREDPROD.  Check the database connection information and make sure that the database server is running.. Sharepoint Logs:#50071 :#50071: Unable to connect to the database SharePoint_Config on pfc-penndb-tst. Check the database connection information and make sure that the database server is running.. Please Advice . Regards, raju.  Nag: http://nagaraju-sharepoint.blogspot.com. Posting is provided with no warranties.

Hi all

I have setup 2 servers in hyper-v.
SERVER-SQL = SQL 2008 R2
and
SERVER-SHP = Sharepoint 2010
both running on windows server 2008 R2.
Both servers are joined to the same domain, have fixed ip addresses and can ping each other.

When I get to the part in Sharepoint 2010 setup where I'm runnng "Sharepoint Products Configuration Wizard" where I specify the database server and name and username and password I get the following error which I can't get past "Cannot connect to database master at SQL server at SERVER-SQL. The database might not exist, or the current user does not have permission to connect to it."

I have read the following link and followed it but the problem remains
http://andreasglaser.net/post/2009/11/18/Installing-SharePoint-Server-2010-on-Windows-Server-2008-R2-and-SQL-Server-2008-R2-Part-5-Administrative-and-service-accounts.aspx

I don't see where it is falling over as the username and password is the domain administrator one (have also tried the spAdmin) mentioned to setup in the above link. And it says at the notes at the top of the page that if the database (SharePoint_Co

Hi,

SharePoint farm is as below. 1 SQL, 1 WFE, 1 Application server. SQL 2005 and SharePoint 2007 with SP1.

SharePoint portal is working fine from 1 year, suddenly from today morning in the WFE eventvwr we are getting 27745, 3355 and 5586 event id errors. Site also giving error saying "unable to connect the content database". This is repeating for 10 to 15 min.

when ever these errors occur in eventvwr sharepoint will not work.

Please suggest on this issue.

waiting for MS replies..

 

Regards,

v235.

 

 

I am having a terrrible time getting this to work. I have configured the SharePoint site and the SQL Servers involved to use Kerberos. That has been confirmed working.

I then configured the SharePoint site's Reporting Services integration (trusted account), enabled anonymous access and enabled report builder. I can launch report builder without any issues at all. The problem comes when I try to save my report. When Report Builder is started Items->New-ReportBuilder Report it opens and display in the lower left hand corner "No current report server." When I close the Wizard dialog and click connect I enter http://server.fqdn.net and I receive the following error:

Connection failed:

Unable to connect to the server that is specified in the URL, 'http://servername.fqdn.net/'.

Make sure that the server is running, the URL is correct, and you have permission to use the server.

I have also tried http://servername.fqdn.net/reportsserver/. When I try that I receive a login prompt. When I enter my credentials it tries for a few seconds and then sends another login prompt. I installed the report server using default settings. The reporting services db is on the same server as sharepoint. The configuration and other databases are on a remote S

Hi,

I am having a problem backing up a site collection, when trying to backup the collection I get the following error "Unable to read full interval from database" and "operation is not valid due to the current state of the object".

The backup does run and manages to backup 182MB of the site collection and then the backup fails, it fails at the same point what ever backup method I use e.g. STSADM, Powershell or Central Admin.

I'm getting the same error whether I use CA "granular backup" or "Farm backup", and using either STSAMD or Powershell. I can backup CA or the mysite collection but not the Home Portal site collection. I even tried installing the commuvaults 2010 agents and running a commuvault backup but this is also failing. i have included the log file entry below.

Does anyone have any suggestions on what i can do to either fix the problem or an alternative way to backup the collection or farm, I am currently taking a full SQL backup but am not sure how reliable this is as I haven't tried to restore the sites. 

P.S. I am not using the "UseSQLSnapshot" parameter.

11/30/2010 09:34:25.23  OWSTIMER.EXE (0x17E8)                 

SO here is the problem I have a whole project SSRS 2005 project that is unable to connect to the SQL 2005 Standard database. When I try to access the data under the "Data" tab I get the following Error.  Interestingly when I go in the data source connection settings and click the "Test Connection" all is good. But still the report is not able to pull any data without the error comming up. I have removed and reinstalled VS 2005 Pro, removed and reinstalled SQL tools on the workstation all with the same error. I have the same project on an older laptop and all is well. Help!!!!

ERROR MESSAGE ->

 

TITLE: Microsoft Report Designer
------------------------------

A connection cannot be made to the database.
Set and test the connection string.


------------------------------
ADDITIONAL INFORMATION:

Format of the initialization string does not conform to specification starting at index 75. (System.Data)

More on the Error:

 

===================================

A connection cannot be made to the database.
Set and test the connection string.
 (Microsoft Report Designer)

------------------------------
Program Location:

   at Microsoft.ReportDesigner.Design.Query.CreateConnection()
 

You have installed Office 2010 beta and you are trying to connect to SharePoint 2010 from InfoPath but you get an error

Hi,

I am using visual studio 2005 and sql server 2005.

I am developing a small quiz application and i have stored the connection string in app.config file which is given below.:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
       
        <add name="quizdb"
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Quiz Application.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

i have retrieved connection string property through configurationmanager class 

and when i m connecting to database  it gives me a runtime error:

 

Sql Exception was unhandled

System.Data.SqlClient.SqlException was unhandled
  Message="An attempt to attach an auto-named database for file F:\\Quiz\\Quiz\\bin\\Debug\\Quiz Application.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located