Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tigertim71
Starting Member
1 Post |
 Posted - 2008-07-04 : 04:02:28
|
| Hi, I just reinstalled SQL Server 2005 express with advanced services and it's coming up with an error message which says it had problems establishing a connection to the server and that default settings may not allow remote connections (see text below). Have tried a few things, namely keeping all the browser services etc. running and on automatic. Have changed remote connections to accepting local and remote using both TCP/IP and named pipes in surface area configuration and all other connections on automatic and running, but no luck. Also can't find the firewall settings.Additionally,it has not installed reporting services, and I have done this process twice. There doesn't seem any point in me uninstalling/installing again.Has anyone had this problem before or know what to do?Thanks, Tim Details Product: SQL Server ID: -1 Source: MSSQLServer Version: 9.0 Component: SQLEngine Message: 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: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol) (Microsoft SQL Server, Error: -1) Explanation The SQL Server client cannot connect to the server. This error could be caused by one of the following reasons:The firewall on the server has refused the connection.A specified SQL Server instance name is not valid.The SQL Server Browser service (sqlbrowser) is not started. User Action To resolve this error, try one of the following actions:Make sure that you have configured the firewall on the server instance of SQL Server to open the SQL Server Browser port.Make sure that the SQL Server Browser service is started on the server.Check the spelling of the SQL Server instance name that is specified in the connection string.Use the SQL Server Surface Area Configuration tool to enable SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections. -------------------------------------------------------------------------------- |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 19:47:12
|
| Check if tcp/ip and named pipes are enabled in configuration manager, ensure you connect with correct instance name, or try connect with ip address and port number. By the way, RS needs web service to install. |
 |
|
|
|
|
|
|
|
sql server 2005 - not connecting to server