<div>
Hi,<br />
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.<br />
Is this a custom built / developed web part or an Out-Of-The-Box SharePoint web part?<br />
<br />
KR<br />
Rainer
</div>


<div>
Hi,<br />
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.<br />
<br />
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.<br />
<br />
HTH<br />
Rainer
</div>


<div>
The web part file only seems to contain xml:<br />
<br />
&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;<br />
&lt;webParts&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;webPart xmlns=&quot;<a href="http://schemas.microsoft.com/WebPart/v3" rel="ugc nofollow">http://schemas.microsoft.com/WebPart/v3</a>&quot;&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;metaData&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;type name=&quot;BowtieIntranetWebPar<wbr />t.HR.TimeS<wbr />heetEdit, BowtieIntranetWebPart, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null&quot; /&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;importErrorMessage&gt;Cannot<wbr /> import this Web Part.&lt;/importErrorMessage&gt;<wbr /><br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/metaData&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;data&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;properties&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name=&quot;Title&quot; type=&quot;string&quot;&gt;TimeSheetEdi<wbr />t&lt;/propert<wbr />y&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;property name=&quot;Description&quot; type=&quot;string&quot;&gt;&lt;/property&gt;&lt;<wbr />/propertie<wbr />s&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/data&gt;<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/webPart&gt;<br />
&lt;/webParts&gt;
</div>


<div>
When our database server crashed, we lost the login that SharePoint uses to access the database. &nbsp;I just re-added the user name and password to SQL server and it worked fine.
</div>


<div>
<div class="content wysiwyg-content">
My company uses SharePoint 3.0. &nbsp; <br />
One of our database servers crashed and we have to rebuild it.<br />
And now one of our SharePoint application pages gives us a login in error.<br />
<br />
I can find the web part for the page that doesn't work but cannot find the data source for that page.<br />
I'm guessing I need to create a login on the Database Server but I am not sure.<br />
Can anyone help?
</div>
</div>


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?

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

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.