I followed the thread on "SQL 2008 Services missing" and pretty much did everything the threads suggested. I am running Win/XP (SP3), and up until a few days ago was running SQL Express 2005 successfully for a couple of years. I decided
to upgraded to 2008 to be consistent with others co-workers on current projects.
Long and short of it, I completely had to strip out 2005 and reinstall 2008. After a couple of runs at it, it all appeared to install clean and neat, until I attempted to log onto the local server (which shows up as installed in Add/Remove programs,
just not as a service either in SQL configuration tool or from the Services list under XP.)
Despite following the SQL Express logon instructions from the previous thread I mentioned, I continually get the error
Cannot connect to ..
A network-related or instance specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that the SQL Serve is configured to allow remove
connections. (provider: Named Pipes Provider, error: 40 - could not open a connection to SQL server) (Microsoft SQL Server, Error: 2)
Server type - "Database Engine"
Server name - "." and "./SQLEXPRESS" (neither have worked thu
View Complete Post