sql server registration problem (HELP!!!!) 2

[pitt1]

Hi all !

I’ve just installed sql server 2000, and wanted to work on my pc, as a database server,
In the enterprise manager, I choose the option :

- new sql server registration (under Microsoft sql srvers)

then in the register sql server wizard, I choose my machine’s name as a server,

in the end of the wizard session I’ve got the message :

<machine’s name..> -SQL server does not exist or access denied. Connectionopen (Connect)

I used windows authentication as login.

I really don’t know what to do and why sql server 2000 don’t know how to recognize my computer as a server


if anyone can help...
Regards,

Hanan

 

[gmmastros]

The first thing you should check is the SQL Server Service. Here's how...

click start->run
type services.msc

Scroll down to MSSQLSERVER

Ideally, the status would be started and the 'startup type' should be automatic.

If you have problems starting the service, you can right-click on the service, go to properties, and then the log-on tab. Try setting the 'log on as' to 'local system account'.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLBill]

1. did it install properly?
2. when you installed it, did you set it up for Windows Authentication only?
3. what operating system are you using and what version/edition of SQL Server?

-SQLBill

Posting advice: FAQ481-4875

 

[pitt1]

thanx for the quick rspond,

1. i'm using windows XP os.
2. installed microsoft sql server 2000 + sp3

i tried to run "services.msc" but i can't find the MSSQLSERVER, only found MSSQLServerADHelper and MSSQLServerOLAPService,

maybe it has to do with the fact that during installation I could only pick "clinet tools only" and "connectivity only" and had "server and clinet tools" option disabled...

Regards,
Hanan

 

[gmmastros]

The database engine is not installed, which is why you can't register it. You also won't be able to create a database or attach a database.

The first thing you need to do is get the database engine installed.



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[SQLBill]

Which version of XP do you have installed? And which edition of SQL Server 2000 did you try to install?

This Microsoft website lists what editions are compatible with which Windows versions.

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

Notice: You can only install the Evaluation, Developer, or Workgroup edition on XP. (Developer cannot be used in a production environment).

-SQLBill

Posting advice: FAQ481-4875

 

[pitt1]

Hi,

I use microsoft windows XP professional, version 2002,
service pack 2.

i tried to install microsoft sql server 2000 enterprise edition.

Tahnks,
Hanan

 

[gmmastros]

Then you've found your problem. The link that SQLBill shows that SQL 2000 Enterprise can only be installed on the following operating systems.

• Windows Server 2003, Standard Edition1
• Windows Server 2003, Enterprise Edition2
• Windows Server 2003, Datacenter Edition3
• Windows® 2000 Server
• Windows 2000 Advanced Server
• Windows 2000 Datacenter Server

You can only install SQL Server Evaluation Edition, Developer Edition, Workgroup Edition, or Personal Edition (MSDE) on Windows XP Professional.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[pitt1]

oh boy....thanx a lot,
but the thing is i managed to install some of the sql server enterprise ed., since i have the option to choose the enterprise manager, and have the option to make a server registration in it,
that means that it will be possible to register a remote server ??? (not my machine as a server)

Regards,
Hanan

 

[SQLBill]

You can install the client tools (Enterprise Manager, Query Analyzer, Books OnLine, Profiler, and others) on any system.

And yes, you can use the client tools to access any remote SQL Server instance that you have access to.

-SQLBill



Posting advice: FAQ481-4875