English 中文(简体)
服务器8。 未能使《议定书》/《议定书》生效
原标题:SQL Power Shell with Server 8... Cannot enable TCP/IP protocol

Created a new Server 8 machine. Testing out a .net + SQL Server 2012 site. I am trying to remotely connect to the machine but in order to do so I need to enable TCP/IP protocol. If I try and do it visually through the Computer Management Console I get some strange behavior in that if I try to select any Yes/No dropdown list it simply gives me a blank list and I cannot change the value. I can enable the TCP/IP as a whole by selecting it from the context menu in the config, but when I go into the properties I get enabled = No for all IP1, IP2, etc... areas.

当时,我试图改变它,使用科索沃警察部队......,但似乎并不认为......奇怪的是,我注意到,在财产下,没有任何东西......可以看一看,让我知道。

PS SQLSERVER> $MachineObject.getsmoobject($tcp.urn.Value + "/IPAddress[@Name= IP2 ]")



Parent              : Microsoft.SqlServer.Management.Smo.Wmi.ServerProtocol
IPAddressProperties : {Active, Enabled, IpAddress, TcpDynamicPorts...}
IPAddress           : 192.168.0.24
Urn                 : ManagedComputer[@Name= WIN-LLJKBQ6OVVR ]/ServerInstance[@Name= MSSQLSERVER ]/ServerProtocol[@Name
                      = Tcp ]/IPAddress[@Name= IP2 ]
Name                : IP2
Properties          : {}
UserData            :
State               : Existing
问题回答

当你允许TCP/IP在服务器上订立议定书时,不仅使1433港(或不管怎样)成为可能,而且你也需要确保听众与正确的接口相联。 过去,服务器的容量将达到0.0.0,但在最近版本中,可以约束多种选择之一:127.1, 192.168.1.xx, 0:0:0:0:0:0:0:1, *1 等。

请操作“SQL服务器 COnfiguration Manager”,看网络配置,确保你准确地配置听器具。 你可以用一枚壳中的“netstat-an”加以核实。

此外,对您的用户账户实际进行双重核对,并可能使服务器“组合式”成为可能。





相关问题
Export tables from SQL Server to be imported to Oracle 10g

I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...

SQL server: Can NT accounts be mapped to SQL server accounts

In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...

SQL Server 2000, ADO 2.8, VB6

How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8

热门标签