As shown below:
Error Type:
Microsoft ole db Provider for ODBC Drivers (0x80040E4D)
[Microsoft] [odbc SQL Server Driver] [SQL Server] user 'daa5dda31197484 \ iusr_daa5dda31197484' login failed.
/Myasp/111.asp, 8th rows
My SQL Server database connection code
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server. CreateObject ("ADODB. Recordset ")
Recordset1.ActiveConnection = MM_yuangongid_STRING
Recordset1.Source = "SELECT * FROM dbo. main order by id ASC"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open ()
Recordset1_numRows = 0
%>
Conn. asp
<%
'Filename= "Connection_odbc_conn_dsn.htm"
'Type = "ADO"
'Designtimetype = "ADO"
'Http = "false"
'Catalog = ""
'Schema = ""
Dim MM_yuangongid_STRING
MM_yuangongid_STRING = "dsn = yuangong ;"
%>
Recordset1.ActiveConnection = MM_yuangongid_STRING is the execution site connecting to the database,
The system prompts that the database connection failed. The user 'daa5dda31197484 \ iusr_daa5dda31197484' failed to log on.
Check whether the user name and password are correct.
Also, check whether mssql is installed.