Urgent: Error 25621: Failed to creato SQL Database

Posted on 2005-05-16
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?
Question by:henrikatwork
    LVL 21

    Expert Comment

    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?
    LVL 1

    Author Comment

    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.
    LVL 21

    Accepted Solution

    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.
    LVL 1

    Author Comment

    I have asked how to use SQL Profiler to trace the installation program, in this question:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now