Web Wiz Forums - Can't delete posts

Print Page | Close Window

Can't delete posts

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=21364
Printed Date: 09 April 2026 at 1:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Can't delete posts

Posted By: mediaseer
Subject: Can't delete posts
Date 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!

Replies:

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mediaseer
Date 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

Posted By: WebWiz-Bruce
Date 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.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting