Kashif Nizam Qureshi


Leave a comment

BACKUP DATABASE

Use the following script to backup database. Option INIT force the backup to overwrite, else use NOINIT to append.

BACKUP DATABASE [ZADCO-Projects_ProjectWebApp]
TO  DISK = N’D:\Database Backups\ZADCO-Projects_ProjectWebApp.bak’  with INIT

Advertisements


2 Comments

The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service

Alright, the other day I was installing SQL Server 2008 R2 (same problem occurred in 2008 as well), when I reached the point Server Configuration and supplied Service Account’s account name and password, I encountered the following errors for both SQL Server and Agent service.

  • The credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service
  • The specified credentials for the SQL Server service are not valid. To continue, provide a valid account and password for the SQL Server service

I tried all the solutions available and none worked for me. For instance, changing the password to complex etc.

Solution:

The problem was, the machine on which I was installing SQL Server was joined to the root domain (xxx.gov) and the user accounts I was using to install SQL Server was created on sub.xxx.gov. I don’t know what can be done to use those accounts but soon after creating an account on the root with the same permission, eureka! it worked flawlessly.

 


Leave a comment

String or binary data would be truncated

Had this error today (ie; the day I posted this), on googling found that when inserting data which is more than the length of allowed character would through this error. But in my case, this wasn’t the issue so thought of sharing this with others. I was trying to update one nvarchar field record through management studio which had 250 character length and I was updated a record which had hardly 20 characters but was throwing this error ‘String or binary data would be truncated’ . So I update the record with Update query and voila! it worked 🙂 Hope this would help someone out there!