13. SQL Server 2005 - Great Learning Resource
Whether you're a total newbie to databases, and need of a good foundation, a seasoned pro that wants a little review, or a developer that wants to help educate his clients, a series of well executed training videos is a great way to go.
Have you installed SQL Server 2005, set all the right SQL Server settings, and still can't browse the server? If you're running XP Pro service pack 2 or later, you may have forgotten to fix this issue at the FIREWALL! (doh!)
Error: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code -2146885628.
The Solution: Opened the "properties" dialog for the service, and on the Log On tab, changed the user from "This Account" to "Local System Account". Started the service, and bingo.
Share your knowledge with the WORLD! In addition to adding comments to existing posts, you can post knowledge you've acquired. We welcome full articles (intro with screen shots), general posts (shorter), and tidbits (tips, FAQs, definitions, etc.).