Unable to connect to SQL Server Express
The default SQL Server express installation does not enable TCP network protocols, so here are some steps to take to be able to communicate with SQL Server Express. These steps should be similar for both MS SQL Server Express 2005 and 2008.
1. Launch the SQL Server Configuration Manager. It should be in the Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools start menu option.
2. Select the SQL Server 2005 Network Configuration tab. There should be a Protocols for SQLExpress option, and one of the protocols should be TCP IP.
3. Enable the TCP IP protocol if it is not enabled.
4. The default port for SQL Express may not be 1433. To find the port it is listening on, right-click on the TCP IP protocol and scroll all the way down to the IP All heading. There should be a section called TCP Dynamic Ports. This should list the port SQL Express is listening on. You can then put this value into the port field when adding the connection profile via RazorSQL.
Make sure to restart SQL Express before trying to connect
1. Launch the SQL Server Configuration Manager. It should be in the Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools start menu option.
2. Select the SQL Server 2005 Network Configuration tab. There should be a Protocols for SQLExpress option, and one of the protocols should be TCP IP.
3. Enable the TCP IP protocol if it is not enabled.
4. The default port for SQL Express may not be 1433. To find the port it is listening on, right-click on the TCP IP protocol and scroll all the way down to the IP All heading. There should be a section called TCP Dynamic Ports. This should list the port SQL Express is listening on. You can then put this value into the port field when adding the connection profile via RazorSQL.
Make sure to restart SQL Express before trying to connect
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9697/viewspace-1470202/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- unable to connect to converter enterprise serverServer
- SQL server 2005 expressSQLServerExpress
- SQL Server Express和SQL Server Compact的應用SQLServerExpress
- SQL Server 2005 Express Edition 概述SQLServerExpress
- 深入理解connect/expressExpress
- Unable to connect to any hosts due to exceptionException
- 已安裝 SQL Server 2005 Express 工具。若要繼續,請刪除 SQL Server 2005 Express 工具SQLServerExpress
- SVN-Unable to connect to a repository at URL
- Unable to Connect to Database with Oracle Client Software for WindowsDatabaseOracleclientWindows
- SQL Error (1130): Host IP is not allowed to connect to this MySQL serverErrorMySqlServer
- SQL Server 2005 Express混合模式登入設定SQLServerExpress模式
- 設定SQL Server 2005 Express混合模式登入SQLServerExpress模式
- SQL Server CDC配合Kafka Connect監聽資料變化SQLServerKafka
- Unable to start HTTP server after restoreHTTPServerREST
- express快速搭建web serverExpressWebServer
- 【Azure Redis】部署在AKS中的應用連線Redis時候出現Unable to connect to Redis serverRedisServer
- Unable To Initiate A Distributed Transaction From Sql Server on Windows 2003 SP1SQLServerWindows
- 【超詳細】SQL Server2012 Express版本安裝教程SQLServerExpress
- START WITH and CONNECT BY in Oracle SQLOracleSQL
- Host 'localhost' is not allowed to connect to this MySQL serverlocalhostMySqlServer
- Connect SQL Server from Linux Client using Windows Authentication and troubleshoot stepsSQLServerLinuxclientWindows
- ORA-15055 Unable to Connect to ASM When Starting an InstanceASM
- 【kiss0kill】SQL SERVER EXPRESS 常見問題及解決辦法SQLServerExpress
- asp.net連線資料庫(SQL Server 2005 Express)詳細說明ASP.NET資料庫SQLServerExpress
- psql: error: could not connect to server: No such file or directorySQLErrorServer
- 【SQLServer】linked server "" was unable to begin a distributed transaction.SQLServer
- Kubeadm安裝k8s叢集升級100年證書時報錯:Unable to connect to the server: EOF:求解決方法.K8SServer
- SQL in ORACLE and SQL ServerSQLOracleServer
- sql ServerSQLServer
- nested exception is io.lettuce.core.RedisConnectionException: Unable to connect to localhost:6379ExceptionRedislocalhost
- TNS-12535 Unable To Connect To Remote Database using certain ApplicationsREMDatabaseAIAPP
- ASM例項啟動報錯:ORA-29701 :unable to connect to Cluster ManagerASM
- 配置VS2008自帶的SQL Server 2005 Express sa登陸SQLServerExpress
- SQL Server連線SQL Server、SQL Server連線ORACLE 連結伺服器SQLServerOracle伺服器
- Host 'xxx' is not allowed to connect to this MySQL server.MySqlServer
- Xtrabackup備份報錯Failed to connect to MySQL serverAIMySqlServer
- [jenkins]Can’t connect to window server – not enough permissionsJenkinsServer
- MySQL5.7 Unable to find a match: MySQL-community-serverMySqlUnityServer