August 5, 2002 at 2:45 pm
I recently downloaded the microsoft jdbc driver for sql server 2000. I made a simple jsp page to test the db connection but no matter what I do I get a message saying my user does not have a trusted connection. I tried creating a new domain user, a new db login, changing the db user's properties, etc. Also, when I connect via the enterprise manager it uses windows authentication. I tried changing this to sql server authentication but got the same error (could not connect because connection not trusted). I'm a newbie to sql server and i'm sure i'm missing something basic...
Any help would be greatly appreciated!
thanks in advance.
August 5, 2002 at 2:55 pm
Havent used JDBC, but we can start by making sure everything else is ok. You ARE able to use Enterprise Manager to establish a trusted connection? What about using a SQL login/password? Are you using JDBC server side or on the client? The client won't be able to use a trusted connection unless it's running on an intranet page, external users won't usually be part of the domain.
Andy
August 5, 2002 at 3:09 pm
I could not use the enterprise manager to access the db with a sql login. when I edited the registration and clicked the "use sql server authentication" then entered my username/password I got the same error about untrusted connection. I tried making logins while connected via the NT authentication but those new db users didn't connect via entreprise manager either. I even made a new domain user and tried that as well.
Oh, and JDBC is on the server.
thanks
August 5, 2002 at 7:45 pm
No point in trying JDBC until you resolve your connection issues. Do you have someone at work who can help you with that? Could be something as simple as the service is not started. Typically EM will discover available servers on the network, after that if you have a valid login/password you should be able to connect.
Andy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply