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.
Requires:
Application Details:
| Version: | 2005 |
| License: | Free to use |
| URL: | http://msdn.microsoft.com/en-u... |
| Votes: | 1 |
| Latest Rating: | Bronze |
| Latest Wine Version Tested: | 1.5.20 |
Maintainers: About Maintainership
What works
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.
Workarounds
What was not tested
Various types of queries.
Hardware tested
Graphics:
Additional Comments
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 Workaround? | Rating | Submitter | ||
| Show | Ubuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu) | Dec 22 2012 | 1.5.20 | Yes | Yes | No | Bronze | Daniel Jelinski | |
| Show | Ubuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu) | Jun 07 2012 | 1.5.4 | Yes | Yes | No | Bronze | Daniel Jelinski | |
| Current | Linux Mint 12 "Lisa" x86_64 | Dec 20 2011 | 1.3.30 | Yes | Yes | No | Bronze | an anonymous user | |
| Show | Fedora 14 | Mar 25 2011 | 1.3.14 | No | Not installable | No | Garbage | an anonymous user | |
| Show | Ubuntu 9.10 "Karmic" i386 (+ variants like Kubuntu) | Jul 13 2009 | 1.1.25 | Yes | No | No | Garbage | an anonymous user |
| Bug # | Description | Status | Resolution | Other apps affected |
| 12985 | Microsoft SQL Server Management Studio Express crashes at start | CLOSED | ABANDONED | View |
| 19222 | menus jump and scramble input for MS SQL Server Management Studio Express | CLOSED | FIXED | View |
| 19223 | Microsoft SQL Server Management Studio Express (SSMSE): "Object Explorer" encounters error during "Databases" expansion | NEEDINFO | View | |
| 19224 | launching a "New Query" pane produces an "OutOfMemory" error in MS SQL SMSE | CLOSED | FIXED | View |
| 19428 | Microsoft SQL Express 2005 fails to install: 'ACTION_InstallFiles Failed to extract cabinet: L"#SqlSupp.cab"', "InstallFinalize" returned 1627 | CLOSED | FIXED | View |
| 30078 | Many installers fail to detect MSXML6 component (MSXML6 is part of OS since Windows XP SP3 and Wine doesn't advertise it using registry key) | CLOSED | WONTFIX | View |
| 30280 | Microsoft SQL Server Management Studio Express (SSMSE) does not display network protocols in connection properties | NEW | View | |
| 30281 | Microsoft SQL Server Management Studio Express (SSMSE): empty dialog windows | CLOSED | FIXED | View |
| 30282 | treeview: OnExpanding is incorrectly sent to items with no children | CLOSED | FIXED | View |
| 30444 | Microsoft SQL Server Management Studio Express (SSMSE): opening new query window fails due to atl80 insufficiency | CLOSED | FIXED | View |
| 30474 | Microsoft SQL Server Management Studio Express 2005 (SSMSE): corrupted font in properties window | CLOSED | FIXED | View |
| 30475 | Microsoft SQL Server Management Studio Express 2005 (SSMSE): "New table" fails with unknown error 80070057 | CLOSED | FIXED | View |
| 30494 | Microsoft SQL Server Management Studio Express 2005: "Open table" fails | CLOSED | ABANDONED | View |
| 30531 | Microsoft SQL Server Management Studio Express 2005: OLEPicture fails to set hotspot coordinates for hand cursor | CLOSED | FIXED | View |
| 30728 | Microsoft SQL Server Management Studio Express 2005: Connection window is stretched vertically | UNCONFIRMED | View | |
| 30766 | Microsoft SQL Server Management Studio Express 2005: hangs with .NET Fatal Execution Engine Error | CLOSED | FIXED | View |
| 31153 | Microsoft SQL Server Management Studio Express 2005: fails to install with builtin mono (Unhandled page fault) | UNCONFIRMED | View | |
| 31280 | Right-clicking a listview in a dotnet application doesn't open the context menu | CLOSED | FIXED | View |
| 31323 | Microsoft SQL Server Management Studio Express 2005: cannot control server service (needs Win32_Service WMI class and improved parser for wbem_services_GetObject) | CLOSED | FIXED | View |
| 31521 | Microsoft SQL Server Management Studio Express 2005: cannot control server service (Win32_Service WMI class needs StartMode and SystemName properties) | CLOSED | FIXED | View |
| 31522 | Microsoft SQL Server Management Studio Express 2005: cannot control server service (needs implemented wbem_services_ExecMethod infrastructure) | CLOSED | FIXED | View |
| 31524 | Microsoft SQL Server Management Studio Express 2005: cannot control server service (needs Win32_Service.*Service methods) | CLOSED | FIXED | View |
| 31596 | Microsoft SQL Server Management Studio Express 2005: cannot create database because of exception (GDI+ cannot read display times of animated GIF frames) | CLOSED | FIXED | View |
| 31819 | Animated GIF images are rendered incorrectly (transparent areas painted black) | CLOSED | FIXED | 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 | |
| 32516 | MS SQL Server management studio 2005 wants unimplemented msvcr80.dll._stricmp_l | CLOSED | FIXED | View |
| 33607 | Microsoft SQL Server Management Studio Express 2005: cannot restart SQL server (wbemprox returns stale service status) | CLOSED | FIXED | 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.
