With Restore The Database

[scrip]

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

[MentaL]

[noamke]

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

[scrip]

now this error pop up

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 ?

[stealhtfire]

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

[Trilest]

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 ;)