SQL Server 2005 Common analysis

Question 1: Use the. net2005 sql-express not connected.

Workaround:

1. Network firewall block database connection;

2. Default sql-express does not start sa account-> download a Management Studio Express Interface tool Management sql-express

3. Wireless network will appear according to the machine name can not find the SQL Server, directly with the IP connection

4. The service side opens the-> Configuration tool through the Start menu->sql Server perimeter Application Configurator-> service and the perimeter configuration of the connection-> remote connection-> to the right select local connection and remote connection-> use tcp/simultaneously IP and Named pipes.

Issue 2: Install Development on WIN-XP the "perform system configuration check on the Performance Monitor counter registry failed"

Workaround:

Registry navigates to/local_machine/software/microsoft/windows Nt/currentversion/perflib, two values last counter and last Help is changed to the maximum value of the key value in the 004 (English system 009) directory.

Question 3:

Phenomenon: Other versions of the SQL2005 database have replicated the database to SQL dev through replication, export, backup, and so on, the following error occurs in the right-key table, new table, and so on:

The category does not support collections (or category objects are remote objects) (Exceptions from hresult:0x80040110 (class_e_noaggregation)) (Microsoft.SqlServer.SqlTools.VSIntegration)

Analysis: May be a bug in SQL Server 2005, or it may be a change in the. NET Framework, such as installing a different version of SQL Server 2005.

Workaround:

After verification, this operation first uninstall SQL Dev (on the net is to uninstall the client, the author is to delete all SQL Server 2005), and then reload/repair the. NET 2.0 Framework, and then reload SQL Dev, solve the problem.

Question 4:

Symptom: vs2005 The GridView cannot delete the varchar type field in SQL2005, hint--"exception details: System.Data.SqlClient.SqlException: Data type ntext and nvarchar Incompatible in the equal to operator. ”

Workaround:

SqlDataSource when the connection can not choose concurrency control, it is possible to edit and delete, otherwise, even if not the error, also cannot operate.

Note: In the process of installing SQL Server 2005, you need to turn off software such as registry monitoring software and virus protection.