Re: Data Perspective - Connection to SQL Server 2005

Larenzo

Being able to log in with remote desktop - I believe that is logging in to Windows, not to SQL Server. Are you able to set up an ODBC DSN on your PC, to the SQL Server instance?

You need to talk to your SQL Server administrator - ask about getting you set up as a user in the trusted connection - the message means just what it says.

Now a trusted connection will use your Windows login on your PC to authenticate, I believe - when you set up such a connection, you don't even put in a user ID. I have this example for ODBC, but things should be similar for JDBC - this is Visual Basic syntax, by the way -

*For Trusted Connection Security*

oConn.Open "Driver={SQL Server};"&
"Server=MyServerName;"& _
"Database=myDatabaseName;"& _
"Trusted_Connection=yes"

HTH
Vern

On 6/20/2011 1:55 PM, Larenzo Alexander wrote:

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.