1

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?

skaffman
  • 398,947
  • 96
  • 818
  • 769
brohjoe
  • 11
  • 1
  • 1
  • 2

4 Answers4

2

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.

Mark Wilkins
  • 40,729
  • 5
  • 57
  • 110
  • That should be it. The GUI tools were not included. –  Mar 23 '10 at 21:40
  • 2
    SQL 2008 Version: http://www.microsoft.com/downloads/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en –  Mar 23 '10 at 21:41
2

My SQL Server 2005 Express Configuration Manager shortcut launches:

C:\WINDOWS\system32\mmc.exe /32 "C:\WINDOWS\system32\SQLServerManager.msc"

If you don't have the start menu shortcuts, try running that from the run menu/command prompt. Check in the C:\WINDOWS\system32\ folder to make sure the SQLServerManager.msc file exists.

adrianbanks
  • 81,306
  • 22
  • 176
  • 206
1

It should be installed as part of your SQL Express 2005 installation. Perhaps you arent looking at the right place. In a typical installation, you will find the configuration manager in here (word may not match as I just typed in as I can remember)

Start -> Program -> Microsoft SQL Server 2005 -> Configuration Tool -> Configuration Manager
Fadrian Sudaman
  • 6,405
  • 21
  • 29
  • For the full version, but for Express; I don't think it was included. –  Mar 23 '10 at 21:42
0

Try installing this "SQL Server 2005 service pack 3"

https://msdn.microsoft.com/en-us/sqlserver/bb895958

It installs lots of utilities including the configuration manager.

I encountered this same issue with a particular machine (cuz usually -with other machines- it gets installed with normal SQL EXPRESS 2005 installer)

code7amza
  • 181
  • 1
  • 8