开发者

SQL Server Management Studio Express 2005 has no Configuration Manager

开发者 https://www.devze.com 2022-12-24 22:34 出处:网络
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

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 down开发者_如何学编程load 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?


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.


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.


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


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)

0

精彩评论

暂无评论...
验证码 换一张
取 消