<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.technet.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx</link><description>DCA complains about missing priviledges when selecting a database when SQL authentication is being used Our current findings show that this issue is caused by the fact that the DCA now always verifies if the MCMS system account has db_datareader, db_datawriter</description><dc:language>en-US</dc:language><generator>CommunityServer 2.1 SP1 (Build: 61025.2)</generator><item><title>Microsoft Content Management Server 2002 Service Pack 2 Resources</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#419321</link><pubDate>Sun, 12 Feb 2006 22:00:51 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:419321</guid><dc:creator>Andrew Connell [MVP MCMS]</dc:creator><description /></item><item><title>Microsoft Content Management Server 2002 Service Pack 2 Resources</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#419339</link><pubDate>Sun, 12 Feb 2006 22:09:28 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:419339</guid><dc:creator>Andrew Connell [MVP MCMS]</dc:creator><description /></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#420898</link><pubDate>Wed, 01 Mar 2006 15:34:14 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:420898</guid><dc:creator>Krister Bone</dc:creator><description>Hi Stefan,&lt;br&gt;&lt;br&gt;I've tried to find this hot fix on the Microsft site and have called Microsoft Support and they don't have details for this hot fix, can you please advise about where and how to get this.&lt;br&gt;&lt;br&gt;Thanks in advance,&lt;br&gt;&lt;br&gt;Krister </description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#420899</link><pubDate>Wed, 01 Mar 2006 15:35:47 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:420899</guid><dc:creator>Krister</dc:creator><description>Hi Stefan, &lt;br&gt;&lt;br&gt;I wasn't logged in on last post regarding obtaining the hot fix, can you please reply to this email address.&lt;br&gt;&lt;br&gt;Thanks again,&lt;br&gt;&lt;br&gt;Krister</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#421145</link><pubDate>Fri, 03 Mar 2006 20:32:21 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:421145</guid><dc:creator>Krister</dc:creator><description>Hi Stefan,&lt;br&gt;&lt;br&gt;Please ignore previous posts, have managed to get through to the devloper department who know about this patch, just waiting on them getting back to us.&lt;br&gt;&lt;br&gt;Cheers&lt;br&gt;&lt;br&gt;Krister</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#421293</link><pubDate>Mon, 06 Mar 2006 16:59:10 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:421293</guid><dc:creator>MS</dc:creator><description>why request fixes - tell MS to make it available - geez, do they want us to get it to run or do we have to sit on a telephone.&lt;br&gt;&lt;br&gt;MS business model sucks</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#656442</link><pubDate>Wed, 21 Feb 2007 17:44:07 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:656442</guid><dc:creator>mikehardeman</dc:creator><description>&lt;p&gt;Stefan,&lt;/p&gt;
&lt;p&gt;I tried to run this hotfix version of the DCA last evening, and, while it no longer complains about the user rights to my MCMS database, it DOES give an error to the effect that DCA thinks my SQL Server 2005 Express database is a PRE SQL Server 2000 release. &amp;nbsp;Has anyone else reported this?&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Mike H.&lt;/p&gt;</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#656451</link><pubDate>Wed, 21 Feb 2007 17:52:14 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:656451</guid><dc:creator>Stefan_Gossner</dc:creator><description>&lt;p&gt;Afaik SQL 2005 Express is not supported.&lt;/p&gt;
</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#656880</link><pubDate>Thu, 22 Feb 2007 00:09:26 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:656880</guid><dc:creator>mikehardeman</dc:creator><description>&lt;p&gt;Thanks, Stefan.&lt;/p&gt;
&lt;p&gt;I didn't get this error message with the Service Pack 2 DCA, only with the latest one with the hotfix. &amp;nbsp;The SP2 DCA gave me that error message that said the database user I was logged in as did not have the proper rights over the database (although the user did). &amp;nbsp;This was in SQL Server 2005 express, so if the latest and greatest DCA is filtering out Express (and allowing 2005), then the filtering seems to have been added recently. &amp;nbsp;&lt;/p&gt;
&lt;p&gt;It seems if THAT were the case, then the error message might just go ahead and state that MCMS doesn't support SQL Server 2005 Express Edition.&lt;/p&gt;
&lt;p&gt;?&lt;/p&gt;</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#657389</link><pubDate>Thu, 22 Feb 2007 10:40:42 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:657389</guid><dc:creator>Stefan_Gossner</dc:creator><description>&lt;p&gt;Hi Mike,&lt;/p&gt;
&lt;p&gt;if it worked with SP2 it should still work. You should open a support case for this.&lt;/p&gt;
&lt;p&gt;Cheers,&lt;/p&gt;
&lt;p&gt;Stefan&lt;/p&gt;
</description></item><item><title>re: First MCMS SP2 hotfix has been released today!</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#657826</link><pubDate>Thu, 22 Feb 2007 16:30:59 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:657826</guid><dc:creator>mikehardeman</dc:creator><description>&lt;p&gt;Stefan,&lt;/p&gt;
&lt;p&gt;It didn't actually WORK with SP2. &amp;nbsp;In that scenario, I was getting the user rights &amp;quot;bug&amp;quot;, where the installation wizard thought that my admin (dbo) account wasn't valid. &amp;nbsp;With this one, I think I don't get that far. &amp;nbsp;I'm not sure, but I think the database check happens before that.&lt;/p&gt;
&lt;p&gt;At any rate, I ended up just phoning up my ISP and having them create a new database for me on their SQL Server 2000 server, and everything is OK now. &amp;nbsp;&lt;/p&gt;
&lt;p&gt;I don't know how many developers install the MCMS database on their local machines (I was hoping to do this on my laptop), but it occurs to me that the usage is so hefty, that unless you have a couple of processors and a couple of gigs of memory, it's probably not a good idea.&lt;/p&gt;
&lt;p&gt;With this setup, the only requirement is that the development machine have an internet connection to get to my ISP's database.&lt;/p&gt;
&lt;p&gt;Mike H.&lt;/p&gt;</description></item><item><title>SQL Server on a Remote Machine | keyongtech</title><link>http://blogs.technet.com/stefan_gossner/archive/2006/01/19/417769.aspx#3189268</link><pubDate>Thu, 22 Jan 2009 05:18:38 GMT</pubDate><guid isPermaLink="false">d5e57398-b9ef-4490-9955-07cbb4e4a80d:3189268</guid><dc:creator>SQL Server on a Remote Machine | keyongtech</dc:creator><description>&lt;p&gt;PingBack from &lt;a rel="nofollow" target="_new" href="http://www.keyongtech.com/362981-sql-server-on-a-remote"&gt;http://www.keyongtech.com/362981-sql-server-on-a-remote&lt;/a&gt;&lt;/p&gt;
</description></item></channel></rss>