Error Message: The RPC server is unavailable during SQL Setup

Question: I have received a server from the server build team and I've started a Server set up. During the set up process , I'm getting an error message Error Message :The RPC server is unavailable How cam I fix this issue? Answer: I have seen this problem in a few situations. Typically it arises when I'm using a Domain account as a service set up account. For example - I may have a service account as a member of the MYDOMAIN domain. If the server cannot connect to a valid DNS server , where the sql server service account... Read more →

String or binary data would be truncated

What is string or binary data would be truncated The statement has been terminated? Read more →

How to capture query errors using SQL Server Extended Events

If you're troubleshooting SQL Server query errors , you'll already know Extended Events are highly useful and very effective method to capture SQL Server errors. To use the script you'll need appropriate privileges to create the Extended Event. You will also need to have some space available on the disk to store output files. I usually place them in the C:\tmp - although be careful just in case you fill the C:\ drive! The alternative is to use another drive. CREATE EVENT SESSION [CaptureErrors] ON SERVER ADD EVENT sqlserver.error_reported( ACTION(sqlserver.client_hostname,sqlserver.database_id,sqlserver.nt_username, sqlserver.sql_text,sqlserver.tsql_stack,sqlserver.username) WHERE ([severity]>=(10))) ADD TARGET package0.event_file(SET filename=N'C:\tmp\CaptureErrors.xel',metadatafile=N'C:\tmp\CaptureErrors.xem') WITH (MAX_MEMORY=4096 KB,EVENT_RETENTION_MODE=ALLOW_SINGLE_EVENT_LOSS,MAX_DISPATCH_LATENCY=1... Read more →

How to troubleshoot SPN and SQL Server Windows return code: 0x2098, state: 15

Question:I see this error in the SQL Server Error Logs . How can I troubleshoot this issue? The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/myserver.net:50234 ] for the SQL Server service.Windows return code: 0x2098, state: 15. The start up account for SQL Server is a dedicated start up account Answer: As a starting point let's look at what MSDN has to say " To use Kerberos authentication with SQL Server requires both the following conditions to be true: The client and server computers must be part of the same Windows domain, or... Read more →

How to troubleshoot Alter Database Failed SQLSTATE 42000 Error 3023

Question: I received an alert for a regular backup failure . A closer inspection of the sql server agent error logs displayed this error message: Executed as user: myUser. Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized. Reissue the statement after the current backup or file manipulation operation is completed. [SQLSTATE 42000] (Error 3023) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). Answer: There are different reasons this error message is generated. The error message says that "ALTER DATABASE ADD FILE and encryption changes must be serialized". This... Read more →