Enabling TCP/IP in SQL Express 2008 R2

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.


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.

Mailing list powered by the excellent buttondown.email.