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.


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

Application Details:

Version: 2005
License: Free to use
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


What was not tested

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

Hardware tested


  • 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
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
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

Show all 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 Disabled

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