Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS)

[Ultraporing]

First a warning this management studio is in german, i tryed with paint to show you where to click.
The database scripts shown are from GigaToni's FAQ.

I've removed the user creation in the scripts and reuploaded them because we create our own user.
Download and unzip them: https://www.dropbox.com/s/yl5439kc8t1n3wi/Databases.rar

The pictures show the creation of the warz db, but you should first create the breezenet db with those steps, or you get a warning which can be ignored.


Step 0, set your server to SQL Authentication!:

First rightclick your server, then hit Properties.
Then select Security, and check SQL Authentication!
Hit OK.

http://i.imgur.com/U4Gzz3L.jpg

Step 1, Creating the Database:

Right Click the databases dropdown object and select new database.

,


Step 2, naming the DB:

Enter the name BreezeNet and click OK.
(for the warz, name it WarZ)




Step 3, opening the provided script:

Hit File->Open->File, or click the Button looking like a open folder.
Then navigate to your downloaded and unzipped script location and select breezenet.sql.
Hit Open.
(for the warz DB, open warz.sql)




Step 4, executing the script:

Hit execute.




Step 5, success!

Repeate Steps 1-5 for warz DB.




Step 6, user creation:

select in the dropdown: Security->Logins. And rightclick at logins, then click new login.

http://i.imgur.com/wIlwKbw.jpg


Step 7, names and passwords:

enter a username then click SQL Authentication and enter a password.
Click "user assignment" in quotes because i dont know the name.

http://i.imgur.com/veu9Nlm.jpg


Step 8, assigning users:

Mark the checkboxes next to your 2 new databases (WarZ, breezenet). Then click one of them so its highlighted. Check all boxes as shown in Red Box 2.
Highlight your other database by clicking on it and set there all user rolls too.
now click OK.

http://i.imgur.com/RulRqkL.jpg


CONGRATS! You are set up and ready to use your new databases!

[MentaL]

[Aku_ya_aku]

not yet i think, need the ODBC..

[LayZ Gamer]

Is the following normal for breezenet? Got some similar errors in the warz table.

Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'WOAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'BNAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.

warZ database

Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.

[Ultraporing]

Is the following normal for breezenet? Got some similar errors in the warz table.


warZ database

when do they happen?

[LayZ Gamer]

when do they happen?

When clicking execute

[Ultraporing]

When clicking execute

you execute it on a empty db? It worked for me, im wondering right now why it says you dont have permissions.

Ive just read you need to create logins for those users.
Or remove the respective lines from the script

[LayZ Gamer]

you execute it on a empty db? It worked for me, im wondering right now why it says you dont have permissions.

Yep empty, tried removing sql completely reinstalled at least 5 times and I get same thing.

[Ultraporing]

Try removing lines 3-17 in breezenet script.
And lines 3-17 in warz script

we create our own db user so they shouldnt be needed.

[LayZ Gamer]

Just this now on warZ

The module 'WZ_ACCOUNT_APPLYKEY' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialGetInfo'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_APPLYKEY' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialSetCustomerID'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_CREATE' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialGetInfo'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_CREATE' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialSetCustomerID'. The module will still be created; however, it cannot run successfully until the object exists.

It all went through okay, so I assume it is fine?

[Ultraporing]

Just this now on warZ



It all went through okay, so I assume it is fine?

did you first run the breezenet script or the warz script?
I think he is only bitching because of the order you've used the scripts.

[LayZ Gamer]

did you first run the breezenet script or the warz script?

warZ script

[Ultraporing]

warZ script

yeah than its the order i change it in the tutorial. but your db should be ok :)

[LayZ Gamer]

yeah than its the order i change it in the tutorial. but your db should be ok :)

Lol thank you, now off to figure out this damn iis stuff. Lol my head is spinning from confusion.

[allmymind]

Nicely done Ultraporing!

[Kevin Doos]

Thaanks uu