We help IT Professionals succeed at work.

Sharepoint 3.0 How can I find the datasource to one of the webparts

33 Views
Last Modified: 2016-01-22
My company uses SharePoint 3.0.  
One of our database servers crashed and we have to rebuild it.
And now one of our SharePoint application pages gives us a login in error.

I can find the web part for the page that doesn't work but cannot find the data source for that page.
I'm guessing I need to create a login on the Database Server but I am not sure.
Can anyone help?
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
this depends on how this web part is built. There are a couple of different ways, how the web part connects to a datasource - it could be a connection string inside the web.config of the SharePoint application, a link to a datasource file, an entry in a configuration list or even hard coded inside the web part.
Is this a custom built / developed web part or an Out-Of-The-Box SharePoint web part?

KR
Rainer

Author

Commented:
It is custom built.
CERTIFIED EXPERT
Most Valuable Expert 2013
Awarded 2012

Commented:
Hi,
OK, then the only chance for us experts (without access to the server itself) would be to decompile the web part (which should have been deployed using a SharePoint solution file (wsp)) to get an idea, where this data connection string is stored.

You might be able to have a look inside the web.config of your SharePoint application, if there are any entries inside the connectionstring node or a custom entry in appSettings which looks like a data connection string.

HTH
Rainer

Author

Commented:
The web part file only seems to contain xml:

<?xml version="1.0" encoding="utf-8"?>
<webParts>
      <webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
            <metaData>
                  <type name="BowtieIntranetWebPart.HR.TimeSheetEdit, BowtieIntranetWebPart, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" />
                  <importErrorMessage>Cannot import this Web Part.</importErrorMessage>
            </metaData>
            <data>
                  <properties>
                        <property name="Title" type="string">TimeSheetEdit</property>
                  <property name="Description" type="string"></property></properties>
            </data>
      </webPart>
</webParts>
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
When our database server crashed, we lost the login that SharePoint uses to access the database.  I just re-added the user name and password to SQL server and it worked fine.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.