DB2 and NT / Bad Login

Hi Lee,

A good place to start looking for help is the online documentation, particularly
the books "DB2 Personal Edition Installation Guide", "DB2 for Windows Quick
Beginnings" and "DB2 Personal Edition quick beginnings". If you purchased DB2, as
opposed to trialling a copy off the web, you probably have at least one Quick
Beginnings book in print. Do look in it.

(Look in start-> programs -> IBM DB2 -> Information -> Information Center, then
select the Books tab, and expand "Getting Started" or "Installation &
Configuration")

When you connect to DB2 (v7) under NT or Win2000, the default will be to connect
using your current login id. Many applications will allow you to specify what
name and password to use, but the "Create sample database" feature of the startup
screen is not one of them -- it will use your current logged-on id.

DB2 v7 under NT or W2k will grant SYSADM (system administrative) authority to
accounts in the Local administrators group, (which will include the Domain admins
also).

In terms of default passwords, there aren't any I'm aware of. When you install,
the setup program asks about an account to use for DB2 itself to run, and suggests
letting it create one called "db2admin". At that time you can specify the
password for this account. If you change the password of that account (whether
you used db2admin or something else) you will need to alter any of the DB2
services that use the account to run: go to services control panel, check the DB2
ones, and if they use the named account to start then they also need the correct
password.
The online documentation also describes the privileges required on the account DB2
uses itself. If you specified an existing account during install, you may have to
add those privileges yourself. (It's in Quick Beginnings).

I hope that helps,
Greg
Lee wrote:

> I installed DB2 on a Windows NT workstation. I have been unable to create
> databases due to the security server giving a SQL1092N. It appears to be
> using ny network security login as the userid.
>
> Any help or hope? Also what are the intial passwords DBAADMIN and SYSSYSMAINT?
> Is it in the documentation. Thanks.