SQL Server Value cannot be null
今早打开Microsoft SQL Server 2008 R2的SQL Server Management Studio准备导入数据库,但是登陆sa后点击出错提示
错误提示为
value cannot be null.Parameter name viewinfo (microsoft.sqlserver.management.sqlstudio.explorer)
搜到的解决方法为
Check the environment value for Temp and TMP. C:\Users\buck>set t 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.
打开隐藏目录C:\Users\用户名\AppData\Local\Temp\
新建一个文件夹,将文件夹命名为2,重启系统再次登录SSMS,就可以显示系统数据库了。
本站所有文章均可随意转载,转载时请保留原文链接及作者。