Databases
StackOverflow2013
Postsdbo
POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
    primarykey
    data
    text
    <blockquote> <p><strong>Possible Duplicate:</strong><br> <a href="https://stackoverflow.com/questions/2266697/changing-sql-server-settings-programmatically">Changing SQL Server settings programmatically</a> </p> </blockquote> <p>To setup a network connection between client C# application and SQL Server 2008 R2 I know what should manually do, my problems is how to do following steps in the C# code!</p> <ol> <li>Set TCP/IP protocol Enabled for a server instance like <code>MSSQLSERVERR2</code>.</li> <li><p>Restart my SQL Server engine.</p> <p>I can do the other steps by SQL queries:</p></li> <li><p>Add User and grant admin permission.</p> <pre><code>CREATE LOGIN momtahen WITH PASSWORD = '123' EXEC master..sp_addsrvrolemember @loginame = N'momtahen', @rolename = N'sysadmin' </code></pre></li> <li><p>Set mixed authentication mode for my SQL Server.</p> <pre><code>EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode', REG_DWORD, 2 </code></pre></li> </ol> <p>I need C# code or SQL query that I could execute using C#.</p> <p>Also I have to mention that I have seen following question and no help yet!</p> <ul> <li><a href="https://stackoverflow.com/questions/9138172/enable-tcp-ip-remote-connections-to-sql-server-express-already-installed-databas">Enable tcp\ip remote connections to sql server express already installed database with code or script(query)</a></li> <li><a href="https://stackoverflow.com/questions/9137836/enable-remote-connections-to-sql-express-with-a-script/9154540#9154540">Enable remote connections to sql express with a script</a></li> <li><a href="https://stackoverflow.com/questions/2499957/what-are-registry-settings-to-enable-tcp-on-sql-server-2005-and-2008">what are registry settings to enable TCP on SQL Server 2005 and 2008?</a></li> </ul> <p>Thanks to them by the way. So any Idea?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USCommunity
    1. USReza Ameri
    plurals
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    3. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. This table or related slice is empty.
      1. VTClose
    3. VO
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. This table or related slice is empty.
      1. VTClose
    1. COThe options seem to have been discussed here already: [Changing SQL Server settings programmatically](http://stackoverflow.com/questions/2266697/changing-sql-server-settings-programmatically) It would help if you can explain why none of the other questions are helpful, and also if you're installing SQL Server then the suggestion to use a silent installation with a configuration file would be an alternative.
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. USPondlife
    2. COI couldn't find or write the C# code!
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. USReza Ameri
    3. COI found the code, I'll post it in [here](http://stackoverflow.com/questions/2266697/changing-sql-server-settings-programmatically) since this thread is closed.
      singulars
      1. POSet TCP/IP protocol enable for SQL Server 2008 r2 in C#
      1. USReza Ameri
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload