→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PaulVa214
Engaged Sweeper
ran upgrade to 4.1

when attempting to adjust permissions in configurator I get the following error

12 REPLIES 12
Hemoco
Lansweeper Alumni
Please contact us by e-mail so we can assist you remotely
PaulVa214
Engaged Sweeper
old a1030747
new usca015xp07
Hemoco
Lansweeper Alumni
Can you give me the old name and the new name please.
PaulVa214
Engaged Sweeper
hmm... not sure about how to do this..

Is this done from command prompt or ? sorry to sound stupid but don't work with sql much
Hemoco
Lansweeper Alumni
Here is some explanation on how to fix this:

http://msdn.microsoft.com/en-us/library/ms143799.aspx


this should work with the correct servernames:

sp_dropserver <'old_name\instancename'>
GO
sp_addserver <'new_name\instancename'>, local
GO
PaulVa214
Engaged Sweeper
actually, probably will need to change again due to corporate changes in naming structure.. New name would be USPET-APP02.. Hopefully would be last change (never know about upper magt..ha).

thx
Paul
PaulVa214
Engaged Sweeper
a1030747/sqlexpress


thought we had this corrected from last time? bugger. how do I fix?
Hemoco
Lansweeper Alumni
Can you post the new servername and the output from query:

select * from sys.servers

PaulVa214
Engaged Sweeper
yes, and you talked me through the changes