大家好，SQL Server2005变化有点大，又是用户名，又是登陆名的，感觉用起来颇麻烦
以前从CQ连接Oracle的时候，没有问题，但是换了SQL Server2005就怎么都连接不上了
错误信息如下，还请大家帮忙看看问题出在哪里
先谢谢了

Error: Unable to login to the database using the following connection information: DRIVER={SQL Server};UID=FidelityConn;DATABASE=Schema;PWD=***********;SERVER=10.10.14.108.
Verify that the information used matches the way the database was set up.
The error message was: SQLDriverConnect: RETCODE=-1, State=08001, Native Error=17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

问题已经解决 [打开主题]

本主题的最佳答案为 [ 5 楼].

你CQ是什么版本?

CQ 7.0支持SQL Server 2005 SP1，低版本不支持Sql server 2005，
详细情况，
http://www-1.ibm.com/support/doc ... amp;uid=swg21144624

此外，在使用SQL Server要配置成SQL Server and Windows混合验证。
还有，SQL Server 2005与2000有很大的不同，以下为IBM的解释，
引用自：http://www-1.ibm.com/support/docview.wss?uid=swg21239777

When using SQL Server 2005 for ClearQuest, the admin user of the database must be set to use a schema name that's the same as that user's username. Also, that schema will have to be created manually.

To change a user's schema name, start up the SQL Server 2005 Management Console.

Select the database being used.


Open up the Users tree in that database. If the user that will be used is already in that list, change its default schema to be the same as the username. Otherwise, add the user with a default schema that's the same as the username, and give it the db_owner role for this database.


Next, open up the Schemas tree in the database, and create a schema with the same name as the owner's username.

Note: No server roles should be selected for the users. This will cause problems with authentication even if the other roles and associations are made correctly.




This procedure is needed for each physical SQL Server database used by ClearQuest. It is only needed in SQL Server 2005.

If the above procedure does not work, try recreating the database using the following steps in the SQL Server 2005 management console:

Drop and recreate your database.


Open up the Databases tree.


Select the specific database you are using, then Security.


Right-click on Users, and pick New User... . then Users.


Enter a user name, the login name you want to use, and set the default schema to be the same as the login name.


Go to the Database role membership list and check db_owner. Then click OK.

我的CQ是7.0版本的
多谢版主，我明天再试试

这个是我写一个如何在SQL 2005下面建立适用于CQ DB的步骤
可以参考一下

1. Click windows start menu -> Programs -> Microsoft SQL Server 2005 CTP -> SQL Server Management Stuidio to start Microsoft SQL Server Management Stuidio
2. In the left Object Explorer, click "Databases" and you can see all the existing DB on this SQL Server 2005.
3. Right click "Databases" and select "New Database...".
4. Create your DB ,e.g. "TestDB" as your database name. Click Option and select the DB codepage from the drop-down menu "Collation". E.g. "Latin1_General_CI_AI".
   Keep other setting as default and click OK to create DB
5. Return to the "Object Explorer", click Security -> Logins and create a login here. e.g. "liuqiang" as the login name
   Select SQL Server authentication and uncheck  "Enforce password policy".
   Input your password for the login.
   Keep other setting as default.Then click OK.
6. Return to the "Object Explorer" and select the database you just created "TestDB" in "Databases"
7. Click TestDB->Security->schemas to see all the schemas contained in this DB. Create a new schema here.Please notify that the schema name must be the same as your login name input in step 5.
   Keep other settings as default and click OK.
8. Return to the "Object Explorer" and select the database you just created "TestDB" in "Databases"
9. Click TestDB->Security->Users  to see all the users. Create a new user here whose name must be the same as the login name you have set in step 5.
   Input your login name the same with the user name.
   Select the schema you've created in step 7 as your default schema.
   Select db_owner for the user in the "Database role membership"

Till now, the DB on SQL Server 2005 can be used as CQ Vendor DB.
Here are something we should notify:
1.The login name, schema name and db user name must be the same one. Otherwise, there will be an error when you create a CQ schema repo or user DB.
2.Although you can create more than one schema in one DB (this is similar with Oracle), you can not use this DB as CQ Schema repo and user DB at the same time.
  You have to create two different DB for CQ schema repo and User DB.

最佳答案

该回答被楼主/管理员列为正解!

Well done
Thanks a lot
I'll follow up and give you feedback ASAP tommorow
Thanks again

唉，还是安装不上，已经全部按照softfly的步骤做了
错误信息和以前一摸一样，没有库或者连接不上
大家继续帮帮我的忙吧

还是装不上啊

softfly和yunshan救命啊

终于搞好了
是我自己出现了小的错误
多谢两位的帮助