Re: Data Perspective - Connection to SQL Server 2005

Does any have a connection set up to SQL Server 2005 from the Data
Perspective? If so any ideas where I may be going wrong and cannot
connect to SQL Server though Data Perspective? Every time I try to use
the new connection wizard in the Database Explorer to set up a new
connection to SQL Server 2005. I really would like to be able to use
this tool for external databases but I get the following message:



Connection to SQL Server failed.

Login failed for user 'TESTCONN'. The user is not associated with a
trusted SQL Server connection.



When I searched the internet for the cause of this message. There were
several suggestions that SQL Server may need to be configured to use
Mixed Mode (Windows authentication and SQL Server Authentication)
instead of just Windows Authentication. But the System administrator
might not like the idea of changing the SQL Server configuration so I
wanted to make sure I have check everything else before asking to change
settings on SQL Server.



May Connection Parameters are as follows:



JDBC driver = Microsoft SQLServer 2005 Driver for JDBC



Connection URL details are:



Database = TestSmacSalesFigures

Host = smacsql ( also tried the ip address)

Port number = 1433 (I assume this is the correct port)

JDBC driver class: = com.microsoft.sqlserver.jdbc.SQLServerDriver

Class location = C:\Program Files\Microsoft SQL Server JDBC
Driver\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc.jar

Connection URL: =
jdbc:sqlserver://smacsql:1433;databaseName=TestSmacSalesFigures



User information

Is correct because I can log in with remote desktop with
it.