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?
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?
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
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
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="BowtieIntranetWebPar t.HR.TimeS heetEdit, 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">TimeSheetEdi t</propert y>
<property name="Description" type="string"></property>< /propertie s>
</data>
</webPart>
</webParts>
<?xml version="1.0" encoding="utf-8"?>
<webParts>
<webPart xmlns="http://schemas.microsoft.com/WebPart/v3">
<metaData>
<type name="BowtieIntranetWebPar
<importErrorMessage>Cannot
</metaData>
<data>
<properties>
<property name="Title" type="string">TimeSheetEdi
<property name="Description" type="string"></property><
</data>
</webPart>
</webParts>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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