Link to home
Start Free TrialLog in
Avatar of jyoung127
jyoung127

asked on

SQL Error

Hello all
SQL 2014
We Changed the name of physical server from server A to Server B.

When trying to give user permissions get the following error.



TITLE: Microsoft SQL Server Management Studio
------------------------------

Attempt to retrieve data for object failed for Server 'Server A'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attempt+to+retrieve+data+for+object+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=12.0.2000.8+((SQL14_RTM).140220-1752)&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------



Please help.

James
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

The SQL Server instance is a named instance of the default instance?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jyoung127
jyoung127

ASKER

Vitor
it is the default instance. When I run this script does SQL need to be restarted?
Yes, it will need to be restarted.
Thank you for your help that seems to have fixed my issue