Solved

SQL Server 2000 connection problem

Posted on 2013-01-23
3
399 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 143

Expert Comment

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

Accepted Solution

by:
Seaton007 earned 500 total points
ID: 38811125
0
 

Author Closing Comment

by:scprogs
ID: 38811433
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SSAS Store Forecasting data in the cube 1 20
RAISERROR WITH NOWAIT 2 18
RESTORE MASTER DATABASE -- NOW 2 20
SQL Availablity Groups List 2 8
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

820 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