Tengo instalado el SQL Server 2005, generalmetne me conecto a un servidor externo y no a mi local....pero ahora que necesito trabajar localmete no puedo conectarme me sale el sgte mensaje.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verifify that the instance name is correct and that SQL SErver is configured to allow remote connections. (provider:TCP Provider, error:0-no connection could be made because the target machine actively refused it)(Microsoft SQL Server, Error:10061)
trate de ingresar al SAC pero no puedo me muestra el sgte error:
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you not an administrator on this computer. (SQLSAC)
Since this is English Forums, if you have any technical question about SQL Server , you can translate your question in English or your question to your local forum. I move the question to the related forums, it is appropriate and more experts will assist
Base on your error message, we need to verify the following things.
1.You enable the TCP/IP, VIA protocol on the client machine,
2.Your SQL Server is allowed to connect remotely and the firewall allows SQL remote and a Local Connection.
3. Your SQL Server is listening on the port your specified in the connection string, for example, the default port is 1433.