January 27, 2015 at 2:01 pm
Our test SQL 2012 server was cloned from our dev SQL 2012 setup by another individual. Now I am trying to resolve a couple issues so I can have a 3rd party product install properly as it hangs on the database connection on the test server.
1) Under our user properties for the SECURABLES, the server name from the dev server is listed. When I attempted to add the test server name that I am running on, I receive the error 'Invalid Urn filter on server level: filter must be empty, or server attributed must be equal to the true server name'.
2) Under the SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for MSSQLSERVER
2a) The IP address under TCP/IP Properters > IP Addreses for IP2 lists the IP addresses from the dev server. It appears I could just change them to the correct IP, but not sure of impact.
2b) The IP address under IP5 has some strange letters/numbers/colons prior to the dev server IP address followed a % and number. I am not sure what type of IP address this is and if it is even save to just update the identifiable IP address portion to the new IP address.
Has anyone run into this issue with cloning and have suggestions on how to fix the above?
January 27, 2015 at 5:12 pm
It seems that you need get the computer name inside SQL Server to match where it is now installed. You might start by reviewing the information below. I found this by searching the internet with "rename sql instance after computer name change".
January 28, 2015 at 8:14 am
Thanks, that helped with #1 of my questions.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply