Microsoft SQL Server Management Studio Express (SSMSE) is a free, easy-to-use graphical management tool for managing SQL Server 2005 Express Edition and SQL Server 2005 Express Edition with Advanced Services.
Install took some serious effort, including installing Fink, to get a package manager to get cabextract to get .NET 2.0 to install. Once that was all done, the install seemed painless.
What does not
Nothing works - unable to start the software. I get two error dialogs with the following messages: 1. Microsoft Visual C++ Runtime Library... R6034 An application has madean attempt to load the C runtime library incorrectly. Please contact the application's support team for more information. and then immediately afterwards 2. c:\windows\Microsoft.NET\Framework\v2.0.50627\mscorwks.dll could not be loaded
What was not tested
The problem may be related to the .NET install and not this software specifically.
|Operating system||Test date||Wine version||Installs?||Runs?||Used|
|Show||Ubuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu)||Dec 22 2012||1.5.20||Yes||Yes||Bronze||Daniel Jelinski|
|Show||Ubuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu)||Jun 07 2012||1.5.4||Yes||Yes||Bronze||Daniel Jelinski|
|Show||Linux Mint 12 "Lisa" x86_64||Dec 20 2011||1.3.30||Yes||Yes||Bronze||an anonymous user|
|Show||Fedora 14||Mar 25 2011||1.3.14||No||Not installable||Garbage||an anonymous user|
|Show||Ubuntu 9.10 "Karmic" i386 (+ variants like Kubuntu)||Jul 13 2009||1.1.25||Yes||No||Garbage||an anonymous user|
|Bug #||Description||Status||Resolution||Other apps affected|
|19223||Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion||NEEDINFO||View|
|30280||Microsoft SQL Server Management Studio Express (SSMSE) does not display network protocols in connection properties||NEW||View|
|30728||Microsoft SQL Server Management Studio Express 2005: Connection window is stretched vertically||UNCONFIRMED||View|
|31153||Microsoft SQL Server Management Studio Express 2005: fails to install with builtin mono (Unhandled page fault)||UNCONFIRMED||View|
|32005||Microsoft SQL Server Management Studio Express 2005: service status notifications missing (needs ExecNotificationQueryAsync)||UNCONFIRMED||View|
|32076||Microsoft SQL Server Management Studio Express (SSMSE) v1.x: .NET SqlConnection with windows authentication fails to connect: cannot initialize SSPI package||NEEDINFO||View|
|32334||Microsoft SQL Server Management Studio Express 2005: Connection window is too narrow||NEW||View|
|33642||Microsoft SQL Server Management Studio Express 2005: restarting SQL server fails randomly||UNCONFIRMED||View|
As a prerequisite you need to install .NET framework version 2.0. Follow the instructions on its appdb page.
The installer also requires MS XML 6.0. Wine's implementation is quite sufficient, but the installer fails to detect it when wine is in Windows XP mode (the default). Run winecfg and set Windows version to Windows 7.
After that, execute:
Wine versions prior to 1.5.20 had a bug in atl80 library, which prevented 'New query' button from working. To use native atl80 library run winecfg, switch to Libraries tab, select atl80 from the list, click Add and close winecfg by clicking OK. After that the button will work correctly.