InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 07:31:55 GMT20http://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxNope, I'm about to start a new install of 2005 and see if I see it. Don't remember the "name/company" thing in the R2 install I didThu, 03 Feb 2011 14:14:08 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxI looked in the registry, and in almost every file I could think of on the drives, and under the rock in my backyard. I couldn't find it. I installed SQL 2005 on a spare machine, express, developer, standard, and enterprise. The question didn't appear. I went to help, about in SSMS. Nothing.Are we sure the original poster isn't talking about Office? :-PThu, 03 Feb 2011 11:38:30 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxChanging the instance name works fine, as the last two posters have noted, but this thread was about changing the "Company Name" on the installation. That I am not sure of where it's stored, or even surfaced for SQL Server.Thu, 03 Feb 2011 10:32:09 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxcrazy4sql, I don't want to appear rude, but you're wrong. My experience of renaming local instances using those procs is the same as Michael's. To quote the BOL entry I mentioned in my last post:[quote]To verify that the renaming operation has completed successfullySelect information from either @@servername or sys.servers. The @@servername function will return the new name, and the sys.servers table will show the new name.[/quote]And that's exactly what happens, sweet as a nut.Thu, 03 Feb 2011 08:19:19 GMTCath Trimblehttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxJust to make sure I am not insane, I took one of our dev boxes, renamed the MACHINE from Dev001 to Dev010, re-added it to Active Directory, and used sp_dropserver /sp_addserver.When I run SELECT @@SERVERNAME, it returns "DEV010".I just did this on 4 machines last week when moving them from dev to production. This is a typical scenario that I have encountered many times.For example, a new server is purchased as a replacement. Let's call them OldServer and NewServer.NewServer is configured, updated, patched and all the other things that you need to do in this situation. Once the change over is scheduled to occur, we backup the DB's from OldServer and move them to a common storage location.At this point, OldServer gets physically shut down.NewServer is brought on-line, the MACHINE is renamed to OldServer, and aded to Active Directory.SQL Server is renamed, the databases are restored, and everything works perfectly.Maybe in SQL 6.0/6.5 would a rename require a reinstall, but this has been available since 7.0Thu, 03 Feb 2011 07:28:07 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx[quote]sp_dropserver <old_name>GOsp_addserver <new_name>, localGOis exactly how to do it. As I have many times.[/quote]Agree cath, but it will not remove the original name of the server which you will get by 'Select @@servername'. This is just for linked server. You can rename your server by your query to other name in linked server.For confirmation, Go to SSMS--ServerObjects--LinkedServers.... and then try your queries.you will see names are getting modified/added there.Thu, 03 Feb 2011 04:20:28 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxcrazy4sql, if you look in BOL at the topic How to: Rename a Stand-Alone Instance of SQL Server 2005, you'll see thatsp_dropserver <old_name>GOsp_addserver <new_name>, localGOis exactly how to do it. As I have many times.Thu, 03 Feb 2011 03:21:01 GMTCath Trimblehttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx[quote][b]Michael L John (2/2/2011)[/b][hr][quote][b]crazy4sql (1/31/2011)[/b][hr]its as simple as this.....as you cant rename the system database, similarly you cant rename the servername[/quote]This is what you said in a previous post. Were you referring to something else?[/quote]Dont tell me you dont know the difference between linked server and real server. The query suggest above is useful for renaming linked server.But whatever the case, As steve suggested follow that and close this topic.Wed, 02 Feb 2011 18:22:54 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxMy question would be why do you care about the company name in the documentation? It's not tied to a license, and no one would see it. SSMS != SQL Server, and I'm not sure why you think this is an issue.Wed, 02 Feb 2011 18:19:23 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx[quote][b]crazy4sql (1/31/2011)[/b][hr]its as simple as this.....as you cant rename the system database, similarly you cant rename the servername[/quote]This is what you said in a previous post. Were you referring to something else?Wed, 02 Feb 2011 18:05:01 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx[quote]1) sp_dropserver 'OldServerName' 2) sp_addserver 'NewServerName', local 3) then Retstart mssql[/quote]this is useful for linked server.Wed, 02 Feb 2011 17:59:59 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxtry renamming the server 1) sp_dropserver 'OldServerName' 2) sp_addserver 'NewServerName', local 3) then Retstart mssqlto verify -- select * from master..sysservers the NewServerName srvrid column should be 0Wed, 02 Feb 2011 10:34:22 GMTHimmat Singhhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxWhy can't you rename a server? I have done it many times.Tue, 01 Feb 2011 05:29:23 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxWait a minute....I've installed SQL 2005 a few zillion times and, unless my memory is failing miserably, I do not remember anyplace to enter the company name during installation. What version of SQL 2005 are you using? Secondly, if this is stored in the same places as most other Microsoft software, the setting is in the registry and it can be changed. I was part of an organization that was bought out and we had to change the registration on 3000 desktops and 120 servers. It was scripted by one of the sys admins using Powershell. Lastly, what does this matter? This information does not appear in anything important.Tue, 01 Feb 2011 05:27:07 GMTMichael L Johnhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxReinstallThanxTue, 01 Feb 2011 05:11:17 GMTsahu.rameshhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxReinstallThanxTue, 01 Feb 2011 05:11:17 GMTsahu.rameshhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxReinstallThanxTue, 01 Feb 2011 05:11:16 GMTsahu.rameshhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxok, thanks guys for providing the solutions.Tue, 01 Feb 2011 05:06:36 GMTbeejug1983http://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxREINSTALL is the only Option You have:smooooth:Mon, 31 Jan 2011 23:52:04 GMTscorpianprincehttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspx[b]REINSTALL[/b]Mon, 31 Jan 2011 23:06:35 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxI dont want to rename my server name, the question was how to edit the registration information like at the time of installation SQL Server ask for name and company name I put wrong company name over there how can now I change that wrong company name ?Mon, 31 Jan 2011 23:00:46 GMTbeejug1983http://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxits as simple as this.....as you cant rename the system database, similarly you cant rename the servernameMon, 31 Jan 2011 22:48:46 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxI think we can change it by using serverproperty but I dont know how to use that statement.Mon, 31 Jan 2011 22:43:04 GMTbeejug1983http://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxEven, I have the same opinion.Cheers,SatnamMon, 31 Jan 2011 22:37:51 GMTSatnam Singhhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxThe only option I can see here is reinstall sql server with new/correct instance name and attach the database from old instance.Mon, 31 Jan 2011 22:27:33 GMTcrazy4sqlhttp://www.sqlservercentral.com/Forums/Topic1056590-146-1.aspxHi,I have installed SQL Server 2005, I put wrong company name while installing. Now the installation process completed how can I change the wrong company name.Thanks in advance :)Mon, 31 Jan 2011 22:16:20 GMTbeejug1983