I don't know why my application on the internet try to access the SQL Server 2005, when the host still having the 2000 edition. I put the following connection string:
Data Source=##DBSERVER##;Initial Catalog=##DBNAME##;User ID=##DBUSER##;Password=##DBPASSWORD##;
Isn't everything fine with that? I created the table by host but dosen't work. I'm wondering if can I conect straight with Data Base, without register in the server, like with mdb?
This is the error that I'm getting.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Hi,
I'd like to know if the ##DBSERVER## you refer to is a correct database name with the desired SQL Server 2000. If you have multiple instance of SQL Server installed on that server, in order to access the correct one, you need to specify the instance name, if that's not the default instance, like "Data Source=DBServer\InstanceName".
For this specific error message, you can also check the following KB article for troubleshooting.
http://support.microsoft.com/kb/914277/en-us
No comments:
Post a Comment