Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. When you install Web Services for Microsoft Dynamics GP, the error "The selected database exists, but its owner is not a valid Windows user. Please provide a different database name." may appear

When you install Web Services for Microsoft Dynamics GP, the error "The selected database exists, but its owner is not a valid Windows user. Please provide a different database name." may appear

Symptoms

When you install Web Services for Microsoft Dynamics GP, the error
"The selected database exists, but its owner is not a valid Windows user. Please provide a different database name."
may appear.

↑ Back to the top

Cause

The database entered for the "Database Name" field in the SQL Server Connection Information window already exists and has a database owner configured to have a SQL logon. For example, the DYNAMICS system database and company databases for Microsoft Dynamics GP will have a dbo configured as "DYNSA". Therefore, you cannot use the DYNAMICS system database and company databases to store the security for Web Services.

↑ Back to the top

Resolution

To resolve the issue, enter a database name which is not the DYNAMICS system database and company databases for Microsoft Dynamics GP. Best practice for installing Web Services that has the SQL Server database option to store security is to select a new unique database that uses a name which represents the purpose of the database, for example WSSecurityDB.

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2421630
Revision : 1
Created on : 1/7/2017
Published on : 8/5/2011
Exists online : False
Views : 135