Announcement

Collapse
No announcement yet.

MS SQL Express 2008 R2 Initializing Database error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • MS SQL Express 2008 R2 Initializing Database error

    I am installing a software that uses SQL Express DB,known as onsite.

    However,whenever i try to install,i get an error when the program is initializing the database.

    " could not connect to database.....contact administrator"

    see an attached image.

    have tried to uninstall SQL,etc,but haven't succeeded yet,

    help
    Last edited by pope; 13th August 2013, 06:16.

  • #2
    Re: MS SQL Express 2008 R2 Initializing Database error

    is there anyone willing to assist me on this

    Comment


    • #3
      Re: MS SQL Express 2008 R2 Initializing Database error

      How do you specify the database server and instance name?

      Are you installing the application on the SQL server itself? If not, have you enabled TCP/IP for the SQL instance? (Network protocols are disabled by default.)

      Comment


      • #4
        Re: MS SQL Express 2008 R2 Initializing Database error

        In some machines, it works well,in others it has refused.

        By default,installing the application should install SQL as well.

        I am installing on the software on the machine...not on the SQL server itself.

        I have enable tcp/ip but i stll get the same problem
        Last edited by pope; 12th August 2013, 14:22.

        Comment


        • #5
          Re: MS SQL Express 2008 R2 Initializing Database error

          I'm assuming this 'onsite' database is the application specific database you need for your new app...

          its failing during the install when it attempts to create the database or when it attempts to connect to the database (because it already exists)?

          Does the account you are using to install the app have db_creator on the SQL instance?

          is the SQL instance already installed or does the software invoke the installer?
          Rules of life:
          1. Never do anything that requires thinking after 2:30 PM
          2. Simplicity is godliness
          3. Scale with extreme prejudice


          I occasionally post using a savantphone, so please don't laugh too hard at the typos...

          Comment


          • #6
            Re: MS SQL Express 2008 R2 Initializing Database error

            Thanks..

            The software should invoke the installer when installing it

            I have tried installing the software in this specific machine as an administrator,local user, domain user and all give the same error.

            In some machines, i was prompted to install Sql_Express 2008 r2 first before installing the onsite.

            Comment


            • #7
              Re: MS SQL Express 2008 R2 Initializing Database error

              What happens if you create the database (blank) before installing the software? Maybe the software is expecting a blank database so it can create schema?

              Did you check to make sure the domain account you are using to install the software has a login to the SQL instance and has the db_creator system role (in SQL mgmt studio)?

              What do the SQL logs say? There should be something in there explaining why the db couldnt be created/initialized
              Rules of life:
              1. Never do anything that requires thinking after 2:30 PM
              2. Simplicity is godliness
              3. Scale with extreme prejudice


              I occasionally post using a savantphone, so please don't laugh too hard at the typos...

              Comment


              • #8
                Re: MS SQL Express 2008 R2 Initializing Database error

                database blank how?

                SQL log files ..am not sure if am checking the correct location of the logs..let me know the precise event log location

                Comment


                • #9
                  Re: MS SQL Express 2008 R2 Initializing Database error

                  Have you contacted the software vendors at all?
                  Tom Jones
                  MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
                  PhD, MSc, FIAP, MIITT
                  IT Trainer / Consultant
                  Ossian Ltd
                  Scotland

                  ** Remember to give credit where credit is due and leave reputation points where appropriate **

                  Comment


                  • #10
                    Re: MS SQL Express 2008 R2 Initializing Database error

                    Hey Pope, the SQL logs I'm talking to are visible using sql server management studio (ssms).

                    if you start it up and expand the management node in the tree, you will see a "SQL Server Logs" node. Look at the current log for information on why its not initializing the database.

                    To create a blank database, just use SSMS. You can right-click the "Databases" node and create a new one that way. If you want to use tsql, you can do it that way as well but you have to specify a bunch of parameters:

                    Something like this should work (Its been a while since I wore my dba hat):

                    USE master;
                    GO
                    CREATE DATABASE onsite
                    (
                    NAME = onsite,
                    FILENAME = 'E:\Data\onsite.mdf',
                    SIZE = 1024MB,
                    FILEGROWTH = 1024MB
                    ),


                    Much easier for your purposes to just use SSMS. I'd be interested if the application error changes if the database exists as well...
                    Rules of life:
                    1. Never do anything that requires thinking after 2:30 PM
                    2. Simplicity is godliness
                    3. Scale with extreme prejudice


                    I occasionally post using a savantphone, so please don't laugh too hard at the typos...

                    Comment

                    Working...
                    X