Web Hosting Talk







View Full Version : OK, so what does this ASP.net 2.0 error mean? (Something about SQL Server)


Quintox
09-14-2007, 12:15 PM
Does this mean my hosting provider does not have SQL Server 2005?

http://hirethefired.com to view the error

Azavia
09-16-2007, 01:30 PM
What host parameter are you using, e.g., localhost? Are your user/pass correct? Let's see your connection string.

(Stephen)
09-16-2007, 03:10 PM
It looks like you are trying to connect to the sql server with a wrong IP, or trying to use SQL 2005 Express where it is not installed.
Your provider has SQL 2005, but maybe not SQL 2005 Express.

You can get some connection string samples from www.connectionstrings.com

dingloo
09-16-2007, 03:15 PM
Quintox,

By default SQL Server 2005 does not allow remote connections. So your parameters have to be configured accordingly.

The following KB article has more details on this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Please do let me know if you still have problems fixing it.

Regards,
Dingloo

(Stephen)
09-16-2007, 03:27 PM
That's not the cause, it is using a SQL 2005 Express connection string :)

Quintox,

By default SQL Server 2005 does not allow remote connections. So your parameters have to be configured accordingly.

The following KB article has more details on this:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Please do let me know if you still have problems fixing it.

Regards,
Dingloo