?
Solved

SQL 2000 Client install

Posted on 2004-09-19
7
Medium Priority
?
250 Views
Last Modified: 2009-07-29
Hi,
There!
OS                         -    XP Prof
SQL 2000 Server    - install as client, bcouse i dont have server OS.
I try to connect from sql 2000 client to server side, i cant able to come up. I try from ODBC, DNS, new sql server registration. There is available server name SMK+add+ Window auntication.. I got a answer SQL Server doesnt exit or access denied. Install on client side and try to connect server, please help me.

Oracle 8.0 Client:
I got error on Oracle also ORA-12224 No listener.
Oracle net8 assistance there is one listener, which i did but even though i got error.

OS:                    XP PRO
SQL Server 2000 install client side
Oracle 8.0 Client.

Can u plz, help both sql 2000 and Oracle.

Thank you very much
Have a good day.

 
0
Comment
Question by:superkhan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
7 Comments
 
LVL 10

Expert Comment

by:AaronAbend
ID: 12098540
SQL Server:

What authentication are you using? SQL Server or Windows? If windows, make sure you can view the server in question in your Network Neighborhood and you have privileges on the machine. If SQL Server Auth, check username and password.

Oracle - Is the listener on the SERVER working? Can you connect from other workstations? If so, the listener is running. You can get on the server and at the dos prompt go into lsrnctl and type Status to see if the listener is up. If you can do that you can see the name of the database instance - it will say something like "orcl has 1 service handler" - that means you should put in "orcl" as the instance name in the Network Configuration Assistant.  
0
 
LVL 15

Expert Comment

by:mcmonap
ID: 12099813
Hi superkhan,

If the server is the latest version of MSDE the networking protocols are disabled by default and the server does not listed on any tcp ports, you either need to install with a specific switch or add them in afterwards using the Server Network Utility, check this out:
http://support.microsoft.com/default.aspx?kbid=814130
0
 
LVL 15

Expert Comment

by:mcmonap
ID: 12099815
Also can you ping the servers?  You haven't mentioned wether you have any network connectivity at all...
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 100 total points
ID: 12108765
Please followup on these abandoned questions:
1 12/05/2003 50 Oracle 8 Client.  Error ORA-12203:TNS:un...  Open Oracle
2 01/28/2004 45 How can one ip address allow to access m...  Open Security
0
 
LVL 15

Expert Comment

by:mcmonap
ID: 12367127
Hi TheLearnedOne,

Maybe delete the Q and don't refund the points?  It's impossible to say whether our options had any validity due to the lack of feedback.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 12490038
>>Maybe delete the Q and don't refund the points?<<
I agree.
0

Featured Post

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

752 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