Viewing 15 posts - 106 through 120 (of 707 total)
OS was Windows 2003 server and SQL Server 2005 earlier.
Later only OS was upgraded toWindows 2008 server and SQL Server is still 2005.
Has anyone faced this issue ? Any suggestions...
October 9, 2014 at 7:35 pm
Thanks.
They are cloning to totally a diff box. So will the following steps be fine.
1. Stop SQL Server services in actual server
2. Let wintel complete cloning.
3. Start SQL Server services...
September 29, 2014 at 11:41 pm
SQLRNNR (9/29/2014)
It is best to quiesce the databases before cloning the machine. You can achieve that through stopping the SQL services.
Thanks alot.
Is it essential ?. Do we have...
September 29, 2014 at 10:50 pm
Reboot din't make any difference. Still the error is logged continously. Any suggestions ?
September 8, 2014 at 1:20 am
Hi..
I followed the link below, not sure if it will make any diff.
Auth is KERBEROS from remote SSMS and NTLM from local SSMS.
And still the error gets logged in the...
September 4, 2014 at 9:37 pm
Jobs are OK.. Not many as such, the basic ones which I can even add manually.
I am still confused on the error logged there. How to get rid of it....
September 4, 2014 at 7:23 pm
Perry Whittle (9/4/2014)
if running under local system you shouldnt need to do anything
OK.. Then why the error logged in errorlog ?
Thanks.
September 4, 2014 at 8:53 am
Perry Whittle (9/3/2014)
You'll need to create a new SPN if you change the computername and the svc account does not have permission to do it automatically.
Thanks. I will need to...
September 3, 2014 at 7:23 pm
One more thing:
sp_dropserver <old_name>;
GO
sp_addserver <new_name>, local
GO
Restart SQL Server
Hi,
All went well and SQL Server is working fine as well. App team is able to connect to the DBs and...
September 2, 2014 at 10:48 pm
sreekanth bandarla (8/7/2014)
Just Curious...Why the App team wants Database Server host name and IP to be changed?
That's a requirement under certain circumstances... It's inevitable...
August 7, 2014 at 7:29 pm
Thanks Anthony, Lynn... Good to go now.
And any IP cach related issues, we can take help of other teams like AD team.. So it should not trouble us much.
Thanks...
August 7, 2014 at 7:28 pm
Thanks..
Is it going to be very troublesome ?..
Anyone did it before by any chance ?.
August 7, 2014 at 8:44 am
Thanks.
Will check and update you.
Thanks again.
August 6, 2014 at 8:33 am
So it's basically,
1. Login into Passive node
2. Run setup
3. Remove that node from cluster.
Hope I got it right.
Thanks,
Smith.
August 5, 2014 at 8:36 pm
Viewing 15 posts - 106 through 120 (of 707 total)