?
Solved

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

Posted on 2009-05-14
7
Medium Priority
?
1,291 Views
Last Modified: 2012-05-07
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
Comment
Question by:humer2000
  • 3
  • 3
7 Comments
 
LVL 5

Expert Comment

by:sampipes
ID: 24386371
You can probably edit it in SSMS, go into Server objects and Linked Servers
0
 
LVL 6

Expert Comment

by:bull_rider
ID: 24386504
sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO
0
 
LVL 1

Author Comment

by:humer2000
ID: 24386547
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 6

Accepted Solution

by:
bull_rider earned 2000 total points
ID: 24386597
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
 
LVL 1

Author Comment

by:humer2000
ID: 24386706
now i get this error
Server 'EXPERTHOST-025' is not configured for DATA ACCESS
0
 
LVL 6

Expert Comment

by:bull_rider
ID: 24386958
Should not you create a new question thread for this? :)
0
 
LVL 1

Author Comment

by:humer2000
ID: 24387368
rebooting the server corrected the error
thx a lot
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question