First time using SQL 2008? Midnight trap for young players… and me

 

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?

System.Security.Principal.IdentityNotMappedException

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.

Done!

Brad

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.SPProcessIdentity.GetCurrentSecurityIdentifier()
   at Microsoft.SharePoint.Administration.SPProcessIdentity.GetCurrentSid()
   at Microsoft.SharePoint.Administration.SPProcessIdentity.Update()
   at Microsoft.SharePoint.Administration.SPApplicationPool.Update()
   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)
   at Microsoft.SharePoint.Administration.SPAdministrationWebApplication.CreateDefaultInstance

Advertisements

About Brad Saide

I'm a SharePoint consultant. I'm also slowly going bald, seem to have a permanent spare tyre around my waist and enjoy socialising with friends over a beer or 10. The last 2 may possibly be related. Started working with SharePoint when the first version was in limited beta release (participated in the Technology Adoption Program while at Woolworths) and have been committed to the adoption of the technology as a business enabler ever since.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s