Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am trying to install SQL Server 2012. During the install I get an error saying

Error installing SQL Server Database Engine Services Instance Features A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) Error code: 0x84BB0001

I have run the setup and given my user login and password as the account and password credentials for the all SQL server services (I'm happy with this, just need the program up and running to extract some data from a .mdf file)

I have set the database engine configuration to Mixed Mode and specified my password for the system administrator account.

The database engine does not install and the program tells me to uninstall these components and re-install them. I have done that several times now (using different credentials etc) not sure what to do next.

I have previously had SQL 2008 running on this machine so dont think there would be anything preventing me from getting SQL 2012 to work?

I also managed to install the express version which installs fine. But the .mdf file I need to use is larger than 10gb.

share|improve this question
    
Quick questions: Are you sure you're not doing a 'upgrade' of a prior instance and in fact it's a brand new instance? At what point exactly do you get this error message? –  Ali Razeghi Dec 2 '13 at 22:49
add comment

closed as off-topic by Paul White, RolandoMySQLDBA, Max Vernon, Kin, Marian Feb 12 at 9:30

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Paul White, RolandoMySQLDBA, Max Vernon, Kin, Marian
If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

The error message is the generic "I can't reach the SQL instance you've specified." There are no components to "uninstall/reinstall", mixed mode/Windows mode are simply configuration settings. I generally recommend you run in mixed mode.

Two things to check:

  1. If this is a SQL Express instance, you should make sure your connecting to [Computer Name]\SQLEXPRESS. SQL Express installs as a named instance, so as such needs to be connected to as a named instance.

  2. By default, SQL Server installs without TCP protocols enabled, which would prevent most connections. Open your SQL Server Configuration Manager, browse to SQL Server Network Configuration, and then Protocols for SQLEXPRESS. Select that and look for TCP/IP and make sure it's enabled.

As for your file being larger than 10 GB, you'll need to use Standard Edition or higher, nothing you can do to get around that. You can have a separate instance running alongside the Express instance, but if you want you can simply uninstall your Express instance as you would any other Windows program.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.