Thanks Gregor, I have later solved it by configuring mixed authentication mode.
Although SQL Server authentication is not recommended, but I have no
other way to connect to SQL Server from a untrusted machine.
By the way, I have posted several times due to google problem, I didn't
see my post until now.
Re: dtsrun utility with only windows authentication. ... The U and P are to log onto the Storage SQL Server using SQL Server Authentication....authentication mode.... Authentication i.e. windows and sql server authentication, ... (microsoft.public.sqlserver.dts)
Re: SS2005 connection problem ... Thanks Michael, I have later solved it by configuring mixed ...authentication mode.... Although SQL Server authentication is not recommended, ... (microsoft.public.sqlserver.security)
Programmatically create DSN usind SQL Server Authentication ... I am trying to programmatically create a DSN on a target system for SQL ... Server using SQL Server Authentication.... is off-topic for my purpose because it only shows Windows authentication.... (microsoft.public.sqlserver.odbc)
Re: security ... using Windows Authentication.... SQL Server has two authentication mode:... Server however he need to be assigned more sql server permissions to ... (microsoft.public.sqlserver.setup)
RE: How to access SQL Server from a non-privileged domain account ... account to be able to access the SQL Server.... Since your SQL Server 2005 has been running with Windows Authentication... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ... (microsoft.public.sqlserver.setup)
