Untitled

mail@pastecode.io avatar
unknown
plain_text
7 months ago
767 B
2
Indexable
Never
7) Test the connectivity between SMO and SQL server using the below KB :
--> Below steps can be followed to test the connectivity using the PowerShell commands:
1. Remote Desktop to the SQL client.

2. Open Powershell.

3. Enter the following statement:
[reflection.assembly]::LoadWithPartialName("Microsoft.SQLServer.SMO")

4. Enter the following statement:
$SQLServer = new-object ("Microsoft.SQLServer.Management.SMO.Server")

5. Enter the following statement:
foreach($SQLDatabase in $SQLServer.databases) {$SQLDatabase.name}
6. This will result in a list of the databases on the client. This confirms that SMO is loaded properly and is connecting to SQL Server. If it results in an error, this must be resolved before Avamar can succeed.
======================= 
Leave a Comment