Link to home
Start Free TrialLog in
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?
Avatar of Rainer Jeschor
Rainer Jeschor
Flag of Germany image

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
Avatar of BBrian
BBrian

ASKER

It is custom built.
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
Avatar of BBrian

ASKER

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
Avatar of BBrian
BBrian

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BBrian

ASKER

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.