Knowledge Base

FIX: Cannot Install Userstore Database Alone on a Server

Article ID: 320492

Article Last Modified on 6/18/2003

APPLIES TO

Microsoft TV Server 2.0 Service Pack 1

This article was previously published under Q320492

SYMPTOMS

When you try to install only the UserStore database on a server, you receive the following error message:

"osql -n -S(local) -U sa -P Titlpwc! -d userstore -i userstore_db\us_grant_access.sql
Msg 15007, Level 16, State 1, Server store-111, Procedure sp_grantdbaccess, Line 97

The login 'wtv_service' does not exist.
Msg 15410, Level 11, State 1, Server store-111, Procedure sp_addrolemember, Line 66

User or role 'wtv_service' does not exist in this database."

However, when you install the same build on another computer that has either Wdaldict or Sud installed before you install UserStore (or while you are installing UserStore), the problem does not occur.

CAUSE

In the standalone installation of UserStore, the user wtv_service is not created.

RESOLUTION

To resolve this problem, install the latest service pack for Microsoft TV Server.

WORKAROUND

To work around the problem, do one of the following:

Install Service Pack 2 before you create a standalone Userstore.

-or-
If you have already created a standalone Userstore, and if the user wtv_service does not exist, create the user wtv_service. To do this, follow these steps:
1. Open SQL Enterprise Manager.
2. On the Tools menu, click Wizards.
3. In the Select Wizard dialog box, expand Database, and then double-click Create Login Wizard. Complete the steps in the wizard.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was corrected in Microsoft TV Server 1.0 Service Pack 2.

Additional query words: UserStore wtv_service standalone

Keywords: kbbug kbfix kbprb KB320492

Microsoft KB Archive/320492

Contents