tengiz wrote:OK, вот blog по SQL Express в котором, как мне обещали, после выходных должен появиться подробный FAQ, включая решение проблем connectivity: http://blogs.msdn.com/sqlexpress
cityzen wrote:Net 2.0 официально не предлагается, даже как бета.
Win32nipuh wrote:tengiz, все-таки, в нескольких словах, объясните: как коннектиться к новому серверу через одбц, ОЛЕ ДБ, АДО? Или же для него это все уже не проходит?
1/ SQLBrowser service is not running by default, the default install done by VS for SSE installs as <machinename>\sqlexpress I believe, the easiest fix is to start the browser service so that named instance resolution can occur.
2/ Connectivity from legacy apps, seems like some older apps and even some MS ones use dblib, which is not installed for express so they bounce.
3/ Confusion over how to use SNAC, ie should they connect using regular sqloledb or something else, I think <removed> was going to try and do some investigation on this.
4/ Installing SSE next to SEM breaks SEM, we are taking a fix for this today into Yukon which will make it into B2. Until then the fix is to regsv32 the sqldmo.dll that is in the SQL2000 directory, this means DMO will not work against Yukon but EM will be happy. This fix also resolves the problem when I uninstall SSE and EM fails to work, in this second case SQLDMO9 is uninstalled but the SQLDMO registration is not put back.
)