+ Post New Thread
Page 24 of 83 FirstFirst ... 142021222324252627283474 ... LastLast
Results 346 to 360 of 1233
Scripts Thread, FITS Compliant Web Based Helpdesk - ** RELEASED ** in Coding and Web Development; Named pipes and TCP/IP are enabled and the browser service is running....
  1. #346
    badders's Avatar
    Join Date
    Apr 2007
    Location
    Cumbria
    Posts
    170
    Thank Post
    44
    Thanked 11 Times in 10 Posts
    Rep Power
    21
    Named pipes and TCP/IP are enabled and the browser service is running.

  2. #347
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by badders View Post
    Named pipes and TCP/IP are enabled and the browser service is running.
    Is there a firewall running on this Server?

  3. #348
    badders's Avatar
    Join Date
    Apr 2007
    Location
    Cumbria
    Posts
    170
    Thank Post
    44
    Thanked 11 Times in 10 Posts
    Rep Power
    21
    The firewall on the server is turned off, as is the firewall on the client PC.

  4. #349
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by badders View Post
    The firewall on the server is turned off, as is the firewall on the client PC.
    Well your SQL server is not happy talking with other applications, any chance of remote access to figure this out for you?

    PM me with your email if this is an option.

  5. #350
    joe90bass's Avatar
    Join Date
    Oct 2007
    Location
    S Wales
    Posts
    1,349
    Thank Post
    322
    Thanked 107 Times in 96 Posts
    Rep Power
    50
    Many thanks for the E-Mail poller KB. It's working now.

    Still have a few issues though - sorry!

    The support e-mail group is getting SLA breach e-mails, but not info on when jobs are received via e-mail or jobs closed.
    Users are also not getting an acknowledgement of their e-mail request being received or their incident closed as used to happen in MLH.
    The web config file looks all okay to me, but I must have missed something!

    Cheers

  6. #351
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by joe90bass View Post
    Many thanks for the E-Mail poller KB. It's working now.

    Still have a few issues though - sorry!

    The support e-mail group is getting SLA breach e-mails, but not info on when jobs are received via e-mail or jobs closed.
    Users are also not getting an acknowledgement of their e-mail request being received or their incident closed as used to happen in MLH.
    The web config file looks all okay to me, but I must have missed something!

    Cheers
    If you can email me your web.config or save it as a text file and upload it to a helpdesk request I will take a look at it, remember to remove any sensative info from it first.

  7. #352
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    595
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    I'm trying to attach the converted MLH database but am getting the error:
    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------

    Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

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

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

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

    ------------------------------

    D:\Temp\MYDATABASEFILE.mdf is not a primary database file. (Microsoft SQL Server, Error: 5171)

    For help, click: Source: MSSQLServer ID: 5171 (SQL Server 09.00.4035) - Events And Errors Message Center: Message Details
    I'm stumped. Anyone any ideas?

    Also I've setup a parallel fresh install to test out which is pretty much there but won't accept the default admin credentials as provided in the install documentation. Did anyone else have this problem?

  8. #353
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by randle View Post
    I'm trying to attach the converted MLH database but am getting the error:

    I'm stumped. Anyone any ideas?

    Also I've setup a parallel fresh install to test out which is pretty much there but won't accept the default admin credentials as provided in the install documentation. Did anyone else have this problem?
    The .mdf file you are trying to attach is this the backup file that was emailed to you renamed as MYDATABASEFILE.mdf?

    As far as the fresh install not accepting login credentials make sure that you have helpdesk_authentication in the web.config file set to SQL.

  9. #354
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    595
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    That's the one. I renamed it to OPSD.mdf and attempted to attach which then gave me the above error.

    Cheers. I can now get into the helpdesk as admin.

  10. #355
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by randle View Post
    That's the one. I renamed it to OPSD.mdf and attempted to attach which then gave me the above error.
    Ah Ok , then that file is a backup is a backup file that needs to be restored over and exisiting database, the easiest thing to do is to create an empty database and restore the data.

  11. #356
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    595
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Ok I've created an empty database and attempted a restore pointing to the .bak file you sent over but then get the 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:

    The media family on device 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\chelmer_valley_helpdes k_converted.bak' is incorrectly formed. SQL Server cannot process this media family.
    RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3241)

  12. #357
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by randle View Post
    Ok I've created an empty database and attempted a restore pointing to the .bak file you sent over but then get the error
    When doing the restore did you tell it to force the restore under the options tab on the left, you need to do this as you are replacing the whole database.

  13. #358
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    595
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    The above message appears when simply selecting the bak file as the source. It won't let me browse the options until a source is selected.

  14. #359
    randle's Avatar
    Join Date
    Dec 2006
    Location
    Chelmsford, Essex
    Posts
    595
    Thank Post
    66
    Thanked 16 Times in 15 Posts
    Rep Power
    19
    Any ideas? If you still have the file can you restore from it ok?

  15. #360
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by randle View Post
    Any ideas? If you still have the file can you restore from it ok?
    I will try it this evening for you.

SHARE:
+ Post New Thread

Similar Threads

  1. Framework for ICT Technical Support (FITS)
    By FITS in forum School ICT Policies
    Replies: 32
    Last Post: 3rd March 2009, 09:38 AM
  2. very very urgent: FITS Your Experiences
    By russdev in forum General EduGeek News/Announcements
    Replies: 16
    Last Post: 23rd October 2007, 11:21 PM
  3. Is your school website DDA compliant?
    By bishopsgarthstockton in forum Web Development
    Replies: 5
    Last Post: 10th July 2007, 03:34 PM
  4. dda compliant website
    By Uraken in forum Web Development
    Replies: 5
    Last Post: 8th June 2007, 09:23 AM
  5. PHP based Helpdesk with IMAP or POP3 authentication?
    By wesleyw in forum How do you do....it?
    Replies: 5
    Last Post: 18th October 2006, 01:08 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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