Wishlist 0 ¥0.00

Cant add new elements, I get "Unknown column 'introtext' in 'field list' SQL=UPDATE"

  1. fstltna

    fstltna New Member

    Level: Community
    I have tried both 3.0.9 and 3.1 on my Joomla 2.5 site and I get the same error when I try and add or update a element/ I get this error:
    Code (Text):

    Unknown column 'introtext' in 'field list' SQL=UPDATE
    See attached file for the complete details. Can someone help me with this?

    Screen Shot 2014-07-27 at 12.39.13 AM.png
     
    fstltna, Jul 27, 2014
    #1
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Totally strange (there's no "introtext" element in the element table).
    Is this a fresh Joomla/Fabrik installation or did you migrate/copy/whatever something?
    Check your Fabrik connection, clear all Joomla and browser cache.
     
    troester, Jul 27, 2014
    #2
     
  3. fstltna

    fstltna New Member

    Level: Community
    I have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?
     
    fstltna, Jul 28, 2014
    #3
     
  4. Makulia

    Makulia Member

    Level: Community
    Hey, fstltna! I have faced the same problem. Investigating issue for now.
    It seems like typo mistake somewhere in the code (missing ') but where?

    Let as look through the code. In the end of the query we can see
    \"show_icon\":[\"0\"]}}',`introtext`='' WHERE

    It is obvious, that the last element of the the query ('introtext') is incomplete and therefor we got an sql error.

    But I don't know where this query is generating.
     
    Makulia, Jul 30, 2014
    #4
     
  5. Makulia

    Makulia Member

    Level: Community
    I have done all of this with latest github update and Joomla 3.3.3 and had no lack.
    How introtext could get int this query?
     
    Makulia, Jul 30, 2014
    #5
     
  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    So @fstitna is getting this on J!2.5 with F3.0 and 3.1?
    and Makulia on J!3.3.3 + F3.1 + GitHub?
    I can't replicate.

    This error is while trying to save a new or existing element?
    Any element plugin? or a special one?
    With validation(s)....?
    Any Joomla cache settings? JS compression components/plugins...?
     
    troester, Jul 30, 2014
    #6
     
  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    Can you please post the complete error messages, maybe this will give a hint.
     
    troester, Jul 30, 2014
    #7
     
  8. Makulia

    Makulia Member

    Level: Community
    Could it be connected with latest Joomla update?

    Yes, my platform is: J.3.3.3+latest fabrik.
    Fabrik and Joomla debug is off. Gzip compression is off.

    It happens when I try to:
    1) Create a new element
    2) Save any existing element (with or without modification)
    3) Unlink one element from another
    4) Save any form settings. (Saving list settings is ok)

    This is the error message (without code tags because they strip some '):

    Unknown column 'introtext' in 'field list' SQL=UPDATE `ronb4_fabrik_elements` SET `name`='name',`group_id`='11',`plugin`='field',`label`='???',`checked_out`='1',`checked_out_time`='2014-07-30 19:03:23',`created`='2012-12-03 09:34:38',`created_by`='966',`created_by_alias`='kadisadm',`modified`='2014-07-30 19:03:30',`modified_by`='1',`width`='40',`height`='0',`default`='',`hidden`='0',`eval`='0',`ordering`='5',`show_in_list_summary`='1',`filter_type`='',`filter_exact_match`='1',`published`='1',`link_to_detail`='0',`primary_key`='0',`auto_increment`='0',`access`='1',`use_in_page_title`='0',`parent_id`='0',`params`='{\"placeholder\":\"\",\"password\":\"0\",\"maxlength\":\"255\",\"disable\":\"0\",\"readonly\":\"0\",\"autocomplete\":\"1\",\"speech\":\"0\",\"bootstrap_class\":\"input-large\",\"text_format\":\"text\",\"integer_length\":\"6\",\"decimal_length\":\"2\",\"field_use_number_format\":\"0\",\"field_thousand_sep\":\",\",\"field_decimal_sep\":\".\",\"text_format_string\":\"\",\"text_input_mask\":\"\",\"render_as_qrcode\":\"0\",\"guess_linktype\":\"0\",\"link_target_options\":\"default\",\"rel\":\"\",\"link_title\":\"\",\"show_in_rss_feed\":\"0\",\"show_label_in_rss_feed\":\"0\",\"use_as_rss_enclosure\":\"0\",\"rollover\":\"\\u041f\\u043e\\u0436\\u0430\\u043b\\u0443\\u0439\\u0441\\u0442\\u0430, \\u0443\\u043a\\u0430\\u0436\\u0438\\u0442\\u0435 \\u0441\\u0432\\u043e\\u0435 \\u0424\\u0418\\u041e!\\r\\n\\r\\n\\u0424\\u043e\\u0440\\u043c\\u0430\\u0442: \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432 \\u0418\\u0432\\u0430\\u043d \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432\\u0438\\u0447.\\r\\n\\r\\n\\u0414\\u043e\\u043f\\u0443\\u0441\\u0442\\u0438\\u043c\\u044b \\u0442\\u043e\\u043b\\u044c\\u043a\\u043e \\u0440\\u0443\\u0441\\u0441\\u043a\\u0438\\u0435 \\u0431\\u0443\\u043a\\u0432\\u044b.\",\"tipseval\":\"0\",\"tiplocation\":\"top\",\"labelindetails\":\"1\",\"labelinlist\":\"0\",\"comment\":\"\",\"edit_access\":\"1\",\"view_access\":\"1\",\"view_access_user\":\"\",\"list_view_access\":\"1\",\"encrypt\":\"0\",\"can_order\":\"1\",\"alt_list_heading\":\"\\u0424\\u0418\\u041e\",\"custom_link\":\"\",\"custom_link_indetails\":\"1\",\"use_as_row_class\":\"0\",\"include_in_list_query\":\"1\",\"always_render\":\"0\",\"icon_folder\":\"0\",\"icon_hovertext\":\"1\",\"icon_file\":\"\",\"filter_length\":\"20\",\"filter_access\":\"1\",\"full_words_only\":\"0\",\"filter_required\":\"0\",\"filter_build_method\":\"0\",\"filter_groupby\":\"text\",\"inc_in_adv_search\":\"1\",\"filter_class\":\"input-medium\",\"filter_responsive_class\":\"\",\"tablecss_header_class\":\"\",\"tablecss_header\":\"\",\"tablecss_cell_class\":\"\",\"tablecss_cell\":\"width:10px;\",\"sum_on\":\"0\",\"sum_label\":\"Sum\",\"sum_access\":\"5\",\"sum_split\":\"\",\"avg_on\":\"0\",\"avg_label\":\"Average\",\"avg_access\":\"5\",\"avg_round\":\"0\",\"avg_split\":\"\",\"median_on\":\"0\",\"median_label\":\"Median\",\"median_access\":\"5\",\"median_split\":\"\",\"count_on\":\"0\",\"count_label\":\"Count\",\"count_condition\":\"\",\"count_access\":\"5\",\"count_split\":\"\",\"custom_calc_on\":\"0\",\"custom_calc_label\":\"Custom\",\"custom_calc_query\":\"\",\"custom_calc_access\":\"5\",\"custom_calc_split\":\"\",\"custom_calc_php\":\"\",\"regex-message\":[\"\\u0412\\u0435\\u0434\\u0435\\u043d\\u043d\\u043e\\u0435 \\u0424\\u0418\\u041e \\u043d\\u0435 \\u0441\\u043e\\u043e\\u0442\\u0432\\u0435\\u0442\\u0441\\u0432\\u0443\\u0435\\u0442 \\u0444\\u043e\\u043c\\u0430\\u0440\\u0442\\u0443!\"],\"regex-validation_condition\":[\"\"],\"regex-expression\":[\"\\/^([\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}|[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\-[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,})\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}$\\/u\"],\"regex-match\":[\"1\"],\"regex-replacestring\":[\"\"],\"tip_text\":[\"\"],\"icon\":[\"\"],\"validations\":{\"plugin\":[\"regex\"],\"plugin_published\":[\"1\"],\"validate_in\":[\"front\"],\"validation_on\":[\"new\"],\"show_icon\":[\"0\"]}}',`introtext`='' WHERE `id`='77'
     
    Makulia, Jul 30, 2014
    #8
     
  9. Makulia

    Makulia Member

    Level: Community
    Good news! I have found the cause of our problem! It is the Roost New Article Notification Override plugin, the part of the Roost Web Push for Joomla package.
    Disabling Roost New Article Notification Override plugin solves fabrik issue. Not sure why this plugin is affecting fabrik component.
    If not fixed, I think that, at least, we should add info about this issue into the Fabrik wiki or somewhere else.
     
    Makulia, Jul 30, 2014
    #9
    troester likes this.
  10. troester

    troester Well-Known Member Staff Member

    Level: Community
    Makulia: I don't know if this is related, but in an other thread you mentioned you are running php5.5.
    @fstitna: are you running php5.5, too?
     
    troester, Jul 30, 2014
    #10
     
  11. Makulia

    Makulia Member

    Level: Community
    Yes, I am running php 5.5.9. And what is your php verison?
     
    Makulia, Jul 30, 2014
    #11
     
  12. troester

    troester Well-Known Member Staff Member

    Level: Community
    Posts crossing ;)
    I'm running php5.4.27 - but I think you've found the issue.
     
    troester, Jul 30, 2014
    #12
    Makulia likes this.
  13. Sophist

    Sophist Well-Known Member

    Level: Community
    IMO unlikely to be caused by a PHP version issue.

    introtext is a Joomla article field, so my guess is that Roost New Article Notification Override plugin hooks into Joomla's database engine to spot when new articles are being stored, and is mistakenly assuming that this update by fabrik is a new article. Either that or Fabrik is using the default SQL query object which may have had some stuff pushed into it by the above plugin, and Fabrik probably needs either to create a private SQL query object or to clear the default one before it starts to fill it.

    But just a guess.
     
    Sophist, Jul 30, 2014
    #13
    Makulia likes this.
  14. Sophist

    Sophist Well-Known Member

    Level: Community
    Hmmm - I have looked at the plugin code and can't see why it would cause this.
     
    Sophist, Jul 30, 2014
    #14
     
  15. fstltna

    fstltna New Member

    Level: Community
    Yes, i am using php5.5 too...

    I will try disabling roost and see what happens...
     
    fstltna, Jul 30, 2014
    #15
     
  16. fstltna

    fstltna New Member

    Level: Community
    Ok, i disabled it and no longer get the error, but now adding the fields/validations shows empty fiekds. Will try reinstalling fabrik and see what it does...
     
    fstltna, Jul 30, 2014
    #16
     
  17. fstltna

    fstltna New Member

    Level: Community
    Ok, i tested it and used fabrik 3.1 and it works on my mac in safari. For some reason it is not working on my ipad. Not sure why...
     
    fstltna, Aug 1, 2014
    #17

Cant add new elements, I get "Unknown column 'introtext' in 'field list' SQL=UPDATE"

  1. fstltna

    fstltna New Member

    Level: Community
    I have tried both 3.0.9 and 3.1 on my Joomla 2.5 site and I get the same error when I try and add or update a element/ I get this error:
    Code (Text):

    Unknown column 'introtext' in 'field list' SQL=UPDATE
    See attached file for the complete details. Can someone help me with this?

    Screen Shot 2014-07-27 at 12.39.13 AM.png
     
    fstltna, Jul 27, 2014
    #1
     
  2. troester

    troester Well-Known Member Staff Member

    Level: Community
    Totally strange (there's no "introtext" element in the element table).
    Is this a fresh Joomla/Fabrik installation or did you migrate/copy/whatever something?
    Check your Fabrik connection, clear all Joomla and browser cache.
     
    troester, Jul 27, 2014
    #2
     
  3. fstltna

    fstltna New Member

    Level: Community
    I have tried uninstalling and reinstalling fabrik, but it doesnt help. Any other ides, or want backend info?
     
    fstltna, Jul 28, 2014
    #3
     
  4. Makulia

    Makulia Member

    Level: Community
    Hey, fstltna! I have faced the same problem. Investigating issue for now.
    It seems like typo mistake somewhere in the code (missing ') but where?

    Let as look through the code. In the end of the query we can see
    \"show_icon\":[\"0\"]}}',`introtext`='' WHERE

    It is obvious, that the last element of the the query ('introtext') is incomplete and therefor we got an sql error.

    But I don't know where this query is generating.
     
    Makulia, Jul 30, 2014
    #4
     
  5. Makulia

    Makulia Member

    Level: Community
    I have done all of this with latest github update and Joomla 3.3.3 and had no lack.
    How introtext could get int this query?
     
    Makulia, Jul 30, 2014
    #5
     
  6. troester

    troester Well-Known Member Staff Member

    Level: Community
    So @fstitna is getting this on J!2.5 with F3.0 and 3.1?
    and Makulia on J!3.3.3 + F3.1 + GitHub?
    I can't replicate.

    This error is while trying to save a new or existing element?
    Any element plugin? or a special one?
    With validation(s)....?
    Any Joomla cache settings? JS compression components/plugins...?
     
    troester, Jul 30, 2014
    #6
     
  7. troester

    troester Well-Known Member Staff Member

    Level: Community
    Can you please post the complete error messages, maybe this will give a hint.
     
    troester, Jul 30, 2014
    #7
     
  8. Makulia

    Makulia Member

    Level: Community
    Could it be connected with latest Joomla update?

    Yes, my platform is: J.3.3.3+latest fabrik.
    Fabrik and Joomla debug is off. Gzip compression is off.

    It happens when I try to:
    1) Create a new element
    2) Save any existing element (with or without modification)
    3) Unlink one element from another
    4) Save any form settings. (Saving list settings is ok)

    This is the error message (without code tags because they strip some '):

    Unknown column 'introtext' in 'field list' SQL=UPDATE `ronb4_fabrik_elements` SET `name`='name',`group_id`='11',`plugin`='field',`label`='???',`checked_out`='1',`checked_out_time`='2014-07-30 19:03:23',`created`='2012-12-03 09:34:38',`created_by`='966',`created_by_alias`='kadisadm',`modified`='2014-07-30 19:03:30',`modified_by`='1',`width`='40',`height`='0',`default`='',`hidden`='0',`eval`='0',`ordering`='5',`show_in_list_summary`='1',`filter_type`='',`filter_exact_match`='1',`published`='1',`link_to_detail`='0',`primary_key`='0',`auto_increment`='0',`access`='1',`use_in_page_title`='0',`parent_id`='0',`params`='{\"placeholder\":\"\",\"password\":\"0\",\"maxlength\":\"255\",\"disable\":\"0\",\"readonly\":\"0\",\"autocomplete\":\"1\",\"speech\":\"0\",\"bootstrap_class\":\"input-large\",\"text_format\":\"text\",\"integer_length\":\"6\",\"decimal_length\":\"2\",\"field_use_number_format\":\"0\",\"field_thousand_sep\":\",\",\"field_decimal_sep\":\".\",\"text_format_string\":\"\",\"text_input_mask\":\"\",\"render_as_qrcode\":\"0\",\"guess_linktype\":\"0\",\"link_target_options\":\"default\",\"rel\":\"\",\"link_title\":\"\",\"show_in_rss_feed\":\"0\",\"show_label_in_rss_feed\":\"0\",\"use_as_rss_enclosure\":\"0\",\"rollover\":\"\\u041f\\u043e\\u0436\\u0430\\u043b\\u0443\\u0439\\u0441\\u0442\\u0430, \\u0443\\u043a\\u0430\\u0436\\u0438\\u0442\\u0435 \\u0441\\u0432\\u043e\\u0435 \\u0424\\u0418\\u041e!\\r\\n\\r\\n\\u0424\\u043e\\u0440\\u043c\\u0430\\u0442: \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432 \\u0418\\u0432\\u0430\\u043d \\u0418\\u0432\\u0430\\u043d\\u043e\\u0432\\u0438\\u0447.\\r\\n\\r\\n\\u0414\\u043e\\u043f\\u0443\\u0441\\u0442\\u0438\\u043c\\u044b \\u0442\\u043e\\u043b\\u044c\\u043a\\u043e \\u0440\\u0443\\u0441\\u0441\\u043a\\u0438\\u0435 \\u0431\\u0443\\u043a\\u0432\\u044b.\",\"tipseval\":\"0\",\"tiplocation\":\"top\",\"labelindetails\":\"1\",\"labelinlist\":\"0\",\"comment\":\"\",\"edit_access\":\"1\",\"view_access\":\"1\",\"view_access_user\":\"\",\"list_view_access\":\"1\",\"encrypt\":\"0\",\"can_order\":\"1\",\"alt_list_heading\":\"\\u0424\\u0418\\u041e\",\"custom_link\":\"\",\"custom_link_indetails\":\"1\",\"use_as_row_class\":\"0\",\"include_in_list_query\":\"1\",\"always_render\":\"0\",\"icon_folder\":\"0\",\"icon_hovertext\":\"1\",\"icon_file\":\"\",\"filter_length\":\"20\",\"filter_access\":\"1\",\"full_words_only\":\"0\",\"filter_required\":\"0\",\"filter_build_method\":\"0\",\"filter_groupby\":\"text\",\"inc_in_adv_search\":\"1\",\"filter_class\":\"input-medium\",\"filter_responsive_class\":\"\",\"tablecss_header_class\":\"\",\"tablecss_header\":\"\",\"tablecss_cell_class\":\"\",\"tablecss_cell\":\"width:10px;\",\"sum_on\":\"0\",\"sum_label\":\"Sum\",\"sum_access\":\"5\",\"sum_split\":\"\",\"avg_on\":\"0\",\"avg_label\":\"Average\",\"avg_access\":\"5\",\"avg_round\":\"0\",\"avg_split\":\"\",\"median_on\":\"0\",\"median_label\":\"Median\",\"median_access\":\"5\",\"median_split\":\"\",\"count_on\":\"0\",\"count_label\":\"Count\",\"count_condition\":\"\",\"count_access\":\"5\",\"count_split\":\"\",\"custom_calc_on\":\"0\",\"custom_calc_label\":\"Custom\",\"custom_calc_query\":\"\",\"custom_calc_access\":\"5\",\"custom_calc_split\":\"\",\"custom_calc_php\":\"\",\"regex-message\":[\"\\u0412\\u0435\\u0434\\u0435\\u043d\\u043d\\u043e\\u0435 \\u0424\\u0418\\u041e \\u043d\\u0435 \\u0441\\u043e\\u043e\\u0442\\u0432\\u0435\\u0442\\u0441\\u0432\\u0443\\u0435\\u0442 \\u0444\\u043e\\u043c\\u0430\\u0440\\u0442\\u0443!\"],\"regex-validation_condition\":[\"\"],\"regex-expression\":[\"\\/^([\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}|[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\-[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,})\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}\\\\040[\\u0430-\\u0451\\u0401-\\u042f][\\\\x27\\u0430-\\u044f\\u0451\\u0430]{1,}$\\/u\"],\"regex-match\":[\"1\"],\"regex-replacestring\":[\"\"],\"tip_text\":[\"\"],\"icon\":[\"\"],\"validations\":{\"plugin\":[\"regex\"],\"plugin_published\":[\"1\"],\"validate_in\":[\"front\"],\"validation_on\":[\"new\"],\"show_icon\":[\"0\"]}}',`introtext`='' WHERE `id`='77'
     
    Makulia, Jul 30, 2014
    #8
     
  9. Makulia

    Makulia Member

    Level: Community
    Good news! I have found the cause of our problem! It is the Roost New Article Notification Override plugin, the part of the Roost Web Push for Joomla package.
    Disabling Roost New Article Notification Override plugin solves fabrik issue. Not sure why this plugin is affecting fabrik component.
    If not fixed, I think that, at least, we should add info about this issue into the Fabrik wiki or somewhere else.
     
    Makulia, Jul 30, 2014
    #9
    troester likes this.
  10. troester

    troester Well-Known Member Staff Member

    Level: Community
    Makulia: I don't know if this is related, but in an other thread you mentioned you are running php5.5.
    @fstitna: are you running php5.5, too?
     
    troester, Jul 30, 2014
    #10
     
  11. Makulia

    Makulia Member

    Level: Community
    Yes, I am running php 5.5.9. And what is your php verison?
     
    Makulia, Jul 30, 2014
    #11
     
  12. troester

    troester Well-Known Member Staff Member

    Level: Community
    Posts crossing ;)
    I'm running php5.4.27 - but I think you've found the issue.
     
    troester, Jul 30, 2014
    #12
    Makulia likes this.
  13. Sophist

    Sophist Well-Known Member

    Level: Community
    IMO unlikely to be caused by a PHP version issue.

    introtext is a Joomla article field, so my guess is that Roost New Article Notification Override plugin hooks into Joomla's database engine to spot when new articles are being stored, and is mistakenly assuming that this update by fabrik is a new article. Either that or Fabrik is using the default SQL query object which may have had some stuff pushed into it by the above plugin, and Fabrik probably needs either to create a private SQL query object or to clear the default one before it starts to fill it.

    But just a guess.
     
    Sophist, Jul 30, 2014
    #13
    Makulia likes this.
  14. Sophist

    Sophist Well-Known Member

    Level: Community
    Hmmm - I have looked at the plugin code and can't see why it would cause this.
     
    Sophist, Jul 30, 2014
    #14
     
  15. fstltna

    fstltna New Member

    Level: Community
    Yes, i am using php5.5 too...

    I will try disabling roost and see what happens...
     
    fstltna, Jul 30, 2014
    #15
     
  16. fstltna

    fstltna New Member

    Level: Community
    Ok, i disabled it and no longer get the error, but now adding the fields/validations shows empty fiekds. Will try reinstalling fabrik and see what it does...
     
    fstltna, Jul 30, 2014
    #16
     
  17. fstltna

    fstltna New Member

    Level: Community
    Ok, i tested it and used fabrik 3.1 and it works on my mac in safari. For some reason it is not working on my ipad. Not sure why...
     
    fstltna, Aug 1, 2014
    #17

Windows server 2012远程桌面会话主机和远程桌面授权,server2012

摘要:对于windows server2012服务器一般都是默认能够支持两用户远程登录,而通过安装远程桌面服务里的远程桌面会话主机和远程桌面授权,并对其进行配置,即可实现多用户远程登录。

远程桌面服务是一项由若干角色服务组成的服务器角色。在 Windows Server 2012 中,远程桌面服务包含以下角色服务:

Windows Server? 2012 中的“远程桌面服务”服务器角色提供了允许用户连接到虚拟机、RemoteApp程序和基于会话的计算机的技术。通过远程桌面服务,用户可以从企业网络或 Internet 访问远程连接。

Windows Server 2012默认情况下,只能提供两个用户远程桌面登陆,而通过安装远程桌面服务里的远程桌面会话主机和远程桌面授权,并对其进行配置,即可实现多用户远程登录。下面通过介绍如何配置远程桌面会话主机和远程桌面授权,以及如何通过微软获取许可证激活许可服务器。

一、 安装桌面会话主机和远程桌面授权

1.1. 在桌面右下角点击服务器管理器图标,打开“服务器管理器”,点击“添加角色和功能”,选择“基于角色或基于功能的安装”,出现以下的安装界面

1.2. 在下边界面直接点击下一步 。

1.3. 选择远程桌面服务,点击下一步。

1.4. 在向导界面中点击下一步 。

1.5. 在远程桌面服务角色安装向导中点击下一步 。

1.6. 选择“桌面会话主机”和“远程桌面授权 ”,在弹出的窗口中点击“添加功能”,点击下一步。

1.7. 在以下界面选择安装 ,安装完成后,出现以下界面提示需重启服务器,在下面界面上点击关闭然后重启计算机。

二、 web申请激活码

2.1 在服务器管理器上点击“工具”?终端服务?远程桌面授权管理,打开远程桌面授权管理器,选择未激活的服务器,右击选择属性。

2.2 在属性对话框中,连接方法选择“Web浏览器”,记下对话框中出现的产品ID(00184-90000-00001-AT259),在获取服务器许可证时,需在网页上注册此ID。注意:如果终端服务器授权中没有服务器,请选择连接,然后输入本机服务器IP地址。

2.3 选择“必需信息”,按下图所示填写:

2.4 在Internet Explorer浏览器地址栏中输入https://activate.microsoft.com,点击GO ,开始注册并获取服务器许可密码向导。确保已选中“启用许可证服务器”项后单击"下一步"按钮。

2.5 在下面界面中,输入“产品ID:00184-90000-00001-AT259”,按下图填写所需信息后,点击下一步。

2.6 在如下信息中,直接点击下一步。

2.7 可以得到“已成功处理您的许可证服务器启动申请。你的许可证ID是:GCYCQ-7TM97-CMFKD-67X26-XY92Q-6BB7V-3PRVX”,记录此服务器ID号。在“需要此时获取客户机许可证吗”中选择”是” 。

2.8 在下边界面中,如没有许可证,在许可证程序选择“企业协议”,确定信息无误后,继续”下一步”。

2.9 在如下界面,“产品类型”选择“Windwos Server 2008 R2远程桌面服务器每用户访问许可”;最大用户数(比如为"600");在“注册号码”中输入从微软获得的七位注册号码(如果没有许可证,尝试输入5296992、6565792、4954438、6879321),再点击“下一步”。

注意:如果在产品类型中选择windows server2012,以上提供的注册码有可能不能使用。 

2.10 在下边界面直接点击下一步 。

2.11 在下边界面中,记录许可证服务器ID:GCYCQ-7TM97-CMFKD-67X26-XY92Q-6BB7V-3PRVX”和“许可证密钥ID:V8M42-2KDYD-JM6GV-DBXGG-C4XGB-F39F6-Y3PVX”,然后点击完成。

三、 激活终端服务

 

3.1 在服务器管理器中,点击工具-终端服务-远程桌面授权管理器,查看并确保服务器

属性“安装方法”设为”Web浏览器”。

3.2 选择服务器,点击右键选择“激活服务器”。

3.3 在激活服务器向导中点击下一步 。

3.4 在连接方法处选择WEB 浏览器,然后点击下一步。

3.5 输入许可服务器ID:GCYCQ-7TM97-CMFKD-67X26-XY92Q-6BB7V-3PRVX,然后点击下一步。

3.6 选择立即启动许可安装向导,下一步 。

3.7 直接下一步。

3.8 输入许可密钥ID:V8M42-2KDYD-JM6GV-DBXGG-C4XGB-F39F6-Y3PVX ,点击下一步。

3.9 服务器许可证激活向导完成,点击完成

四、 配置远程桌面会话主机授权服务器

4.1 在服务器管理器中,点击工具--远程桌面服务-->RD授权诊断程序,查看当前服务器授权状态。

4.2 在运行里输入“gpedit.msc”,打开计算机本地组策略。

4.3 在计算机本地组策略里选择计算机配置-管理模板-windows组件-远程桌面服务-远程桌面会话主机-授权,找到 “使用指定的远程桌面许可服务器”和“设置远程桌面授权模式”。

4.4 设置“使用指定的远程桌面许可证服务器”为启用,并在“要使用的许可证服务器”中,设置当前服务器的IP或者主机名。

4.5 启用“设置远程桌面授权模式”,设置授权模式为“按用户”,如下图所示。

4.6 在远程桌面会话主机下, 找到 “连接”,按如下图所示设置“限制限制连接数量(可根据具体数量设置)”和“将远程桌面服务用户限制到单独的远程桌面”:

4.7 在运行里输入”gpupdate /force”,强制执行本地组策略,重启服务器,整个配置过程完成。

Windows2008中IIS7如何关闭日志

      IIS上的网站运行一段时间后发现占用了很大空间,检查发现是日志占用的,下面是如何关闭iis日志的方法。
  1. 打开Internet 信息服务(IIS)管理器;

    Windows2008中IIS7如何关闭日志-风君子博客
  2. 双击进入界面;

    Windows2008中IIS7如何关闭日志-风君子博客
  3. 双击日志;

    Windows2008中IIS7如何关闭日志-风君子博客
  4. 点击右侧禁用;

    Windows2008中IIS7如何关闭日志-风君子博客
    以上方法是关闭所有站点的日志功能,也可以定位到具体网站关闭其日志。

About Us

Since 1996, our company has been focusing on domain name registration, web hosting, server hosting, website construction, e-commerce and other Internet services, and constantly practicing the concept of "providing enterprise-level solutions and providing personalized service support". As a Dell Authorized Solution Provider, we also provide hardware product solutions associated with the company's services.
 

Contact Us

Address: No. 2, Jingwu Road, Zhengzhou City, Henan Province

Phone: 0086-371-63520088 

QQ:76257322

Website: 800188.com

E-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.