SQL Server Installation related issues

Recently, the database (Sqlserver2005develop) has encountered many problems deploying a project, which is listed below.

After the installation is complete, you cannot connect to the on-premises instance.

Open the Microsoft SQL Server 2005-> Configuration Tool->sql Server Config management, and discover the SQL Server in which 2005 Service and sqlserver2005 network configuration blank.

Cause: When installed, only the client is installed, and the server is not installed. Recall that the installation process can be found, and you are not prompted to fill in the instance name.

Workaround: Download and install the appropriate version of the server, patching, preferably installed in the same directory, Windows things error is not easy to find the reason, so security, it is best to uninstall, reinstall.

When importing a flat data source, an error similar to the following occurred:

Error 0xc0202049: Data Flow Task 1: Unable to insert data in read-only column ' ID '.

(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task 1: Validating column metadata failed.

(SQL Server Import and Export Wizard)

Error 0XC004706B: Data Flow Task 1: "Component" target-t_*** "(34)" Validation failed and the validation status returned is "Vs_isbroken".

(SQL Server Import and Export Wizard)

Error 0XC004700C: Data Flow Task 1: One or more components failed validation.

(SQL Server Import and Export Wizard)

Error 0XC0024107: Data Flow Task 1: Error during task validation.

(SQL Server Import and Export Wizard)

Workaround:

To return to the previous step, a window titled "Select Source table and Source View" appears, click the Edit button under the Mapping column, tick "Enable identity insertion (I)" in the pop-up window, OK, continue.

When you access a local service, you can access it with an instance name, but not with an IP address.

My database port is 1433 (SQL Server is typically this), ensuring that the port is not disabled by the firewall.

Workaround:

1. Open Microsoft SQL Server Management Studio, link the data source with the instance name, and then right-click the database name--Properties--Link: Under the right, check allow remote connections to this server (A).
2. Open the SQL Server configuration management,sqlserver2005 Network config->< instance name > protocol, enable TCP/IP. Double-click on it to open the TCP/IP properties, view the IPs, see a lot of IP, we want to modify their TCP port number and the enabled option, on the safe side, all TCP ports can be set to 1433, all enabled set to Yes.

Recommended articles:

Resolution of "SQL Server does not exist or access is denied" issue

SQL Server Installation related issues