An Exception occurred while executing Transact-SQL statement or batch ( SQL 2008 R2 )
Error as below :
Microsoft SQL Server Management studio
An Exception occurred while executing Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Additional Information : A transport-level error has occurred when receiving results from the server. (provider:TCP Provider, error:0 - The specified network name is no longer available.) (Microsoft SQL Server, Error:64)
Microsoft SQL Server Management studio
An Exception occurred while executing Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Additional Information : A transport-level error has occurred when receiving results from the server. (provider:TCP Provider, error:0 - The specified network name is no longer available.) (Microsoft SQL Server, Error:64)
Cause : Due to Local admin privileges above Batch query gives an error to fire
Solution : Set Current user account UAC low & provide full administrator access to the logged user and try to connect remote database with "Run As Administrator"
Solution : Set Current user account UAC low & provide full administrator access to the logged user and try to connect remote database with "Run As Administrator"
Searches Related Links:
No comments:
Post a Comment
Thank you for logging in.. Waiting for your valuable views.