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

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.

Cause

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.

Resolution

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×