February 21, 2011 at 8:38 am
I was able to run the folowwing query on sql 2005 server(OBBEAVER1)
select top 1* from obbeaver1.Employee.dbo.joblist
but when i try the same on sql 2008 R2 (OBBEAVER2)
select top 1* from obbeaver2.Employee.dbo.joblist
I get the following error
Could not find server 'OBBEAVER2' in sys.server
February 21, 2011 at 8:41 am
Take a look at your linked servers (sys.servers) on both machines. It looks like the 2005 box has itself set up as a linked server.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 21, 2011 at 8:43 am
no i did not setup local server as linked server and it does not allow me to do so but i can do a query using the local server name on 2005 machine but not in 2008, is this something changed in SQL 2008 version?
February 21, 2011 at 8:47 am
I just tried a self-referent query on my 2005 and 2008 servers, and it worked in both cases.
On the 2008 box, select @@servername and see if it matches what you have in the query.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 21, 2011 at 8:50 am
The querey itself should work on 2008 as well. This may be a longshot, but have you checked the collation of your 2008-db so it's not case sensitive?
Andreas Goldman
February 21, 2011 at 9:11 am
OK i see the problem that it was poitin ot a different server name which was recetnly renamed. So now how do i find where the wron name is listed so that i can rename it.
I checcked the machine name and name on the Active directory they both point the correct name, wondering where it is pulling the wrong name, any idea?
February 22, 2011 at 12:56 am
After a machine is renamed you need to get the name SQL server uses consistent.
this can be done with
exec sp_dropserver 'old name'
exec sp_addserver, 'new_name', local
GO
Mike
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply