From: Mecn on 18 Jun 2010 14:26
hi is sql 2005 named instance is same as sql server virtual server?
From: John Bell on 18 Jun 2010 15:51
On Fri, 18 Jun 2010 14:26:05 -0400, "Mecn" <mecn(a)yahoo.com> wrote:
>hi is sql 2005 named instance is same as sql server virtual server?
No they have the convention servername\instancename see
If this a virtual server then the SQL Server name could be incorrect
if it was cloned. Check SELECT @@SERVER in a query windows to see if
this is the case. If so then use sp_dropserver and sp_addserver as
detailed in http://support.microsoft.com/kb/303774