I would like to be able to connect to a SQL Server using SMO and then reconnect using a different loginÃÂ username and password.
In the following sample codeÃÂ I call svr.ConnectionContext.Disconnect. After the Disconnect call an attempt to change the timeout or any Login properties gives error:
Connection properties cannot be changed after connection has been made
Dim objServer As Server
objServer = New Server()
View Complete Post