Receive / reset password from MS SQL.BAK file?

We have a client who wants us to retrieve data from our MS SQL database file. I went to restore it, but I just get:

TITLE: Microsoft SQL Server Management Studio Express

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)


ADDITIONAL INFORMATION:

Access denied due to a password failure. RESTORE FILELIST is abnormally interrupted. (Microsoft SQL Server, Error: 3279)

For help, click http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.4053&EvtSrc=MSSQLServer&EvtID=3279&LinkId=20476


BUTTONS:

Ok

The password itself seems to be set by the original software provider, so the client does not have one.

reset ?

+3
2

SA ? , . :

RESTORE DATABASE Northwind FROM DISK='C:\yourbackup.BAK' WITH MEDIAPASSWORD='thepassword'
+2

.

-1

Source: https://habr.com/ru/post/1755992/


All Articles