No - it doesn't matter. Unless someone configured a SQL alias, and is using that to connect to the SQL Server. The alias should point to the FQDN of the SQL Server, but maybe it points to the IP.
When you say "you upgraded the SQL Server", what exactly was done? If you enable audit logging in SQL Server (or run Profiler), are you even seeing any attempts to connect? If so, what is happening to those connections? What other troubleshooting have you done? And what are the results? Cheers Ken From: David Lum [mailto:[email protected]] Sent: Sunday, 19 February 2012 1:26 PM To: NT System Admin Issues Subject: RE: So...we broke SMS and Lice Communcations Server 2005 I did find the new SQL server has the same name but different IP. Not sure if that should matter, but I know it can sometimes.. Dave From: Rankin, James R [mailto:[email protected]]<mailto:[mailto:[email protected]]> Sent: Saturday, February 18, 2012 9:17 PM To: NT System Admin Issues Subject: Re: So...we broke SMS and Lice Communcations Server 2005 Those lice can do without for now Sent from my SR-71 Blackbird ________________________________ From: David Lum <[email protected]<mailto:[email protected]>> Date: Sat, 18 Feb 2012 23:50:40 +0000 To: NT System Admin Issues<[email protected]<mailto:[email protected]>> ReplyTo: "NT System Admin Issues" <[email protected]<mailto:[email protected]>> Subject: So...we broke SMS and Lice Communcations Server 2005 Our DBA's upgraded our SQL server to a SQL box of the same name but now SMS and LCS are broken. As I have never configured either of these from scratch do you guys happen to have any pointers? Some of our other SQL-dependant apps came back fine (Sharepoint, McAfee), but LCS and SMS now no worky. The consoles I do have up for both apps aren't much help. SMS has site repair and site setup options, but I am not sure what they do and if they'll make things worse. LCS I have even less options to look at. I guess I should look at this as a DR issue and pretend we have to reconnect to DB's that were restored from backup onto a different server, and this server just happens to have the same name? David Lum Systems Engineer // NWEATM Office 503.548.5229 // Cell (voice/text) 503.267.9764 ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe ntsysadmin ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
