Microsoft KB Archive/320492

= 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:

&quot;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.&quot;

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:  Open SQL Enterprise Manager. On the Tools menu, click Wizards. In the Select Wizard dialog box, expand Database, and then double-click Create Login Wizard. Complete the steps in the wizard.</ol> </li></ul>

<div class="status_section">

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.