The moose likes JDBC and the fly likes Problem in RDBMS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in RDBMS" Watch "Problem in RDBMS" New topic
Author

Problem in RDBMS

Niyas Ahmed Sheikh
Ranch Hand

Joined: Jun 15, 2005
Posts: 129
Hi,

I am using Windows 2000. I am learning JSP/Servlet with JDBC. For which I am in need of one RDBMS. I installed Oracle 8i, but due to some error, it's not installing. Then I had tried Microsoft SQL Server. It's successfully installed, but while I started the Query Analyzer, It's asking for SQL Server. But I didn't find any server. How to connect to SQL server. PLease help to resolve my problem.

Thanks in advance
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Hmm. Assuming you are running your SQL server instance, you should be able create a connection (using windows authentication) to "localhost" or your machine name.

I do however strongly recommend reading the SQL Server documentation before going any further.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Niyas Ahmed Sheikh
Ranch Hand

Joined: Jun 15, 2005
Posts: 129
While I had tried to install the Microsoft SQL Server, I got the following error/warning messgae


However, It installaed successfully:

When I had tried to use my local host with windows authentication or local host with username:sa with password:sa, I am getting the following error message.

Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


However, It installaed successfully:

Doesn't look like it did. It looks like the client has installed not the server. The system requirements for SQL server:

Supported Operating Systems: Windows 2000 Advanced Server; Windows 2000 Professional Edition ; Windows 2000 Server; Windows Server 2003, Datacenter x64 Edition; Windows Server 2003, Enterprise x64 Edition; Windows Server 2003, Standard x64 Edition; Windows Small Business Server 2003 ; Windows XP Home Edition ; Windows XP Media Center Edition; Windows XP Professional Edition

Are you sure you have a valid version of Windows 2000?
Niyas Ahmed Sheikh
Ranch Hand

Joined: Jun 15, 2005
Posts: 129
I am using Microsoft Windows 2000 Professional (5.00.2195) Service Pack 4 in my laptop.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

In which case I suggest you contact Microsoft support.
Niyas Ahmed Sheikh
Ranch Hand

Joined: Jun 15, 2005
Posts: 129
Hi,

As paul suggested, if windows 2000 professional can suuport Microsoft SQL Server, I think I missed some where. I am installed Microsoft SQL Server successfully. It asking for the SQL Server for connection. I tried with local host (127.0.0.1 or localhost), but failed. Then I thought if it's possible to use the ip of my machine. I tried to find out the ip in my machine. But I am not getting.

C:\Documents and Settings\Administrator>ipconfig /all

Windows 2000 IP Configuration

Host Name . . . . . . . . . . . . : asdcdasas0023
Primary DNS Suffix . . . . . . . : bank.fcm.com
Node Type . . . . . . . . . . . . : Hybrid
IP Routing Enabled. . . . . . . . : No
WINS Proxy Enabled. . . . . . . . : No

Ethernet adapter Local Area Connection:

Media State . . . . . . . . . . . : Cable Disconnected
Description . . . . . . . . . . . : Realtek RTL8139(A)-based PCI

Fast Ethernet Adapter
Physical Address. . . . . . . . . : 00-10-0E-53-75-61

Which one to use or how to get the ip or how to enable, it is disabled?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Problem in RDBMS