PLS GURUS IN THE HOUSE, I NEED STEPS BY STEPS PROCEDURE ON HOW TO REGISTER SERVER IN SQL SERVER 2005/2008. AND HOW CAN I CONNECT IF MY COMPUTER IS NOT CONNECTED TO THE INTERNET.

No need to open multiple threads on the same issue, Dude. What exactly are you trying to do. Can you post a screen shot of any error messages you are getting cause your questions do not seem to be to point for us to effectively help you better.

Registration of Express version of SQL Server is not really required. You can skip it for later if you do not have internet access, or you follow the options , if any, to register via fax or by mail.

@ Kobojunkie

this is what i'm talking about, check the attachment, the first diagram is connection dialogue box , while the second one is the connection error

When you say register Server do you mean creating a new Server instance or registering on-line? And by "How do I Connect" do you mean Logging in or Connecting to the internet.

From your attachment, you were trying to connect to SQL Server Compact Edition. Confirm that the parameters in the combo boxes are correct. Usually, you should be able to connect to SQL Server (without the internet) using your Windows account or a Log-in already created with SQL Server either during installation or Using the Management Console.

As for SQL Server Compact Edition, well, can't say!

Double check the parameters again and try to connect. If you registered a Log-in Account during installation, use it. Else, log-in to Windows with an Administrative user and try again.

, then post an update here!

@ Everything and kobojunkie

What i mean is that i know aw to write SQL language, but to connect to SQL Server and create my Database is my problem.
Pls Everybody in the house Assist me on this

Av re-attached the SQL server login page and the error message

Do you have, currently, on your C drive a file named MyDatabase#1.sdf? Please confirm this.

Also, are you sure you want to work with SQL CE? Or are you just trying to create or connect to a database somewhere?