Enabling TCP/IP in SQL Express 2008 R2

May 22, 2012

0 minute read

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:


Share as Tweet || Share on LinkedIn
Post source code on GitHub - suggestions & PRs welcome!
Subscribe for updates on software development, contracting, side projects, blog posts and who knows what else. Read the archives for an idea of content.

Mailing list powered by the excellent buttondown.email.