July 19, 2009 at 9:14 am
We have a strange problem.
On an hosted dedicated server running windows 2003 standard 32 bits 4 Gb ram i installed sql 2008 developer.
After a while some people complaint about te server name (lets say Leaseserver765432).
I was not to happy to change it, but ok i did, now its name is K6K_1
First week no problem i could log in and all seemed fine, but there was no database in it.
Last week we got al sql backup from a cumstomer, i restored it to our server and had normal access.
The next day we tried to get in, no way, management studio would not let me in. After some checking i tried as server name local host.
Bingo i was in, but sum parts of the server still having problems, mostly retated to the old name.
I hope i gave some background info, and i excuse me for my English, but i guess my English is better than your dutch ;-)(except the Dutch people)
Can someone help me with this.
Tanks in advance
Wim
July 19, 2009 at 10:07 am
You need to check on the rename server procedure !
SQLServer knows its own name, so you need to remove the old and add the new one.
http://msdn.microsoft.com/en-us/library/ms143799.aspx
stand alone instance
sp_dropserver
GO
sp_addserver , local
GO
named instance
sp_dropserver
GO
sp_addserver , local
GO
Also keep in mind, if you are using SQLAgent jobs, you may need to alter the "target server" of every job.
Check it !
-- Update Originating_Server sysjobs !! for SQLAgent
-- zie http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
DECLARE @srv sysname
SET @srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE msdb..sysjobs
SET originating_server = @srv
where originating_server = 'theOldName'
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 19, 2009 at 10:14 am
Thank you
Never expected an answer so soon.
Next weekend when this job is ready, i wil try this.
Let you Know.
Wim
July 19, 2009 at 11:13 am
I was just checking my mail and had a couple of minutes spare for SSC :hehe:.
Most of the times mail and SSC come together.
Have a nice (remaining)weekend.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply