+ Post New Thread
Results 1 to 7 of 7
How do you do....it? Thread, Liberum and sql 2008 in Technical; How do you initialize the HelpDesk database with the 'helpdesk.sql' using sql 2008? not used this for a few years ...
  1. #1
    markcuk's Avatar
    Join Date
    Sep 2005
    Posts
    586
    Thank Post
    29
    Thanked 60 Times in 55 Posts
    Rep Power
    38

    Liberum and sql 2008

    How do you initialize the HelpDesk database with the 'helpdesk.sql' using sql 2008?

    not used this for a few years and I used access database last time but ii7 does not support it unless i use it in 32bit mode

    cheers

    mark

  2. #2

    Join Date
    Nov 2010
    Location
    California
    Posts
    137
    Thank Post
    0
    Thanked 24 Times in 22 Posts
    Rep Power
    12
    Quote Originally Posted by markcuk View Post
    How do you initialize the HelpDesk database with the 'helpdesk.sql' using sql 2008?

    not used this for a few years and I used access database last time but ii7 does not support it unless i use it in 32bit mode

    cheers

    mark
    Using Liberum Help Desk with SQL Server Management Studio Express - Liberum Help Desk This should be able to help you. Looks like there should be a .sql file with the query to create the DB. The instructions mention sql express but you can open it the same way in Management Studio for any other 2005/2008 version. Express just has less features.

  3. #3

    Join Date
    Nov 2010
    Location
    California
    Posts
    137
    Thank Post
    0
    Thanked 24 Times in 22 Posts
    Rep Power
    12
    This might help also: http://liberum.robatkinson.net/liber...1p2Lhh5UVrE%3D Not sure what you need help with.

  4. #4
    markcuk's Avatar
    Join Date
    Sep 2005
    Posts
    586
    Thank Post
    29
    Thanked 60 Times in 55 Posts
    Rep Power
    38
    When i run the sql file in Management Studio I just get errors like

    Msg 1801, Level 16, State 3, Line 2
    Database 'HelpDesk' already exists.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 33003, Level 16, State 1, Line 2
    DDL statement is not allowed.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.categories" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.departments" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.priority" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.problems" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.status" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.tblConfig_Auth" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.tblConfig_Email" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.tblEmailMsg" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.tblUsers" because it does not exist or you do not have permissions.
    Msg 4902, Level 16, State 1, Line 2
    Cannot find the object "dbo.tblUsers" because it does not exist or you do not have permissions.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblconfig'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblConfig_Auth'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblConfig_Email'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblEmailMsg'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblUsers'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'db_keys'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'status'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'priority'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'departments'.
    Msg 208, Level 16, State 1, Line 2
    Invalid object name 'tblLanguage'.

    help?

  5. #5
    markcuk's Avatar
    Join Date
    Sep 2005
    Posts
    586
    Thank Post
    29
    Thanked 60 Times in 55 Posts
    Rep Power
    38
    okay i can now access the update database part but it fails with error Invalid object name 'tblConfig'.

    I still need to do something with helpdesk.sql file but cannot get it to run the script without errors

  6. #6

    Join Date
    Nov 2010
    Location
    California
    Posts
    137
    Thank Post
    0
    Thanked 24 Times in 22 Posts
    Rep Power
    12
    Quote Originally Posted by markcuk View Post
    okay i can now access the update database part but it fails with error Invalid object name 'tblConfig'.

    I still need to do something with helpdesk.sql file but cannot get it to run the script without errors
    It looks like you already have a DB with that name. You can open the .sql file in Notepad (I recommend notepad ++ ) or straight into management studio and edit it there. I recommend reading their installation instructions that Liberum has available.

  7. #7

    Join Date
    Apr 2006
    Posts
    388
    Thank Post
    23
    Thanked 95 Times in 61 Posts
    Rep Power
    44
    Quote Originally Posted by markcuk View Post
    When i run the sql file in Management Studio I just get errors like

    Msg 1801, Level 16, State 3, Line 2
    Database 'HelpDesk' already exists.
    So, as qcomer says, this means that the database already exists. Often you will find that running a script twice will break something (e.g. insert duplicate system data or lookup data into some table), so in general if the script doesn't work first time out, instead of re-running it's safer to roll back to your previous state. In this case it looks like you can delete the 'helpdesk' database you've just created and try again.

    The 'invalid object name' and 'DDL' stuff makes me wonder if you're inadvertantly running the script this subsequent time against the wrong database - have a look at the dropdown that's underneath 'New Query' and to the left of "!Execute" - that's the database your current query window is going to run stuff in.

    In any case, I'd say: drop the database and try running the script again, once only. If it fails, post the errors up here.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 23
    Last Post: 12th October 2010, 02:59 PM
  2. [SIMS] Summer Release and SQL 2008 Upgrade
    By enjay in forum MIS Systems
    Replies: 12
    Last Post: 17th August 2010, 12:23 PM
  3. Move to SQL 2008 and backups
    By thesthelensman in forum MIS Systems
    Replies: 2
    Last Post: 13th April 2010, 02:16 PM
  4. Backup Exec 10d and MS SQL 2008
    By Duke in forum Windows
    Replies: 4
    Last Post: 12th April 2010, 10:21 AM
  5. CMIS and SQL 2008 install
    By sgavan in forum MIS Systems
    Replies: 2
    Last Post: 9th July 2009, 02:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •