• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1296
  • Last Modified:

execute sp_addlinkedserver to add the server to sysservers after renaming mu computer

Hi experts,
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
thanks
0
humer2000
Asked:
humer2000
  • 3
  • 3
1 Solution
 
sampipesCommented:
You can probably edit it in SSMS, go into Server objects and Linked Servers
0
 
bull_riderCommented:
sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO
0
 
humer2000Author Commented:
my last instance name was the default instance
so what should i put in

sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
bull_riderCommented:
supposing your old computer name was EXPERTHOST-025 and your new name is EXPERT

Then put it like :

sp_dropserver [EXPERTHOST-025]
GO
sp_addserver [EXPERT], local
GO


Let me know if you face any more issues.
0
 
humer2000Author Commented:
now i get this error
Server 'EXPERTHOST-025' is not configured for DATA ACCESS
0
 
bull_riderCommented:
Should not you create a new question thread for this? :)
0
 
humer2000Author Commented:
rebooting the server corrected the error
thx a lot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now