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.