Common Errors and causes of JSP database connection Learning

I. Error 233,

A connection has been established with the server, but an error occurs during logon. (Provider: named pipeline provider, error: 0-there is no process on the other end of the pipeline .) (Microsoft SQL Server, error: 233)

   1. Open "Microsoft SQL Server 2005 -- Configuration tool -- SQL Server Configuration Manager"
   2. "sqlserver 2005 network configuration" -- "MSSQLServer protocol" -- enable "TCP/IP" and "namedpipes ". after starting the TCP/IP protocol, you must change the TCP port number in its properties to 1433 (dynamic port) or the desired port number.   
  3. Restart "SQL Server"

Ii. Error 18452

   1. In Enterprise Manager, select the server (for example, llq \ sqlexpress) and right-click and select "properties"  
    2. Select the "Security" tab. Under "Server Authentication", select "sqlserver and Windows Authentication Mode"
   3. OK and restart the sqlserver Service

Iii. Error 18470

    1. log on with "Windows Authentication"
   2. Extend to "security -- login name -- Right-click sa -- switch to" status "-- enable Logon ".

Additional: Modify the logon password of the system administrator SA.

    1. Open the Enterprise Manager
    2. "security" -- "login" -- Right-click "sa"

Iv. Error 5123

   Cause 1: as a result of database file operation permissions, add an Everyone user, Grant "control permissions", and re-attach the database, and the operation will be successful.

  Cause 2: this error occurs if multiple NICs exist in the computer running on a single network segment and you use the netbeui network protocol. When netbeui Protocol tries to register the same computer name in the computer on each network card. This error occurs when netbeui attempts to register the second card on the network with the same name as the first card.

Supplement:

Error:

Microsoft SQL Server Logon
Connection Failed:
Sqlstate: '20140901'
SQL Server Error 18452
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'admin' Logon Failed. This user is not associated with a trusted SQL server connection.

Http://www.cnblogs.com/sjrhero/articles/1814442.html

Http://jingyan.baidu.com/article/f25ef25433bccf482c1b82b9.html

Error

---------------------------
Microsoft SQL Server Logon
---------------------------
Connection Failed:
Sqlstate: '20140901'
SQL Server Error: 53
[Microsoft] [odbc SQL Server Driver] [dbnetlib] connectionopen (connect ()).
Connection Failed:
Sqlstate: '20140901'
SQL Server Error: 17
[Microsoft] [odbc SQL Server Driver] [dbnetlib] SQL server does not exist or access is denied

Http://www.baidu.com? Ie = UTF-8 & BS = sqlstate % 3A + % 2728000% 27 & F = 8 & rsv_bp = 1 & WD = SQL + SERVER + % E9 % 94% E8 % af % 3A + 18452 & rsv_n = 2 & rsv_sug3 = 1 & rsv_sug1 = 1 & rsv_sug4 = 47 & inputt = 39078

Http://wenku.baidu.com/view/ff191749f7ec4afe04a1dfe6.html

JDBC-ODBC bridge connection failed