Teman2,
Database SQL Server 2000 di PC saya terkena Virus Kespo sehingga terjadi
suspect, lalu ketika ingin di attach kembali terjadi error torn page id
000000000000000000, sehingga databasenya tidak bisa digunakan kembali. Saya
sudah lakukan banyak cara spt merebuild Sql tersebut by Script tapi tetap tidak
bisa. Apakah teman2 tahu solusi agar database tersebut bisa baik lagi. Terima
kasih atas bantuannya ???
Wahid Abdi Mukmin <[EMAIL PROTECTED]> wrote:
coba ni mas, by aawam3
Cannot open user default database, login fails
hi:
I got the problem, which lots of people might encounter before. In my case, I
use login control and sqlexpress to build a login page.
when password & user name were entered. It gave me:
"Cannot open user default database, login fails"
The solution given by msdn is:
SQL Server 2005You can use the sqlcmd utility to change the default database
in SQL Server 2005. To do this, follow these steps: 1. ClickStart,
clickRun, typecmd, 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
NoteInstanceName 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
NoteAvailDBName 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, typeGO, and then press ENTER.I wonder what areInstanceName,SQLLogin
&AvailDBName. It would be nice if someone can give me a specific example, since
I am not sure how to type them in a command line. :)
---------------------------------
Bergabunglah dengan orang-orang yang berwawasan, di bidang Anda di Yahoo!
Answers
---------------------------------
Never miss a thing. Make Yahoo your homepage.
