can not connect to sql server 1

[tek1ket]

i have programmed an application. it can connect to sql server when i am testing it on my own computer, but when i install it on other computers. and want to connect to sql server it says:

"An error has occureed while establishing a connection to the server. when connecting too SQL server 2005. This Failure may be caused by the fact under the default Setting server does not allow remote connections."

*)but my sql server is 2000, and other application can connect to it remotely. so it could not be the configuration of sql server. which i checked it and it let the remote connection

*) Firewall is Off

what could be the problem?
does visual studio 2008 has any problem with sql server 2000?

 

[jmeckley]

try clearing the connection strings in the config

<connectionStrings>
   <clear />
   <add name="..." connectionString="..." prodiverName="..." />
</connectionStrings>

It may fix the problem, or it could throw another exception because the component requiring the sql 2005 database is missing. you could then try removing the AspNetSqlRoleProvider, assuming this is a web app.

<system.web>
   <roleManager>
      <providers defaultProvider="the one you use">
         <remove name="AspNetSqlRoleProvider" />
      </providers>
   </roleManager>
</system.web>

If this doesn't fix the problem you will need to provide more information.

Jason Meckley
Programmer

faq855-7190
faq732-7259