<div>
You can probably edit it in SSMS, go into Server objects and Linked Servers
</div>


You can probably edit it in SSMS, go into Server objects and Linked Servers

<div>
sp_dropserver &lt;old_name\instancename&gt;<br />
GO<br />
sp_addserver &lt;new_name\instancename&gt;, local<br />
GO
</div>


sp_dropserver <old_name\instancename>
GO
sp_addserver <new_name\instancename>, local
GO

<div>
my last instance name was the default instance<br />
so what should i put in <br />
<br />
sp_dropserver &lt;old_name\instancename&gt;<br />
GO<br />
sp_addserver &lt;new_name\instancename&gt;, local<br />
GO
</div>


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

<div>
now i get this error<br />
Server 'EXPERTHOST-025' is not configured for DATA ACCESS
</div>


now i get this error
Server 'EXPERTHOST-025' is not configured for DATA ACCESS

<div>
Should not you create a new question thread for this? :)
</div>


Should not you create a new question thread for this? :)

<div>
rebooting the server corrected the error<br />
thx a lot
</div>


rebooting the server corrected the error
thx a lot

<div>
<div class="content wysiwyg-content">
Hi experts,<br />
I have a server with win 2003 enterprise and sql 2005<br />
an ecommerce site is hosted on this server<br />
<br />
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<br />
when i intend to write in to the database i get an error <br />
<br />
Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br />
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'EXPERTHOST-025' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. <br />
<br />
Please anyon,e has a fix <br />
thanks<br />

</div>
</div>


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


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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.