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, log in, connect, list tables, change settings. Select query worked if done as script to > select statement.
What does not
Dropdown for connection types.
What was not tested
Various types of queries.
Noticed out of memory issues like other user. Was not able to log in without installing several libraries. I don't know if these are all required. ole, msjet, secur32, odbc32, msxml6
|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|
|Current||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||UNCONFIRMED||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||.NET SqlConnection with windows authentication fails to connect: cannot initialize SSPI package||UNCONFIRMED||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.