TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot show requested dialog.

------------------------------
ADDITIONAL INFORMATION:

Failed to connect to server BORNEO-007\SQLEXPRESS. (Microsoft.SqlServer.Express.ConnectionInfo)

------------------------------

Cannot open user default database. Login failed.
Login failed for user 'BORNEO-007\NazIruL dA GrEaT'. (Microsoft SQL Server, Error: 4064)

For help, click: http://go.microsoft.com/fwlink?ProdN...4&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

========================

i notice that after deleted default database that i used before...

i've try

SQL Server 2005

You can use the sqlcmd utility to change the default database in SQL Server 2005. To do this, follow these steps: 1.Click Start, click Run, type cmd, and then press ENTER. 2.Use one of the following methods, depending on the kind of authentication that the SQL Server login uses: •If the SQL Server login uses Microsoft Windows authentication to connect to the instance, type the following at the command prompt, and then press ENTER:sqlcmd –E -S InstanceName –d master
•If the SQL Server login uses SQL Server authentication to connect to the instance, type the following at the command prompt, and then press ENTER: sqlcmd -S InstanceName -d master -U SQLLogin -P Password
Note InstanceName is a placeholder for the name of the SQL Server 2005 instance to which you are connecting. SQLLogin is a placeholder for the SQL Server login whose default database has been dropped. Password is a placeholder for the SQL Server login password.3.At the sqlcmd prompt, type the following, and then press ENTER: ALTER LOGIN SQLLogin WITH DEFAULT_DATABASE = AvailDBName
Note AvailDBName is a placeholder for the name of the existing database that can be accessed by the SQL Server login in the instance.4.At the sqlcmd prompt, type GO, and then press ENTER.

but yield error result...

C:\Documents and Settings\NazIruL dA GrEaT>sqlcmd -e -s efams -d mast
HResult 0x7E, Level 16, State 1
VIA Provider: The specified module could not be found.

Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred wh
shing a connection to the server. When connecting to SQL Server 2005,
re may be caused by the fact that under the default settings SQL Serv
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

helpp...

i have resolved it... this problem occur when you delete the default database on the sql server 2005 ...

1. login using 'master' database
2. execute sql with the following code :

ALTER LOGIN SQLLogin WITH DEFAULT_DATABASE = AvailDBName

SQLLogin is such "BORNEO-007\Nazi370"
AvailDBName = available database on the server

3. restart the sql server 2005 and it works as usual

thanks for viewing ...
just for reference..