Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing Computer Name
Message
 
 
À
16/07/2020 08:26:48
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Windows
Catégorie:
Informatique en général
Divers
Thread ID:
01674973
Message ID:
01675209
Vues:
49
>>I realize that the cryptic name (DESKTOP-VF4MCSR) I see in the SSMS is not the SQL Server name but rather my computer name. I Googled and found steps to change the computer name to something more meaningful.
>>My question: if I change the computer name, will my SQL Server still work? What other parts of the computer may malfunction if I change the name?
>>
>>UPDATE: Changed PC name and the default SQL Server name is changed as well. No problem connecting.
>
>Actually, the SQL instance's name is unchanged, it's still mssqlserver or something like that - the default. And that default doesn't need to be mentioned in the connectstring - it can be omitted and the clients will find it by issuing just the machine's network name. As long as you included the new machine name in connectstring, of course it connected.

Thank you for your input.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform