升级时出错：“值不能为空。参数名称：userGroupName" [英] Error when upgrading: "Value cannot be null. Parameter name:userGroupName"

问题描述

您好，

我收到错误"值不能为空。参数名称：userGroupName"尝试将SQL Server Express 2017升级到SQL Server Standard 2017时。

I am receiving the error "Value cannot be null. Parameter name:userGroupName" when trying to upgrade SQL Server Express 2017 to SQL Server Standard 2017.

服务器正在运行Windows Server 2012R2。

The server is running Windows Server 2012R2.

我完全删除了SQL 2017 Standard安装并尝试再次运行升级，但是失败并出现同样的错误。

I completely removed the SQL 2017 Standard installation and tried running the upgrade again, but this failed with the same error.

非常感谢任何帮助！

提前致谢。

Josh。

推荐答案

嗨Josh，



您能否尝试以管理员身份运行设置？ 右键单击设置媒体>>以管理员身份运行



请检查安装SQL的驱动器是否还有剩余空间。并检查Temp和TMP的环境值。尝试在文件资源管理器中键入％temp％，看看它是否会将您带到有效位置。

TEMP = C：\ Users \ batck \ AppData \ Local \ Temp \

TMP = C：\ Users\buck \ AppData \ Local \Temp \ 2

确保列出的目录存在且您的ID具有相应的权限写入该目录。或者，通过控制面板（控制面板 - >系统和安全 - >系统 - >高级系统设置），您可以更改分配给TEMP和TMP的默认
目录。



希望这可以帮到你。



祝你好运，

Cathy Ji

Hi Josh,

Could you please try to run the setup as administrator?  Right click setup media >> run as administrator

Please check the drive that SQL is installed has any space left. And check the environment value for Temp and TMP. Try typing %temp% in file explorer and see if it takes you to a valid location.
TEMP=C:\Users\buck\AppData\Local\Temp\2
TMP=C:\Users\buck\AppData\Local\Temp\2
Make sure the directory listed exist and your id has appropriate permission to write to that directory. Alternatively, through the control panel (Control Panel-> System and Security-> System -> Advanced system settings), you can change the default directories that are assigned to TEMP and TMP.

Hope this could help you.

Best regards,
Cathy Ji

这篇关于升级时出错：“值不能为空。参数名称：userGroupName"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！