Enabling TCP/IP in SQL Express 2008 R2

May 22, 2012

0 minute read (53 words)

Programs > .. R2 > SQL Server Configuration Manager Network config > Protocols > tcp/ip > enable & properties

Clear the dynamic port under IPAll Set the TCP Port to 1433 (which is the standard sql server port).

You can then connect to “localhost” (with no instance specified) in management studio.

refs:

• https://vgoes.wordpress.com/2007/06/05/jdbc-to-sql-server-express/

---

Tweet This || Post to LinkedIn || Page Source

---

Subscribe for updates on software development, contracting, side projects, blog posts and who knows what else. Read the archives for an idea of content.

Your email:

Mailing list powered by the excellent buttondown.email.