Installed SQL Server 2008, how to create an instance

[AndrewBuchan]

Hello.

I just installed SQL Server 2008 (version: 10.0.1600.22)

Now when I open Management Studio I am asked to Connect To Server. Now, no server is listed, presumably because I have not created one yet.

So how do I do this? Should the install have done this? If so what is the default instance name?

Thanks,
Andrew

[Rabbit]

Did you try localhost?

[AndrewBuchan]

Yes I tried localhost.

Is there anywhere that lists these? Right now I have the Management Studio but no apparent way to create a server, thus no way of creating a database...

[FTanori]

Hi,

If only run one instance try with (local) or . <---(only dot)

If your version is Express Edition, Default Instance Name Is EXPRESS ( this is (local)\EXPRESS or .\EXPRESS ) Or try MSSQLSERVER for others editions

You can see Instance Name on services console (Services.msc), the services name is SQL SERVER and in parentheses you can see the instance name example:

SQL SERVER (Production)

Or in this key on regedit:

HKEY_LOCAL_MACH INE\SOFTWARE\Mi crosoft\Microso ft SQL Server\Instance Names


i'm learning english... patience.. :D

[AndrewBuchan]

Hi.

Thanks for your reply.

There is no SQL Server entry in the services.msc list, nor is there an Instance Names in the registry.

Is there anyway I can create an instance?

[Rabbit]

Open up the SQL Server Configuration Manager and start the service from there.

[ck9663]

Are you sure you installed the server component and not the client?


~~ CK