Hello all,
I am trying to setup an SQL 2005 account to be used via DTW. However, even though the account has write access to the databases it does not show the databases in the login screen the only way I can make it do this is by making the account sysadmin which, for obvious reasons I am trying to avoid.
Does anybody have a SQL user they are using for database login for DTW that is not a SQL sysadmin. if so can you script it for me please.
Many thanks,
Mike