sql express erro.r

[PaulVa214]

ran upgrade to 4.1

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

[Hemoco]

Please contact us by e-mail so we can assist you remotely

[PaulVa214]

old a1030747
new usca015xp07

[Hemoco]

Can you give me the old name and the new name please.

[PaulVa214]

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]

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]

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]

a1030747/sqlexpress


thought we had this corrected from last time? bugger. how do I fix?

[Hemoco]

Can you post the new servername and the output from query:

select * from sys.servers

[PaulVa214]

yes, and you talked me through the changes