Michael L.
Well Known Member
List, below is the error I get when running the SpecialInstrs.bat file for the latest planner ESU JK16780 for 8.12. I did not find anything on Metalink.
Below the error is a doc I used to enable remote connection but after refreshing services and stopping/starting SQL server 2005 Express, I receive the exact same error.
Any suggestions would be much appreciated. Thanks, Michael
8.12 / 8.98.4
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
This post is about allowing remote connections to SQL Server 2005 Express Edition
. If you ever need to move sql database, attach pre-configured database or detach existing database, you will need to enable remote connections in sql server 205 express edition. It is disabled by default.
You can do this using SQL Server Area Configuration.
Configuring SQL Server Area Configuration for remote connections
To do this, follow these steps:
1.Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2.On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.
Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
4.On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
Enabling SQL Browser Service
Additionally, you need to enable the SQL Browser Service to make remote connections.
Warning These steps may increase your security risk
. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses.
1.Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2.On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.
Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.
4.Click Start, and then click OK.
These are manual steps. If you want to script both these steps, watch out for the next post.
Below the error is a doc I used to enable remote connection but after refreshing services and stopping/starting SQL server 2005 Express, I receive the exact same error.
Any suggestions would be much appreciated. Thanks, Michael
8.12 / 8.98.4
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : 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..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
This post is about allowing remote connections to SQL Server 2005 Express Edition
. If you ever need to move sql database, attach pre-configured database or detach existing database, you will need to enable remote connections in sql server 205 express edition. It is disabled by default.
You can do this using SQL Server Area Configuration.
Configuring SQL Server Area Configuration for remote connections
To do this, follow these steps:
1.Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2.On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.
Note Click OK when you receive the following message:
Changes to Connection Settings will not take effect until you restart the Database Engine service.
4.On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.
Enabling SQL Browser Service
Additionally, you need to enable the SQL Browser Service to make remote connections.
Warning These steps may increase your security risk
. These steps may also make your computer or your network more vulnerable to attack by malicious users or by malicious software such as viruses.
1.Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
2.On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
3.On the Surface Area Configuration for Services and Connections page, click SQL Server Browser, click Automatic for Startup type, and then click Apply.
Note When you click the Automatic option, the SQL Server Browser service starts automatically every time that you start Microsoft Windows.
4.Click Start, and then click OK.
These are manual steps. If you want to script both these steps, watch out for the next post.
