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.
Connecting to a SQL Server 2000 database over TCP/IP with SQL authentication, creating databases, creating and modifying tables, queries from New query window (with native atl80)
What does not
Open table, right-click context menus, New query (with wine's atl80), selecting different connection protocol
What was not tested
Windows authentication, database management (backups, user accounts etc.), everything else.
requires winetricks dotnet20 win7 to run. After that run winecfg and set atl80 to native, or else New query button will not work.
|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|
|Current||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||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.