Hi All,

I installed Sql Server 2000 Enterprise Edition in my computer. My computer is running on Windows XP Service Pack 2. While I was installing it I got the message that server component is not supported in my operating system, so only client components will be installed.

Now I'm trying to register by "New SQL server registration" option and I am trying to connect to my local machine by giving "(local)" as available server. But I just can't seem to do it. Like to mention here that my firewall is off.

Can anybody please advice me what I should do to solve this problem?

Thanks.

When you did the installation it did not install the Server. You need to use Enterprise Eval edition, Developer Edition, or Personal Edition (license is free for every CAL for SQL Server Std or Enterprise). I recommend Developer Edition.

Turn your firewall back on. When communicating with the local SQL Server you don't have to worry about firewalls.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Hello David,

Thanks for your reply. So after I install the developer addition, what would be the name of the local SQL Server? Please let me know if you know it.

I thought my problem is related to firewall as I read somewhere that with Windows XP SP-2, there would be problem in registering. So I went to my "Local Area Connection" and added "sql server on Named Pipes" service with it. But the the problem is still there. I'm trying to get Developer Edition as you mentioned and lets see how it goes from there.

Thanks.

The same name as your computer has.

You can always connect to the local default instance by using . for the server name
If it is a named instance on the local box, then you can do this
.\NamedInstance2
.\BESQL
.\Whatever

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com