问题描述
我已按顺序安装以下软件：
1. IBM DB2 Express C版本10.5.1
2. IBM Data Studio 4.1.0.1版
I have installed following software in the order:1. IBM DB2 Express C version 10.5.12. IBM Data Studio version 4.1.0.1
我有本地管理员权限。
我使用我的公司域帐户（SomeDomain \BharatMori）安装了上述两个软件
I am having local admin rights.I have installed both above software using my corporate domain account (SomeDomain\BharatMori)
安装Express-C时，我创建了一个用户 - 'db2admin '。我对凭证很积极，所以没有机会，我提供错误的凭据。
While installing Express-C, I have created a user – ‘db2admin’. I am quite positive on credentials so there is no chance that I am providing wrong credentials.
现在，当我尝试使用Data Studio连接时，它不允许我。所以，我已经连接到数据库使用命令行和创建新的数据库TEST。命令行没有问我任何凭据。我已经在其中创建了一个表 - tests，并在其中添加了一些记录。
Now, when I am trying to connect using Data Studio, it was not allowing me. So, I have connected to database using command line and created new database "TEST". Command line did not ask me any credentials. I have created a table - "tests" inside it and added some records in it.
现在，当我试图连接TEST数据库-C）使用Data Studio，弹出以下错误：
Now, when I am trying to connect TEST database (that is in Local DB2 Express-C) using "Data Studio", following error popped up:
我使用以下配置连接到本地数据库：
I am using following configurations to connect to local database:
我已创建数据库，表和几条记录使用命令行。
I have created database, table and few records using command-line.
I我不知道为什么IBM Data Studio没有连接到DB2 Express-C中的TEST数据库，而命令行可以这样做？我失踪了什么？请指导我。
I am not sure why IBM Data Studio is not getting connected to TEST database in DB2 Express-C, while the command line can do it? What is that I am missing? Please guide me.
推荐答案
您尝试使用 db2admin将Data Studio连接到TEST数据库用户帐户和密码。这通常是在DB2安装期间创建的拥有DB2应用程序代码，服务和注册表项的Windows用户帐户。您可以使用该帐户进行数据库管理，但我通常使用属于Windows管理员组的其他帐户。您可以在以下网址找到更多相关信息：
You're trying to connect Data Studio to the TEST database using the db2admin user account and password. This is typically a Windows user account created during DB2 installation that owns the DB2 application code, services and registry keys. While you can use that account for database administration, I typically use another account that belongs to Windows' Administrators group for that purpose. You can find more information about this at:
但是，当您在命令行登录时，用户名或密码，所以你登录到DB2登录到Windows的任何用户名和密码，我假设不是 db2admin 。虽然我不能说为什么你不能访问从命令行从db2admin帐户创建的TEST数据库，但是在任何情况下，你试图访问同一个数据库与两个不同的用户，所以完全可能的一个有权限这样做，而另一个没有。
When you log in at the command-line, however, you're not specifying a username or password, so you're being logged into DB2 under whatever username and password you're logged into Windows with, which I assume is not db2admin. While I can't say why you can't access the TEST database you created from the command line from db2admin account, know that in any case you're trying to access the same database with two different users, so it's entirely possible that one has permission to do so while the other doesn't.
这篇关于无法将IBM数据工作室与DB2 Express-C连接（错误：用户标识已撤销）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！