[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Urgent: Error 25621: Failed to creato SQL Database

Posted on 2005-05-16
4
Medium Priority
?
255 Views
Last Modified: 2008-02-01
(-2147467259 Business Scorecards)

I get this error when installing Microsoft Office Business Scorecards. I have a user myDomain/administrator, which is admin on the server (win 2003 server) and also a user in the SQL Server 2000 Ent. edt. In Enterprise manager, under Security/Logins myDomain/administrator  I have clicked in all server roles on this user  plus clicked permit access to all databases.

Any ideas what I've done wrong?
0
Comment
Question by:henrikatwork
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:Kevin3NF
ID: 14010307
Please post the full error message (unless that was all of it).

Also, can you log onto the server as that user and create a database?
0
 
LVL 1

Author Comment

by:henrikatwork
ID: 14015657
Yes, that was the full message from the little OK-box that popped up


I logged in as that user (windows authentication) into Query analyzer and ran a database creation script and it worked fine.
0
 
LVL 21

Accepted Solution

by:
Kevin3NF earned 1350 total points
ID: 14015918
My next thought would be to run profiler at the same time as the MOBS install (I have no idea what that product is) and see what statement is actually passed to the SQL Server engine, and under what user context.  If it fails, take that statement from profiler and run it in QA.
0
 
LVL 1

Author Comment

by:henrikatwork
ID: 14017395
I have asked how to use SQL Profiler to trace the installation program, in this question:
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21426681.html
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question