Skip to content
Permalink
Branch: master
Find file Copy path
Find file Copy path
Fetching contributors…
Cannot retrieve contributors at this time
28 lines (21 sloc) 969 Bytes
layout title date author tags modified_time thumbnail blogger_id blogger_orig_url
post
Enabling TCP/IP in SQL Express 2008 R2
2012-05-22T11:10:00.001Z
Tim Abell
howto
sql server
2012-05-22T11:10:17.222Z
tag:blogger.com,1999:blog-5082828566240519947.post-7356884620087853089

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:

You can’t perform that action at this time.