Blog Archives

How to overwrite SQL Server Backup rather than Append Mediaset

T SQL Date format convert function

In this post I will show you how to overwrite sql server backup file rather than append (default action is append to backup media set) If you try below t-sql command to take full sql server database backup then you

Tagged with: , ,
Posted in DBA, SQL Server, T-SQL Tips

How to login to sql server after all admin accounts removed and you are locked

T SQL Date format convert function

Recently I had an interesting situation. Consider below situation You want to connect to sql server as sysadmin but you are not added to sql server logins using windows authentication BUILTIN\Administrators group has been removed from SQL Server You have

Tagged with: ,
Posted in DBA, SQL Server

SSAS Cube Deploy/Processing Error – OLE DB or ODBC error: Login failed for user ‘[MyServer1\user1$]’.; 28000

ssas-analysis-service

I was trying to deploy my AdventureWorksDW2012 Cube Sample  and got interesting error as below OLE DB error: OLE DB or ODBC error: Login failed for user ‘MYDOMAIN\MYSERVER$’.; 28000 If you receive above error most likely your SSAS Instance running

Tagged with: , ,
Posted in Business Intelligence, DBA, SSAS