Once you're able to resolve your login issue, I would suggest setting up
a dbo specifically for your web application. Connecting via SA opens
yourself up to all sorts of malicious exploits as well as inadvertent
mistakes that wouldn't generally be possible with a limited-scope account.
- Jim
Hassan Arteaga Rodriguez wrote:
> Hi all:
>
>
> I'm running CF MX 6.1 version. When i try to create DSN in the CF Server
> Administrator for an MS SQL Server Database i get this error msg:
>
>
> Connection verification failed for data source: DATADIGI
> []java.sql.SQLException: [Macromedia][SQLServer JDBC
> Driver][SQLServer]Login failed for user 'sa'.
> The root cause was that: java.sql.SQLException: [Macromedia][SQLServer
> JDBC Driver][SQLServer]Login failed for user 'sa'.
>
>
> Regards,
> __
> MSc. Hassan Arteaga Rodríguez
> Microsoft Certified System Engineer.
> DIGI- Grupo de Desarrollo
> COPEXTEL, S.A.
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
