Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection. you are getting this error because you have windows authenication enabled for login within your sql instance . to login with mixed mode authenication you must enable the mixed mode within the registry. HKLM/SOFTWARE/MICROSOFT/MICROSOFT SQL SERVER/MSSQL/MSSQLSERVER/LOGINMODE right click and
SQL Backup Process 1) Log into the Server using SQL Management Studio 2) Click the + sign next to databases to expand the list 3) locate the database and right click it. On the menu list select Tasks > Backups 4) Under Destination , take note of the existing destination. If ou wish to change
Error: failed with the following error: “The backup of full-text catalog ‘sampledb’ is not permitted because it is not online. Check errorlog file for the reason that full-text catalog became offline and bring it online. Or BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online
Error: Can not create worker thread Check the Server load and restart the SQL engine
Error: Cannot drop the user ‘dbo’. (Microsoft SQL Server, Error: 15150) Problem: trying to unmapped a user to a database , you may receive the above error message. This is because the dbo user is assigned the login of the user you are trying to remove. You will need to run the following query to
