SQL Server Management Studio Express 2005 has no Configuration Manager

sql-server sql-server-express ssms sql-server-2005-express
brohjoe picture brohjoe · Mar 23, 2010 · Viewed 16.2k times · Source

Where is the configuration manager for SQL Express 2005? I need to configure SQL Server for TCP/IP but there is no configuration manager with the package. I see SQL Server Database Publishing Wizard, I see SQL Server Migration Assistant for Access, but no Configuration Manager. According to the MSDN, there should be one. I've even looked online for a download of the Configuration Manager for SQL Server 2005, but could not find one. Did I miss something in the download or should I just scrap SQL Server Express and download the full-blown SQL Server for Developers?

Answer

Mark Wilkins picture Mark Wilkins · Mar 23, 2010

This might be what you are looking for. I have used it with SQL Server Express 2005 although I am not sure if it configures the specific things you want to change and I just now verified that it does provide access to the communications options.

Related questions

SQL Server: enable remote connections without SSMS

I've got a SQL Server Express 2008 install on my web server, which by default does not allow remote connections (probably a good thing.) I opted not to install SQL Server Management Studio Express along with it for disk space and …

Read More
Can't connect to local computer via SQL Server 2008 Express Management Studio

HI, folks, Previously, I had a SQL Server 2008 installed, but then I deleted it, and installed SQL Server 2008 Express Management Studio. And now I can't connect to local computer. I get error : A network-related or instance-specific error occured while establishing …

Read More
SQL Server 2016 Express Management Studio cannot design a new or existing table

In Microsoft SQL Server 2016 Express Management Studio (July 2016) cannot design a new or existing table. Image 1: click on the tables node. Where is the menu option to add a new table? Image 2: Click on existing table. Where is the menu …

Read More