Solved

NewSPConfigurationDatabase Still does not connect to database

Posted on 2011-03-08
4
1,142 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 5

Expert Comment

by:idmedellin
ID: 35076928
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
ID: 35083347
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
ID: 35083618
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
ID: 35126286
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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Suggested Solutions

I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 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