So I had a client coming over to do some integration work tomorrow (which is now later today) and I had to get SharePoint set up, pointing to their domain. Pfffft no problems, I’ll do it just before I go to bed. That was about 6 hours ago now…
I have a stab at the install… What’s this?
Hmmm… Security. Okay, no problems. It’s a VM, running on VMWare over Fedora. It’s probably got a dodgy time on the DC. Sure enough, the time’s out by about 20 hours. So I bring it back inline, run my script to tell it to get the time from the internet and have another crack.
Same problem. Okay… what if I just use a local account to run the connection to the local database? That takes the DC out of the equation… but I know it’ll bite me later on… oh never mind.
Same problem. It’s now well after midnight and my only friend is the quiet hum of the fridge compressor. Okay, what if it’s something to do with the SQL settings? I’m running SQL 2008 Dev edition…
Aha! Named Pipes and TCPIP are turned off. How is a web app going to communicate with a SQL server no matter where it is except over TCPIP? Sure enough, turning it on did the trick… and changed the error message 🙂 But it’s an easy one, and unrelated to this – so if you need the settings, they are here –
Crack open SQL Server Configuration Manager and drill down to:
SQL Server Network Configuration
L>Protocols for MSSQLSERVER
On the right you will see the services, enable the ones you need. finally, go to the SQL Server Services Folder and restart the server service to have the changes take effect.
PS – the error code snip’s below to help Google index it and lead other people here looking for the light. This error doesn’t appear much in the ones I saw…
10/24/2008 03:12:03 8 INF Creating a new farm with config db SharePoint_Config content db SharePoint_AdminContent_f257f33b-5879-4676-bce4-e2b58416c2c6 server hv102 for farm mode
10/24/2008 03:12:17 8 ERR Task configdb has failed with an unknown exception
10/24/2008 03:12:17 8 ERR Exception: System.Security.Principal.IdentityNotMappedException: Some or all identity references could not be translated.
at System.Security.Principal.NTAccount.Translate(IdentityReferenceCollection sourceAccounts, Type targetType, Boolean forceSuccess)
at System.Security.Principal.NTAccount.Translate(Type targetType)
at Microsoft.SharePoint.Administration.SPWebApplication.CreateDefaultInstance(SPWebService service, Guid id, String applicationPoolId, IdentityType identityType, String applicationPoolUsername, SecureString applicationPoolPassword, String iisServerComment, Boolean secureSocketsLayer, String iisHostHeader, Int32 iisPort, Boolean iisAllowAnonymous, DirectoryInfo iisRootDirectory, Uri defaultZoneUri, Boolean iisEnsureNTLM, Boolean createDatabase, String databaseServer, String databaseName, String databaseUsername, String databasePassword, SPSearchServiceInstance searchServiceInstance, Boolean isPaired, Boolean autoActivateFeatures)