Trying to Register SQL Server (Error)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Trying to Register SQL Server (Error)

Author

Topic

BuildHome
Starting Member

20 Posts

Posted - 2005-01-13 : 18:07:33

Hello,

I have a problem to register my local server to SQL SERVER 2000.

I tried to reinstall it but it didn't help.
I try to follow the guides:
http://www.15seconds.com/Issue/001025.htm
http://www.edgewebhosting.net/sql2000/
http://www.teamits.com/internet/support/index.php?/internet/support/nt/sql_server_8.html
http://support.rapidsystem.net/ntfaq/client.htm

And I tried to solved it with this solution:
http://support.microsoft.com/kb/290820/EN-US/
But it didn't help.

I have SQL SERVER 2000 and Windows XP PRO EN SP1.

I tried to enter "127.0.0.1","local","localhost","(local)","." to the server name in Client Network Utility->Alias (TCP/IP).
I attached 2 pictures.

What I did wrong or what's the problem?

Please help me

Thanks,
BuildHome

Pictures:
http://dvirs.net/Pics/sqlServer2000_err001.jpg
http://dvirs.net/Pics/sqlServer2000_err002.jpg

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-13 : 18:09:05

Your MSSQLSERVER service probably isn't started. Check out the status of the service in the Services applet which can be found in Admin Tools in Control Panel.

Tara

BuildHome
Starting Member

20 Posts

Posted - 2005-01-13 : 18:12:36

Thank you for your reply.

What the name that I need to search for? I didn't found the name "MSSQLSERVER" in the list.

Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-13 : 18:14:47

Do any services start with MSSQL? If so, then start them. If not, then SQL Server was not successfully installed.

Tara

BuildHome
Starting Member

20 Posts

Posted - 2005-01-13 : 18:17:27

No, I don't have any In the list :(

I don't have a good version of MS-SQL or maybe the setup isn't good?
What version do you recommend me to Install? 2000? 2003?
Something that will be good to my OS.

Thank you :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-13 : 18:19:22

Well you have to tell us what OS you are using. Some versions of SQL Server can only be installed on certain operating systems.

Tara

BuildHome
Starting Member

20 Posts

Posted - 2005-01-13 : 18:22:05

quote:
Originally posted by BuildHome
I have SQL SERVER 2000 and Windows XP PRO EN SP1.

Thank you.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-01-13 : 18:23:46

Sorry, missed that in your original post.

You can install SQL Server 2000 Developer Edition. It's about 50 bucks from MS.

Tara

BuildHome
Starting Member

20 Posts

Posted - 2005-01-13 : 18:28:08

OK. Thank you !
I'll downloan It and I'll try it again.

I'm lucky that It's now 18:30 PM and not 01:28 AM (In Israel)

Thank you.

BuildHome
Starting Member

20 Posts

Posted - 2005-01-14 : 14:04:21

Hi again,

I installed SQL SERVER 2000 but I can't config username & password to the registered sql server properties window (I attached a screenshot).

I only can use the first option (Use Windows authenitication).

Why Is that? Why can't I user the second option?

Thanks,
BuildHome

ScreenShot:
http://dvirs.net/Pics/sqlServer2000_err003.jpg

BuildHome
Starting Member

20 Posts

Posted - 2005-01-14 : 14:24:25

I solved the problem

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources