Avatar of BBrian
BBrian asked on

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

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?
Windows Server 2008Microsoft SharePoint

Avatar of undefined
Last Comment
BBrian

8/22/2022 - Mon
Rainer Jeschor

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
ASKER
BBrian

It is custom built.
Rainer Jeschor

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
BBrian

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>
ASKER CERTIFIED SOLUTION
BBrian

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
BBrian

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.