“Divas” are rarely as talented or knowledgeable as they’d like to be. Call it a statement of intent. An “if you build it they will come…” idea. Or call me a complete poser. Whatever… I’m attempting to share the knowledge of my success and failures. Like every good diva-poser-scientist-wannabe, I imagine I’ll be encountering far more failures than successes.
So far, trying to use SQL Server 2008 with Microsoft Office SharePoint Server 2007 on a Windows Server 2008 isn’t working for me. Actually I’d not even reached the MOSS installation part yet. I was just trying to do the step before installing the Windows SharePoint Services 3.0 x64 with Service Pack 1. The part where I go into SQL Server Surface Area Configuration and allow Remote Connections.
And I find there is no such animal in 2008. So if anyone knows how to allow remote connections on SQL Server 2008, please let me know. My google-fu has yet to find any answers. For now, we’re going back to 2005 in this installation.
This was driving me crazy. We’re performing a fresh installation on a fresh server; Microsoft Office SharePoint Server 2007 on a Windows Server 2008. I’ve reached the part of the installation where I’m installing SQL Server 2008. No matter what I put in for the UserName, I’d get the error “Invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent service.”
Looking at the forums, it wasn’t just me. Several people provided answers or reporting not having any issue, but it was obvious, from the continuous pleas for help, that the responses weren’t providing the help asked for. Maybe they’re like me; I need pictures. So here’s my error:
Peter Saddow from MSFT listed the answer, but it took me a few tries to understand it.
invalid or missing username or password. To continue, provide valid credentials for the SQL Server Agent Service – MSDN Forums
I suppose won’t know until later if this was completely the correct action to take, but it did get me beyond this screen, which after umpteen tries is all I really wanted at this point:
sharepointdiva
