本文介绍了Sql server身份验证问题不连接到服务器的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经安装了sql server 2012版但是一旦连接到服务器applet就来了。有一些选项服务器类型,服务器名称身份验证,用户ID和密码。

当我输入我的PC名称本地服务器名称然后它给我一个错误,我无法解锁我的SQL服务器2012.



在安装过程中有两个认证选项,一个是默认,第二个是混合情绪。不幸的是我选择了混合情绪。之后,这个错误会一次又一次地继续发生。



当我试图解决这个问题时。我确实从控制面板卸载了安装文件,然后再次运行安装程序。当我无法再次获得默认和混合情绪认证选项时,请设置直接转到错误选项。



我尝试了什么:



i从控制面板中删除了安装文件并重新启动我的电脑然后又出现了同样的问题

i have installed sql server 2012 edition but once connect to server applet comes . there are some options server type, server name authentication,userid and password.
when i entered my PC name which is local server name then it gives me an error and i am not able to unlock my sql server 2012.

during the installation there were two options for authentication one was default and second was mixed mood.unfortunately i had selected mixed mood. after that this error continue coming again and again.

when i tried to solve this problem . i did uninstall setup files from the control panel and again run the setup . when i am not able to get the default and mixed mood authentication options again then set up direct goes to the error options.

What I have tried:

i removed setup files from the control panel and restart my PC and then same problem are coming again

推荐答案

MYPCNAME/SQLEXPRESS

例如。

否则你可能会使用(localhost),但这对于发布代码来说并不是一个好主意,因为这意味着每台PC都需要它自己的SQL Server安装,这将导致巨大的问题!



看看这里: [] - 它给出了e您的连接字符串应该是什么样子的示例,并解释原因。

For example.
Otherwise you may get away with (localhost) but that's not a good idea for release code, as it means each PC needs it's own instalation of SQL Server, and that will cause immense problems!

Have a look here: SQL Server 2012 connection strings - ConnectionStrings.com[^] - it gives examples of what your connection string should look like, and explains why.


这篇关于Sql server身份验证问题不连接到服务器的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-20 08:27
查看更多