mikebai.com

  • Home
  • dev
  • DotNET
  • M365
  • 搞笑
  • 杂七杂八
  • FocusDict
dev
dev

SPN(Service Principal name)服务器主体名称

SPN(Service Principal name)服务器主体名称。 SPN 是服务在使用 Kerberos 身份验证的网络上的唯一标识符。它由服务类、主机名和端口组成。在使用 Kerberos 身份验证的网络中,必须在内置计算机帐户(如 NetworkService 或 LocalSystem)或用户帐户下为服务器注册 SPN。对于内置帐户,SPN 将自动进行注册。但是,如果在域用户帐户下运行服务,则必须为要使用的帐户手动注册 SPN。 How to Register a Service Principal Name (SPN) With an SQL Server Agent Register a service principal name (SPN) for your Microsoft SQL Server in order to permit service accounts and users to both find your server and authenticate to it with Kerberos authentication. While administrators typically perform this configuration for the SQL Server service account, doing so for the SQL Server Agent account enables trouble-free authentication for jobs, monitors and other automation tasks on the server. Instructions 1 Configure SQL server to use a domain account for the SQL server agent. Create an account in Active Directory Users and Computers for the SQL Server agent, and then use the SQL Server Configuration Manager to change the "Log on as..." account for the SQL Server Agent to the domain account. 2 Configure the service principal name. Open a command prompt using a domain account with permission to modify the SQL Agent service account. Type the command  "setspn -A MSSQLSvc/<SQLAgentAccount>:1433 <domain\SQLAgentAccount>,"  where <SQLAgentAccount> is the name of the SQL Server Agent account and <domain\SQLAgentAccount> is the account name with the domain preceding it. 3 Confirm the configuration of the SPN by entering the command "setspn -l <SQLAgentAccount>," where <SQLAgentAccount> is the name of the domain account used by the SQL Server Agent. 4 Restart the SQL Agent Server on the SQL Server.

2019-07-22 0comments 260hotness 0likes mikebai Read all
dev

在VM虚拟机上安装Microsoft Dynamics CRM 2016 步骤图解及安装注意事项

安装Dynamics CRM 2016环境配置要求: 系统版本:Windows Server 2012 R2(必须) SQL 版本: SQLServer2014SP1-FullSlipstream-x64-ENU(必须) Dynamics CRM 版本:CRM2016-Server-ENU-amd64(必须)   安装步骤: 1.在虚拟机安装windows server 2012 r2,安装完后把机器名改成简单好认的(比如SQL2014,CRMServer等),后面安装CRM会用到。 2.在服务管理中安装Active Directory Domain Services(AD DS),安装完后再安装.NET Framework3.5和4.5 4.配置AD DS,在Server manger 顶栏小旗,点击提升为域控制器,新建林,输入域控制器名,如CRM.com,然后一路next,配置完后重启 输入密码,通常为大写字母+小写字母+特殊字符  点击安装 安装完AD DS,DNS Server和Web server(IIS)后服务器管理器面板   5.打开AD域用户和组,新建组织单元OU,如CRM2016, 然后在OU下新增一个User,如crmsvc,user密码改成永不过期 打开AD用户和计算机,Win + R 打开运行,输入dsa.msc,或者直接在开始下拉菜单找到AD用户计算机 新建组织单元 新建用户 输入用户密码,取消用户下次登录必须修改密码,勾选用户密码永不过期   5.安装SQL server2014,可以参考:http://www.sqlcoffee.com/SQLServer2014_0005.htm 进入Installation,选择New SQL Server stand-alone installation or add features to an existing installation 输入产品密钥 勾选I accept the license terms 和 Turn on customer Experience选项 下一步 规则检测过程中可能会有警告提示,按提示操作即可,Computer domain controller不用管,Microsoft .Net Application Security是可能没联网,Windows Firewell需要关闭防火墙 操作后 默认第一项,下一步 勾选Database Engine Services Full-Text and Semantic Extractions for... Reporting Services Manager Tools Basic

2019-07-22 0comments 246hotness 0likes mikebai Read all
dev

微软Dynamics CRM 2016 单服务器安装部署

文章转自:https://blog.csdn.net/u011839262/article/details/79992549 概述 本文档描述了MicrosoftDynamics CRM 2016安装的过程。这次安装采用的是单服务器部署,即在同一台计算机上安装和运行 Microsoft Dynamics CRM 服务器 2016、SQL Server、SQL Server Reporting Services。 Microsoft Dynamics CRM 依赖对操作而言非常重要的AD域服务,例如,使用 ActiveDirectory 来存储用户和组信息,以及创建应用程序安全性。所以安装之前需要先安装AD域服务,如果已有AD域可以跳过此部分。 配置AD域服务器 在应用服务器Windows Server 2012R2上安装AD域 1、启动“服务器管理器”,点击导航栏的“管理”-“添加角色和功能”菜单,在“添加角色和功能向导”页面,点击下一步直到服务器角色选择界面,勾选“AD域服务”。 点击添加功能   点击“将此服务器提升为域控制器”。 选择添加新林,如crm2016.com(根据实际需要定义) 在“林功能级别”下拉框中设定级别,分别有windowsserver 2008、Windows server2008 R2、Windows server 2012以及Windowsserver 2012 R2,默认是Windows server 2012 R2。如果选择了高等级的林功能级别,那么以后再添加域控制器时,其OS级别也必须等于或者高于林功能所设定的级别。所以,我不准备改变这个值,设置密码后,直接点击“下一步”。 安装完成后,服务器自动重新启动。 IIS的安装 1、启动“服务器管理器”,点击导航栏的“管理”-“添加角色和功能”菜单,在“添加角色和功能向导”页面,点击下一步直到服务器角色选择界面,勾选“Web服务(IIS)”。这里就不赘述啦。下一篇会讲数据库的详细安装步骤 安装数据库(本文用Sql Server 2014为例) 选择全新安装或向现有安装添加功能

2019-07-22 0comments 225hotness 0likes mikebai Read all
dev

Exchange 2013系列之八:证书申请

在之前的环境中,我们已经把Exchange Server 2013搭建起来了,也实现了内网中邮件的收发。可是当用户登录OWA时,总是提示证书错误; 估计有强迫症的同学见到这种情况感觉很不爽吧,这是因为证书是由不可信任的证书颁发机构颁发的。今天我们的任务就是解决这个问题,废话不多说,让我们进入正题吧。 首先是安装证书服务角色,因为我这里是实验环境,所以直接安装在AD上,有条件的朋友可以重新划分一台虚机或服务器来搭建。打开服务器管理器,点击管理,选择添加角色或功能;

2019-07-14 0comments 225hotness 0likes mikebai Read all
dev

3 Ways to Change PowerShell Execution Policy in Windows 10

PowerShell script cannot be loaded because the execution of scripts is disabled on this system? By default, Windows restricts running PowerShell scripts, as a security mechanism. To verify the PowerShell execution policy on your computer, you can use the Get-ExecutionPolicy cmdlet. If the execution policy is displayed as Restricted, you can change it to other settings as shown below. Restricted – No scripts can be run. Windows PowerShell can be used only in interactive mode. AllSigned – Only scripts signed by a trusted publisher can be run. RemoteSigned – Downloaded scripts must be signed by a trusted publisher before they can be run. Unrestricted – No restrictions. All PowerShell scripts can be run. In this tutorial we’ll show you how to change PowerShell execution policy in Windows 10 using command line, group policy or registry tweak. Method 1: Change PowerShell Execution Policy with Command Line Open the PowerShell as administrator. You can use the Set-ExecutionPolicy command to set the Pow

2019-07-12 0comments 258hotness 0likes mikebai Read all
dev

windows Server内存设置相关

1) SQL Server服务器 SSMS -> 服务器右键 -> 内存 -> 设置最大服务器内存 设置800MB比较合适 2)AppFabric内存占用设置 SharePoint命令行管理程序 -> 执行以下命令 Update-SPDistributedCacheSize -CacheSizeInMB 500 https://docs.microsoft.com/zh-cn/SharePoint/administration/plan-for-feeds-and-the-distributed-cache-service 安装 SharePoint Server 时,用于缓存大小的分布式缓存服务的内存分配设置为默认值,即物理内存总量的 10%。 管理员可以通过使用 Update-SPDistributedCacheSize cmdlet 来更改分布式缓存服务的内存分配。 Get-AFCacheHostConfiguration -hostname "winsrv2019" -cacheport 22233

2019-07-12 0comments 264hotness 0likes mikebai Read all
dev

acasis nvme typec无法识别解决办法 JMS583

ghost64提示以下错误 an internal inconsistency has been detected 8027 JMS583 主控 http://www.jmicron.com/product0201.html 更新主控firmware The firmware update below is intended only for use with the MyDigitalSSD M2X USB 3.1 Gen 2 M.2 PCIe SSD Enclosure Adapter featuring the JMicron JMS583 bridge controller. MyDigitalSSD is not responsible for damages or data loss as a result of other than intended use. This update is not mandatory for use and is intended only to improve MyDigitalSSD M2X adapter compatibility and connectivity. Therefore, it is solely up to the user whether or not to download and apply this update. Firmware Version 0205 Change Log Increased compatibility Fixed overheating issues on certain motherboard chipsets Fixed disconnecting issues on large transfers Firmware Update Requirements To perform this update, users will need the following: USB compatible PC running operating system Windows 7 or higher MyDigitalSSD M2X USB 3.1 Gen 2 M.2 PCIe SSD enclosure adapter Updating the Firmware Remove any SSD from the M2X enclosure. The adapter PCB board must be empty when performing this update. Download the firmware update file located here: https://www.mydigitaldiscount.com/downloads/M2X_FWUpdate_Utility_0205.zip (343KB) https://www

2019-07-09 0comments 224hotness 0likes mikebai Read all
dev

组策略中限制修改系统时间的权限

点开机器左下角“开始菜单”中的运行,在其中输入gpedit.msc,打开组策略,然后依次点开:计算机配置 ——— windows设置 ——— 安全设置———>本地策略———>单击用户权利指派后,双击右边“更改系统时间”选项,将其中的内容删除后确定重启机器即可。 如果某天想恢复,就点添加用户或组,恢复权限即可。如图:  

2019-07-09 0comments 235hotness 0likes mikebai Read all
dev

WINDOWS SERVER 2016 设置使用照片查看器查看图片

1.使用win+R快捷键快速打开运行,输入regedit打开注册表 2.在注册表中找到HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows Photo Viewer\Capabilities\FileAssociations 3.在右侧新建字符串项 需要新建两项.jpg 和.png,值都为PhotoViewer.FileAssoc.Tiff 之后就可以使用照片查看器查看.jpg 和.png的图片了

2019-07-09 0comments 250hotness 0likes mikebai Read all
dev

please wait for the profsvc windows server 2019

"Please Wait For The User Profile Service" message when logging on to TS 2008   https://social.technet.microsoft.com/Forums/windowsserver/en-US/361b5901-1098-4379-b1a0-6227b447afce/quotplease-wait-for-the-user-profile-servicequot-message-when-logging-on-to-ts-2008?forum=winserverTS  99% of the times I had this problem it was caused by either DNS issues or network bindings. Are your servers multihomed? In other words: do you have multiple network cards?  If so, make sure your "production" card is on top  in the network connections -> advanced settings -> adapters and bindings. You could also enable user env logging (search microsoft how to do that) Network Connections - Advanced Settings - Adapters and Bindings - Connections:

2019-07-08 0comments 234hotness 0likes mikebai Read all
1…34567…26

Recent Posts

  • sqlserver go语句
  • c# winform适配高dpi
  • com.microsoft.sqlserver.jdbc.SQLServerException “trustServerCertificate”属性设置为“false”,但驱动程序无法使用安全套接字层 (SSL) 加密与 SQL Server建立安全连接
  • java -cp 用法介绍
  • HTML 容器元素

Recent Comments

No comments to show.

COPYRIGHT © 2025 mikebai.com. ALL RIGHTS RESERVED.

Theme Kratos Made By Seaton Jiang