Menu
I've just installed SQL Server Express 2012 on my Windows 7 machine. When I go to the Configuration Manager it allows me to enable/disable the TCP/IP protocol, but when I try to change any of the IP settings, on pressing 'OK' or 'Apply', it's displaying a dialog that says:
The specified file is read only. [0x80071779]
Update: The issue seemed to resolve itself. What's the inverse of Murphy's Law?
739
On the Start menu, click All Programs > Microsoft SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager. Click SQL Server 2012 Services. Expand the SQL Server 2012 Network Configuration node, and then select Protocols for MSSQLServer (SQL Instance Name) . Right-click TCP/IP, and then click Enable.
To enable a server network protocolIn SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration. In the console pane, click Protocols for <instance name>. In the details pane, right-click the protocol you want to change, and then click Enable or Disable.
On the right pane, under the Server Name category, right-click the SQL Server Instance, and select Properties option to open the Properties dialog box. On the General tab, change the IP address resource.
I would say that SQL Server does care when you change the IP address of your server. It is all based on the configuration of the TCP/IP settings for that given instance. Once you change the IP, go into SQL Server Configuration Manager and then the Network Configuration.
[Failed]:Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port. [Failed]:Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port.
Use the TCP/IP Properties (IP Addresses Tab) dialog box to configure the TCP/IP protocol options for a specific IP address. Only TCP Dynamic Ports and TCP Port can be configured for all addresses at once by selecting IP All. Changes take effect when SQL Server SQL Server is restarted.
The IP address can be in either IPv4 or IPv6 format. Blank, if dynamic ports are not enabled. To use dynamic ports, set to 0. For IPAll, displays the port number of the dynamic port used. View or change the port on which SQL Server listens.
I have the same issue with installing sql 2012 Developer on W7 x64 Pro.
I have solved this huge issue by modify manually the Registry database in :
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL11.SQL2012\MSSQLServer\SuperSocketNetLib\Tcp]
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
