With Restore The Database

i want restore on my vps a db and then all the time this pop ups ...

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

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

------------------------------
ADDITIONAL INFORMATION:

The backup device 'C: \ GunzDB.bak' can not be opened. Operating system error 5 (Access is denied.).
RESTORE HEADERONLY failure, is completed. (Microsoft SQL Server, Error: 3201)

For help, click: http://go.microsoft.com/fwlink?ProdN...1&LinkId=20476

------------------------------
BUTTONS:

Ok

Are you trying to open it as a .bak file?
if so make a back up of the file and then change it to GunzDB.sql

now this error pop up

Code:

---

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'CT33344 \ SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

System.Data.SqlClient.SqlError: Error on directory browsing for the file "C: \ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ DATA \ GunzDB.mdf. Operating system error 3 (The system can not find the path specified.). (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&LinkId=20476

------------------------------
BUTTONS:

Ok

---

---------- Post added at 11:25 PM ---------- Previous post was at 11:19 PM ----------

do i need something ? to can resoter ?

renaming the .bak to .sql wont do anything lol
i restored a database backup with a .bak before ... and renaming it isnt the answer for sure lol

it seems to me you need a password, the same that was set on the database as it was before, its needed to restore the backup

Open your SQL Server Configuration Manager. Right click SQL Server (SQLEXPRESS) and choose properties. You have to change that mode, but unfortunately for you I forgot what mode used to work. Good luck ;)