SMO - Using SQL authentication
I recently had a question about trying to get Mark's
scripts (http://blogs.msdn.com/mattm/ ) to work when the
servers are only configured for SQL authentication.
The user had changed the settings in the transfer section of the code and it
still failed.
The key is the server object. When you create it without specifying any
parameters it defaults to windows authentication. If you want to use SQL
authentication you have to provide some credentials.
There is a how to in BOL on this the web link is http://msdn2.microsoft.com/zh-cn/library/ms162207.aspx
-