Web Wiz Support and Community Forums : Can't delete posts https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 01:18:32 +0000 Fri, 22 Sep 2006 15:25:56 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=21364 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Can't delete posts : If you do reinstall then you can...]]> https://forums.webwiz.net/cant-delete-posts_topic21364_post114383.html#114383 Author: WebWiz-Bruce
Subject: 21364
Posted: 22 September 2006 at 3:25pm

If you do reinstall then you can keep your existing database.

With SQL Server 2005 you can detach and attach database from SQL Server 2005 so you can make a backup of the actual database files.
]]> Fri, 22 Sep 2006 15:25:56 +0000 https://forums.webwiz.net/cant-delete-posts_topic21364_post114383.html#114383 <![CDATA[Can't delete posts : Thanks for the reply..I&#039;ll...]]> https://forums.webwiz.net/cant-delete-posts_topic21364_post114379.html#114379 Author: mediaseer
Subject: 21364
Posted: 22 September 2006 at 2:43pm

Thanks for the reply..I'll try the linked server route first to see if that works otherwise it may have to be a reinstall!
 
Cheers
]]> Fri, 22 Sep 2006 14:43:43 +0000 https://forums.webwiz.net/cant-delete-posts_topic21364_post114379.html#114379 <![CDATA[Can't delete posts : I had this problem before and...]]> https://forums.webwiz.net/cant-delete-posts_topic21364_post114375.html#114375 Author: WebWiz-Bruce
Subject: 21364
Posted: 22 September 2006 at 11:48am

I had this problem before and it took many hours of looking through sites on Google to find the problem.

This error can occur if you change the name of your computer, SQL Server 2005 can hold the old name still and thus get the permissions error you mention when running things like delete commands on the database.

I did finally after many hours of searching found a solution, but it didn't work very well, it involved calling the sp_addlinkedserver stored procedure with a command to link the new computer name.

However, I still had issues and finally sorted it by uninstalling SQL Server and then reinstalling it.
]]> Fri, 22 Sep 2006 11:48:58 +0000 https://forums.webwiz.net/cant-delete-posts_topic21364_post114375.html#114375 <![CDATA[Can't delete posts : I&#039;ve setup the forum using...]]> https://forums.webwiz.net/cant-delete-posts_topic21364_post114374.html#114374 Author: mediaseer
Subject: 21364
Posted: 22 September 2006 at 11:35am

I've setup the forum using SQL Express. Everything works fine except deleting a post?! I get this...

Microsoft OLE DB Provider for SQL Server error '80004005'

Could not find server 'MYSQLSERVER_NAME\SQLEXPRESS'in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

/forum/delete_post.asp, line 185

do I need to add my local sql server as a linked server? bit unsure if this is the real prob or its a permissions issue?
 
Thanks for any help!

]]> Fri, 22 Sep 2006 11:35:41 +0000 https://forums.webwiz.net/cant-delete-posts_topic21364_post114374.html#114374