execute sp_addlinkedserver to add the server to sysservers after renaming mu computer
Posted on 2009-05-14
I have a server with win 2003 enterprise and sql 2005
an ecommerce site is hosted on this server
I have changed my computer name due to netbios issue, and after restarting my server, the web application running on my server does not work proprely
when i intend to write in to the database i get an error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'EXPERTHOST-025' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Please anyon,e has a fix