如何确定是否安装了本地SQL Server 2008 R2

时间:2023-01-05 19:53:38

They have installed SQL Server 2008 R2 on my work machine.

他们在我的工作机器上安装了SQL Server 2008 R2。

Connecting to (local) win auth does not seem to work. How do I determine if I have a local instance of it?

连接到(本地)win auth似乎不起作用。如何确定我是否有本地实例?

thanks

谢谢

1 个解决方案

#1


3  

Check your SQL Server Configuration Manager.

检查SQL Server配置管理器。

如何确定是否安装了本地SQL Server 2008 R2

If there isn't an instance running, follow this tutorial: http://technet.microsoft.com/en-us/library/ms190699.aspx

如果没有运行实例,请按照以下教程操作:http://technet.microsoft.com/en-us/library/ms190699.aspx

You also want to make sure your instance is a Network Service. For your instance, right click on it, then click properties. Set Log On As - Built in Account: Network Service.

您还需要确保您的实例是网络服务。对于您的实例,右键单击它,然后单击属性。设置登录为 - 内置帐户:网络服务。

如何确定是否安装了本地SQL Server 2008 R2

#1


3  

Check your SQL Server Configuration Manager.

检查SQL Server配置管理器。

如何确定是否安装了本地SQL Server 2008 R2

If there isn't an instance running, follow this tutorial: http://technet.microsoft.com/en-us/library/ms190699.aspx

如果没有运行实例,请按照以下教程操作:http://technet.microsoft.com/en-us/library/ms190699.aspx

You also want to make sure your instance is a Network Service. For your instance, right click on it, then click properties. Set Log On As - Built in Account: Network Service.

您还需要确保您的实例是网络服务。对于您的实例,右键单击它,然后单击属性。设置登录为 - 内置帐户:网络服务。

如何确定是否安装了本地SQL Server 2008 R2