I've been tasked with installing an old program on a client's computer that connects to a SQL Server 2000 database. The connection string is hard-coded in the program as follows:
Provider=SQLOLEDB.1;User ID=sa;Password=vbs;Initial Catalog=Boxlabeler;Data Source=localhost
I've tried this connection string in a udl file, but when I try to test the connection, I get the error,
Test connection failed because of an error in initializing provider. [DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied.
When the server name in the udl file is changed from "localhost" to the name of the PC, it is able to connect. I would rather make this work without changing the connection string or upgrading the SQL instance, as I'm not sure how the end-user is connecting to it remotely. What do I have to do to make it work with the server name as "localhost"?