Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Trying to change SQL Server IP settings. Configuration Manager telling me "The specified file is read only" [closed]

Tags:

sql-server

windows

ip-address

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?

like image 739
d3z Avatar asked Apr 26 '12 11:04

d3z

People also ask

How do I enable TCP IP connection in SQL Configuration Manager?

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.

How do I enable SQL Server network configuration?

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.

Can you change the IP address of a SQL Server?

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.

Does SQL Server care when you change the IP address?

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.

Is SQL server TCP enabled in Configuration Manager?

[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.

How do I change the TCP/IP protocol in SQL Server?

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.

What is the default IP address format for SQL Server?

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.

1 Answers

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]
like image 184
itsejoke Avatar answered Sep 21 '22 08:09

itsejoke
Sign in to Comment

Related questions

ServiceStack OrmLite with multiple Database Servers
How do I eliminate the ALTER DATABASE statement from my SSDT publish script?
Using SQL LocalDB in a Windows Service
Outer Apply Returning columns unexpectedly NOT NULL when no match
Pseudo Random Repeatable Sort in SQL Server (not NEWID() and not RAND())
SQL Server Exception: "The column name xxx is not valid" when using JDBC
Do we still need stored procedures when using compiled queries?
What is wrong with my Try Catch in T-SQL?
Using SqlParameter to create Order By clause
How to use If Statement in Where Clause in SQL?
Using IF / ELSE to determine a SELECT INTO statement
T-SQL: WHERE clause in OVER(PARTITION BY... ORDER BY...)
PHP sqlsrv query to database
SQL Select values starting with a capital letter
Selecting Persons in table and exclude wife but combine their names
Obfuscate / Mask / Scramble personal information
"select * from table" vs "select colA, colB, etc. from table" interesting behaviour in SQL Server 2005
Source Control tools for Visual Studio 2010 and SQL Server 2008 scripts and database updates?
What tool generates diagrams from SQL Server hierarchical data?
Behavior of unique index, varchar column and (blank) spaces

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!