addloginsp_addlogin [ @loginame = ] 'login'
[ , [ @passwd = ] 'password' ]
[ , [ @defdb = ] 'database' ]
[ , [ @deflanguage = ] 'language' ]
[ , [ @sid = ] sid ]
[ , [ @encryptopt = ] 'encryption_option' ]
add rolesp_addrole [ @rolename = ] 'role'
[ , [ @ownername = ] 'owner' ]
addrolemember
sp_addrolemember [ @rolename = ] 'role' ,
[ @membername = ] 'security_account'
sp_droplogin
sp_droplogin [ @loginame = ] 'login'
sp_grantlogin
sp_grantlogin [@loginame =] 'login'
sp_revokelogin
sp_revokelogin [ @loginame = ] 'login'
sp_password
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
.......
Not Associated with a trusted SQL Server Connection" when I try to connect to an SQL database and use a valid SQL username
This occurs typically when Microsoft Sql Server installation is configured to use only Windows authentication and not SQL Server authentication.
So when u try to login using sql server account this error occurs.
You can also use "trusted connection = yes" in your connection string. Or use impersonation.
See the article
Import and export data发表于 @ 2005年01月26日 13:09:00|评论(loading...)|编辑|收藏