Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Can anyone please help me with this as I'm sure im missing something small.

I am installing SP2010 on a Win7 Prof machine. All components on one machine. SQL2008R2 installed and all the features are activeted as per this script on this site:

http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

But now I'm executing this in Powershell:

$sp_cfdatabasename = "SP2010_ConfigDB"
$sp_cadatabasename = "SP2010_Admin_Content"
$sp_databaseserver = "HomeDev"
$sp_passphrase = (ConvertTo-SecureString "SP_Svc1_" -AsPlainText -force)
$sp_password = (ConvertTo-SecureString "SP_Svc1" -AsPlainText -force)
$sp_username = "Lüs-PC\SP_Svc"

# Clean up the credentials
$sp_credentials = New-Object System.Management.Automation.PsCredential $sp_username,$sp_password

# Execute the config wizard
Write-Host "Add configuration and administration databases"
New-SPConfigurationDatabase -DatabaseName $sp_cfdatabasename -DatabaseServer $sp_databaseserver -AdministrationContentDatabaseName $sp_cadatabasename -Passphrase $sp_passphrase -FarmCredentials $sp_credentials

I keep on getting this below:

New-SPConfigurationDatabase : Cannot connect to database master at SQL server at HomeDev. The database might not exist, or the current user does not have permission to connect to it.

I did verify all permissions for the installation account and SP_Svc account in SQL.

HomeDev is a SQL Alias for my server name as I have a special character in my machine name.

Does anyone have any info on why this is happaning?

share|improve this question
add comment

2 Answers 2

I have also this error. In my case solution was simple:
If your SQL Server has 'Named Instances' you should write full name including your machine name: MY-MASHINE\MY-SQLSERVERNAME

share|improve this answer
add comment

I usually see this error message when the Windows Firewall is blocking access to SQL Server. Did you open the correct port?

You can check if you can reach your SQL Server via an alias by using a little trick I describe on my blog ("Testing Your Alias" at the bottom of the article):

http://thomasvochten.com/archive/2011/06/sql-aliases-in-the-real-world/

If that does not work, I suggest looking at your SQL Alias configuration.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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