InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 16:42:59 GMT20http://www.sqlservercentral.com/Forums/Topic1023697-33-1.aspxThe below code uses windows authentication, but If I want to override the current logon credentials and use a different userId and password what do I need to change : oServer.LoginSecure = True Foe example the current windows logon is : AD\micky, but I want list all servers using a different user as AD\mouse. Function listDatabases(vServer As String, vControl As Object) Dim oServer As SQLDMO.SQLServer Set oServer = New SQLDMO.SQLServer oServer.LoginSecure = True oServer.Connect vServer For Each oDatabase In oServer.Databases vControl.AddItem oDatabase.Name Next End FunctionFri, 19 Nov 2010 10:44:58 GMTThayal Muhunthan