At a loss here.  I have sucessfully written several apps in Net 2.0 and never had a problem like this.  Maybe someone can assist here as I am beginning to wonder whether this application will ever work.  Current Version I am using is 4.3.5 and trying to connect to SQL 2000 server.  I have installed the source code version and no matter what I try I still get the error below.  I have even cut the commented areas out.  Please HELP>.

<connectionStrings>

<!-- Connection String for SQL Server 2000/2005 -->

<add name="SiteSqlServer" connectionString="Server=(local);Database=ProcessDNN;uid=Process;pwd=butterscotch;" providerName="System.Data.SqlClient" />

</connectionStrings>

<appSettings>

<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules -->

<add key="SiteSqlServer" value="Server=(local);Database=ProcessDNN;uid=Process;pwd=butterscotch;"/>

Just basic things to check:

The MS SQL Server 2000 is a default instance on the same computer so thet (local) is appropriate?

The database ProcessDNN is created?

The user has login privileges?

The user has dbo privs on the database in question?

No offense intended by the basic nature of these questions. Your strings look ok to me ...

No offense at all taken got to look at the basics but I cant get this working at all.  Dont know what else it can be as I have checked everything you put and a little bit more.  Any other ideas?

Thanks