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?
+1
A:
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
2010-03-23 21:37:44
That should be it. The GUI tools were not included.
eschneider
2010-03-23 21:40:06
eschneider
2010-03-23 21:41:13
+1
A:
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
2010-03-23 21:38:52
For the full version, but for Express; I don't think it was included.
eschneider
2010-03-23 21:42:04
A:
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
2010-03-23 21:40:51
A:
run this
C:\WINDOWS\system32\mmc.exe /32 "C:\WINDOWS\system32\SQLServerManager.msc"
and here is the sql 2005 express edition
drorhan
2010-03-23 21:46:41
A:
Thanks Guys. I found the mmc.exe file with the configuration manager. Thanks again.
~joe b.
brohjoe
2010-03-24 16:39:44