SQL Server Management Studio without database

[Beppe]

i have installed Sql Server 2005 Developer edition,before i have
installed visual studio 2008.
When i launch "SQL Server Management Studio" appear a window screen
with

server type: database engine
server name:
authentication: Windows Authentication

Login: domain\mylogin
Password:

i have two fields with a blank value, so i type "MSSQLSERVER" in
server name but when i click on "Connect" i have this error:

"An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (provider: Named Pipes Provider, error: 40 – Could not
open a connection to SQL Server Could (Microsoft SQL Server, Error:
53) "

I have not database selectable in window of database engine

where i can found default instance of database that install sql server
2005?

thank a lots :-D
bye

[Beppe]

when i insert in "server name: " the name of mypc e then click on
Connect appear message:

Msg 18456, Level 14, State 1, Server <server name>, Line 1
Login failed for user '<user name>'

I try right-click SQL Server Management Studio, and then click Run As
Administrator.

I have digit
server type: database engine
server name: Name-of-my-PC
authentication: Windows Authentication
Login: Mydomain\mylogin
Password: empty

In fact i see the database engine of my instance that i created during
installation of Sql Server 2005 Dev Edition

good bye

[Erland Sommarskog]

Beppe (jackf...@gmail.com) writes:
> when i insert in "server name: " the name of mypc e then click on
> Connect appear message:

Instead of the machine name, you can use "." or "(local)" instead.

> Msg 18456, Level 14, State 1, Server <server name>, Line 1
> Login failed for user '<user name>'
>
> I try right-click SQL Server Management Studio, and then click Run As
> Administrator.

And you still can't login?

When you installed SQL Server, did you enable SQL authentication? In such
case you could try to log in as "sa" provided that you remember which
password you used.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx