By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,385 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

SQL Server 2005 with SQL Server 2000 support

P: 47
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:

Expand|Select|Wrap|Line Numbers
  1. Error #: SQL Server does not exist or access denied.
  2.  
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:

Expand|Select|Wrap|Line Numbers
  1.         <add key="ConnectionString" value="Data Source=SQLServer;Integrated Security=SSPI;Initial Catalog=DB;Application Name=App" />
  2.  
  3.  
Apr 21 '08 #1
Share this Question
Share on Google+
1 Reply


P: 47
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\sqlserver" 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.
Apr 21 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.