Hello, I have very little experience in SQL.
I have not had problems so far with my databases but when trying to use a service that accesses the server remotely, I get this error:
"The database is not currently reachable. The following error was reported from the AxisTV Content Server: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) "
Following through with trouble shoot instructions, and a couple of searches from Google, I get to this point in my SQL Management Studio Express and set it to look like this:
After doing this. I still get the same connection error.
A little more goggling I try changing the connection settings through Surface Area Configuration for Services and Connections. Once in there I click "Surface Area Configuration for Services and Connections" on the bottom and get the following error.
And now I am stuck. Can anyone help?