Solved

SQL Server 2000 connection problem

Posted on 2013-01-23
3
384 Views
Last Modified: 2013-01-23
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"?
0
Comment
Question by:scprogs
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
you could try to use 127.0.0.1 instead of localhost....
0
 
LVL 12

Accepted Solution

by:
Seaton007 earned 500 total points
Comment Utility
0
 

Author Closing Comment

by:scprogs
Comment Utility
Thanks, Seaton. Those links were helpful. I had seen mention before of a network utility for SQL Server 2000, but I had a hard time finding it. It's called SVRNETCN.exe and can be found in C:\Program Files\Microsoft SQL Server\80\Tools\Binn. There, I enabled Named Pipes and TCP/IP and that took care of it.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now