SQL Server 2005 with SQL Server 2000 support

[Mr Gray]

Hello,

I have a service written in C# 1.1 and have a connection string to a database that was originally for SQL 2000. I am receiving an error:

Error #: SQL Server does not exist or access denied.

To me this error seems reasonably straightforward but I am unable to fix it by doing the things it seems are obvious, for example, ensuring the account that runs the service has sufficient access to the server and the DB on the server and making sure that the account has been added to the local administrator group on that machine.

Could anyone suggest what other things I could check, I suspect it is because I am using SQL 2005 to host this DB that was originally SQL 2000 and maybe I need to use a different connection string:

		<add key="ConnectionString" value="Data Source=SQLServer;Integrated Security=SSPI;Initial Catalog=DB;Application Name=App" />

[Mr Gray]

I have discovered the error myself and I feel liek an idiot:

in the connection string i had a '/' separating the "servername/sqlserver" it should have been "servername\sql server" the '/' is wrong. Should be '\'. Very noobish mistake but took me days to see it.

So if you experience this same thing just check which way yours are pointing.