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
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
The SQL Server instance is a named instance of the default instance?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Vitor
it is the default instance. When I run this script does SQL need to be restarted?
it is the default instance. When I run this script does SQL need to be restarted?
Yes, it will need to be restarted.
ASKER
Thank you for your help that seems to have fixed my issue