Hi Thomas


i m in deep trouble plz help me.

I have developed a website in ASP.NET 2.0 with SQL-SERVER 2005. i have used Membership feature of ASP.NET 2.0 (VS-2005). Which creates a Membership Database named aspnetdb in my app_data folder in my website folder. But now while hosting on the i found that on which server i m hosting my site is working on SQL-SERVER 2000. That Creates a big Problem because it is not reading my data base which is created in SQL-SERVER 2005.

What i have done :

1) i have Converted the whole database in to SQL-SERVER2000 format (by Script generation and transering Data).
2) i have Converted the Membership (aspnetdb) database in to SQL-SERVER2000 format (by Script generation and transering Data).

3) Now i have conbined the Membership (aspnetdb) database with My main application Database.

I am unable to create a perfact connection string.


Please Help me to create a conntection string which is suitable for both cases.


I tried...........

(web.config)

<connectionStrings>
<add name="LottereesConnectionString" connectionString="Data Source=admnws\SERVER2000;Initial Catalog=Database;User ID=sa;Password=ravi2007"
providerName="System.Data.SqlClient" />
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=admnws\server2000;Initial Catalog=Database;User ID=sa;Password=ravi2007;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings>
<appSettings>
<add key="MasterString" value ="Data Source=admnws\SERVER2000;Initial Catalog=Database;User ID=sa;Password=ravi2007"/>
</appSettings>

<roleManager enabled="true" defaultProvider="SqlRoleProvider">


with this i get error "unable to login in HOST\ASPNET"