Solved

NewSPConfigurationDatabase Still does not connect to database

Posted on 2011-03-08
4
1,129 Views
Last Modified: 2012-05-11
I have this same problem - and already did the "accepted solution" (enabled shared pipes and actually turned Windows Firewall off temporarily), but did not fix.  I have installed SQL Server 2008 R2 as MSSQLSERVER on the same development computer in a workgroup (not a domain).  For this, I will use "computername" as the computer name.  I have tried as a database server:

MSSQLSERVER
localhost\MSSQLSERVER
computername
computername\MSSQLSERVER
localhost
(local)

None of these work.
0
Comment
Question by:MAGLOCLEN
  • 3
4 Comments
 
LVL 5

Expert Comment

by:idmedellin
Comment Utility
Aparently you use the computer name as the name of a instance. If it, you should use computername\computername.

You may verify in the service console of the server, looking form mssqlserver\servername
0
 

Author Comment

by:MAGLOCLEN
Comment Utility
Thanks, but that didn't work either.
So, now, I can add the following to my failed attempts:

computername\computername
.\mssqlserver
.

I have some MSDN tickets to use and will call Microsoft support.
0
 

Accepted Solution

by:
MAGLOCLEN earned 0 total points
Comment Utility
I just retried simply using computername as the database server name, and it worked.  It's possible that I hadn't yet fixed the named pipes or firewall problem when I first tried it.
0
 

Author Closing Comment

by:MAGLOCLEN
Comment Utility
The question on which this question is based simply had a name as the server without saying that that was the computername.  Now I have clarified that it is simply the computername.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

728 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

8 Experts available now in Live!

Get 1:1 Help Now