Hi,

To specify connection string with user id and password we need to have the following things in the application defination file (.xml)

<?xml version=“1.0“?>

<LobSystem xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance“ xmlns:schemaLocation=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog BDCMetadata.XSD“ Type=“Database“ Version=“1.0.0.0“ Name=“NorthwindLOBSystem“ xmlns=“http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog“>

<Properties>

<Property Name=“WildcardCharacter“ Type=“System.String“>%</Property>

</Properties>

<LobSystemInstances>

<LobSystemInstance Name=“NorthwindInstance“>

<Properties>

<Property Name=“DatabaseAccessProvider“ Type=“System.String“>SqlServer</Property>

<Property Name=“AuthenticationMode“ Type=“System.String“>PassThrough</Property>

<Property Name=“RdbConnection Data Source“ Type=“System.String“>d-2926</Property>

<Property Name=“RdbConnection Integrated Security“ Type=“System.String“ />

<Property Name=“RdbConnection Initial Catalog“ Type=“System.String“>Northwind</Property>

<Property Name=“RdbConnection User ID“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Password“ Type=“System.String“>sa</Property>

<Property Name=“RdbConnection Pooling“ Type=“System.String“>false</Property>

</Properties>

</LobSystemInstance>

</LobSystemInstances>

<Entities>

We need not to specify any value for Integrated Security as we are using sql authentication

And can specify user id and password with RdbConnection User ID and Password Property.

Bye…

Hi,

• Back Up and Restore the content database to a new Sql server
• In Central Administration page
• Go to Application Management and Click on Create or extend web application.
• Therein Create a new web application. Once application is created don’t create Site Collection.
• Now again go back to Application Management.
• Therein click Content Databases
• Change the web application to point to web application you just created.
• Remove the default content database created while creating the web application.
• Then click on Add a content database
• Specify the Database Server where the content database was restored and in database name specify the name of the content database.
• The site should get restored properly.

Check out this good information

http://blah.winsmarts.com/2007-10-Backup_and_Restore_Strategies_in_MOSS_2007.aspx

Bye

Hi,

After running the Sharepoint products and technologies configuration wizard successfully, the central administration site page opens up.

( We were installing MOSS 2007 on 64 bit machine)

But in my case it was giving the following error

“Service Unavailable”

Checking into event log gave the following information

Could not load all ISAPI filters for site/service. Therefore startup aborted.

and

ISAPI Filter ‘C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll’ could not be loaded due to a configuration problem. The current configuration only supports loading images built for a AMD64 processor architecture. The data field contains the error number. To learn more about this issue, including how to troubleshooting this kind of processor architecture mismatch error, see http://go.microsoft.com/fwlink/?LinkId=29349.

Searching for it the solution that I found was the following

// Disabling the 32bit mode for your web site.

cscript C:\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 0

and then the following

// Registering ASP.NET 2.0 as the default framework for that web site

C:\Windows\Microsoft.NET\Framework64\v2.0.50727>
aspnet_regiis.exe -i

This resolved the issue for us!!

Bye…

Hi,

Got this issues while running the set up for MOSS 2007 on 64-bit edition of Windows server 2003.

The resolution i found for this was following

1) Open the command prompt

2) Navigate to the following directory

“….: \Inetpub\Adminscripts”

3) Type the following command

adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 0

4) And finally IISRESET.

Bye