Ok this sounds really stupid. I set up SQL Express 2008, on other setups it asked me for an instance name or showed the default. This time, the only prompt was for password for the sa login.
I don't think I have any server instance as when I choose the dropdown arrow on server, browse feature nothing is shown in the local area, but I don't know how to and a local server instance.
Still I attempted to try some default server names.
3) mycomputername\local (Wendalaptop\local)
no go.. So can anyone tell me how I can create a new Server name..