I have a problem. I am trying to local export from excel to .mdf (SQL Server), and I keep getting this error:
我有个问题。我正在尝试从excel本地导出到.mdf(SQL Server),并且我一直收到此错误:
[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied.
[DBNETLIB] [ConnectionOpen(Connect())。] SQL Server不存在或访问被拒绝。
I searched different articles, and I tried everything. I installed again my SQL Server, but it still doesn't work. I checked Configuration Manager, but everything looks fine. Does anyane have any idea what else can cause it?
我搜索了不同的文章,我尝试了一切。我再次安装了我的SQL Server,但它仍然无法正常工作。我检查了配置管理器,但一切都很好。 anyane有什么想法可以导致它吗?
1 个解决方案
#1
0
The error explains that you did not specify the right database name, or the right ODBC name, or if you did you did not specify the right user/pwd combination to get access. You would need to get into those details to find the solution.
该错误说明您没有指定正确的数据库名称或正确的ODBC名称,或者如果您没有指定正确的用户/密码组合来获取访问权限。您需要了解这些细节才能找到解决方案。
Did you try to import Excel from MS-SQLserver, which requires no configuration, and has no authorisation limiations (unless hte excel file is encrypted)?
您是否尝试从MS-SQLserver导入Excel,它不需要配置,并且没有授权限制(除非hte excel文件已加密)?
#1
0
The error explains that you did not specify the right database name, or the right ODBC name, or if you did you did not specify the right user/pwd combination to get access. You would need to get into those details to find the solution.
该错误说明您没有指定正确的数据库名称或正确的ODBC名称,或者如果您没有指定正确的用户/密码组合来获取访问权限。您需要了解这些细节才能找到解决方案。
Did you try to import Excel from MS-SQLserver, which requires no configuration, and has no authorisation limiations (unless hte excel file is encrypted)?
您是否尝试从MS-SQLserver导入Excel,它不需要配置,并且没有授权限制(除非hte excel文件已加密)?