WineHQ

Microsoft SQL Server Management Studio Express

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:

  • .NET Framework version 2.0
  • Microsoft Core XML Services (MSXML) 6.0

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

No maintainers. Volunteer today!

Free Download Download

Test Results

Old test results
The test results for this version are very old, and as such they may not represent the current state of Wine. Please consider submitting a new test report.
Selected Test Results

What works

Connecting to a SQL Server 2000 database over TCP/IP with SQL authentication, creating databases, creating and modifying tables, queries from New query window

What does not

Connecting over named pipes, windows authentication, Open table, selecting different protocol, expanding "Databases" may fail

Workarounds

What was not tested

Connecting to SQL Server 2005, database management (backups, user accounts etc.)

Hardware tested

Graphics:

  • GPU:
  • Driver:

Additional Comments

requires winetricks dotnet20 win7 to run. Does not work with native (windows) comctl32.

selected in Test Results table below
Operating systemTest dateWine versionInstalls?Runs?Used
Workaround?
RatingSubmitter
CurrentUbuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu)Dec 22 20121.5.20Yes Yes BronzeDaniel Jelinski 
ShowUbuntu 11.10 "Oneiric" amd64 (+ variants like Kubuntu)Jun 07 20121.5.4Yes Yes BronzeDaniel Jelinski 
ShowLinux Mint 12 "Lisa" x86_64Dec 20 20111.3.30Yes Yes Bronzean anonymous user 
ShowFedora 14Mar 25 20111.3.14No Not installable Garbagean anonymous user 
ShowUbuntu 9.10 "Karmic" i386 (+ variants like Kubuntu)Jul 13 20091.1.25Yes No Garbagean anonymous user 

Known Bugs

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

Show open bugs

HowTo / Notes

SSMSEE installation in wine 1.5.20

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 msiexec /i SQLServer2005_SSMSEE.msi
SSMSEE installation in wine 1.5.2 - 1.5.19

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.

Expanding database list fails with error message
This is Bug 19223. At this point you will not see any databases on the list, and the expand button near Databases folder will disappear. It is still possible to recover from this error by clicking Databases and clicking Refresh (or pressing F5), after which the list of databases should appear.

Comments

Comments Disabled

Comments for this application have been disabled because there are no maintainers.
Back