• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Problem in RDBMS

 
Ranch Hand
Posts: 129
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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.
 
Niyas Ahmed Sheikh
Ranch Hand
Posts: 129
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


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
Posts: 129
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I am using Microsoft Windows 2000 Professional (5.00.2195) Service Pack 4 in my laptop.
 
Paul Sturrock
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In which case I suggest you contact Microsoft support.
 
Niyas Ahmed Sheikh
Ranch Hand
Posts: 129
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Something about .... going for a swim. With this tiny ad ...
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic