SQL Server prompts "column prefix tempdb. invalid: no table name is specified". Solution: sqlservertempdb

SQL Server prompts "column prefix tempdb. invalid: no table name is specified". Solution: sqlservertempdb

When querying creden、 and audit creden、, the error message "column prefix tempdb. invalid: Table name not specified" appears. How can this problem be solved?

Cause: Because SQL2000 cannot recognize special characters such as "-", and Chinese characters in the computer name, it can only use English letters and numbers.

Solution: Right-click "computer name" in "properties" of my computer and change it to English only (preferably within 8 characters). Remember that the computer name cannot contain ","-"or other characters. You can solve the problem.

After this problem is resolved, the problem arises: when a user is registered in UFIDA system management, "You cannot establish a connection to the data server pointed to by the Application Server [POWERPC] and cannot log on, select another server. error Description: (-2147467259) [DBNETLIB] [ConnectionOpen (Connect ().] SQL Server does not exist or access is denied. "error. later, I found that these errors only need to change the server name in the UFIDA service to the current computer name.

In the user's account set, the column prefix tempdb is invalid. Why is the table name not specified?

Modify the computer name. Naming rules: all uppercase letters or less are allowed.

The Credential cannot be reviewed by UFIDA t3. The error message "the column prefix tempdb is invalid: The table name is not specified ."

1. Your computer name may contain invalid characters. Solution: Check whether the computer name and login username include the operating system and software login username contains illegal and special characters, such as "-", "_", and "%. Do not include invalid or special characters in the computer name or user name. It is best to use a combination of letters.
2. SQL database is not installed. Solution: reinstall SQL SERVER.