Sql Error

[Drago88]

I need help on ecuting the a sql file from Gunz ServerFiles Rev 5 (Which can be found here http://forum.ragezone.com/showthread.php?t=300485 )

For some reason when i try to execute the sql file called "Database_GunzDB.sql" i get these errors.

Msg 15007, Level 16, State 1, Line 2
'game' is not a valid login or you do not have permission.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_adduserobject_vcs'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_setpropertybyid'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_setpropertybyid'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_setpropertybyid'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_setpropertybyid'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_setpropertybyid'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dt_addtosourcecontrol' depends on the missing object 'dbo.dt_displayoaerror'. The module will still be created; however, it cannot run successfully until the object exists.

 

[wesman2232]

just ignore it, everything will still run.
Or you can just delete your DB create again and restore with the GunzDB.bak

 

[Drago88]

What are the steps to resotre it with the GunzDB.bak ?

 

[wesman2232]

Create GunzDB - right click it - Tasks - Restore.
Then you direct it to the GunzDB.bak

 

[Drago88]

I get this error

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

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

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

Cannot open backup device 'C:\Database\GunzDB.bak'. Operating system error 5(Access is denied.).
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3201)

For help, click:

To view the content, you need to sign in or register

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

OK
------------------------------

 

[wesman2232]

Go to the link and review what it says. Its probably that your login dosnt have permission to restore.

 

[Drago88]

i'm logged in as sa

 

[wesman2232]

I dont know then, you could have just ignored it and went on, everything should still work.

 

[Drago88]

ok , also dto.Accounts i don't have a Password field u can run the sql and see if its just me.

 

[Solaire]

Store it on C:/Program Files/Microsoft SQL Server/MSSQL 1.1/Backup (might miss a folder).

dbo.Login FTW ?

 

[Drago88]

what does FTW mean ? i have a password field in login if thats what your asking and i'll try that folder

 

[wesman2232]

For The Win

 

[Drago88]

WOO i was able to resotre the database. the tutorial said u had to make a account in dbo.accout but i guess u have to do it in Login now. thanks for all your help ^^

 

[Solaire]

Yes, and look if the AID and UserID are the same.