I'm trying to create a reverse engineering file so I created a config file and a Hibernate console using Eclipse 3.1. I'm using a SQLServer Express 2005 database in the same PC I'm using, and the latest jdbc version from MicroSoft. I had different problems like TCP/IP ports not enabled, trusted connection, and such. I've been solving them, but I've got to a point were I cant see what's happening... I get the error message that follows:

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'sa'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.hibernate.console.FakeDelegatingDriver.connect(FakeDelegatingDriver.java:23)
...

I don't really know if there exists a user, I've sure haven't created one, and I guess 'sa' is the default user, and 'sa' it's password. If I write no username, The error message is as follows:
"com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ''. The user is not associated with a trusted SQL Server connection."

What is the problem? Is it that I don't supply a correct username/password? I don't know any! I haven't created nor modified anything!

The default setup for SQLServer includes an "sa" (system administrator) user with an empty password. You should change that ASAP. You should also not use the sa user for connecting via Hibernate: something with lesser priviledges would be better. However, the first thing you have to do is log on as sa, because that's the only way to set up new users and change passwords.

Leave the password field empty and try agian.

It's still not working... this is my Hibernate config file:
...
<hibernate-configuration>
<session-factory name="SF3">
<property name="hibernate.connection.driver_class">com.microsoft.sqlserver.jdbc.SQLServerDriver</property>
<property name="hibernate.connection.url">jdbc:sqlserver://equipo1\SQLExpress;DatabaseName=Pubs</property>
<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
<property name="hibernate.connection.username">sa</property>
<property name="hibernate.connection.password"></property>
</session-factory>
</hibernate-configuration>


I've tried with a blank password and without the property, but neither worked... what else can I try? I forgot to say I changed the registry so SQLExpress use Mixed mode and not Windows authentication

Can't you log in to the database in the normal way? Query analyzer, or whatever client app came with your server? Just use the same name/password as gets you in that way.

It's the free (Express) version of SQL Server 2005, so it came with NOTHING at all! ;-(

I'm pretty sure the problem has to do with the Windows Authentication / Sql Server Authentication, because I tryed creating a dataconection with Visual Studio.NET 2005 and testing the connection worked fine when using WA, but didn't work when I changed it to SQL Server Auth.

Do you think that creating a new user could work? How can I do that, and how do I assign it permissions to use my database? Keep in mind that I create the user using T-SQL (I can use a connection created with VS using windos Auth.)

Thanks!

btw. they do provide a free download of their management and query analyzer tools for the free version....so there is alot of good stuff there - even for the free one.

Excellent!! I downloaded the Express Manager, tryed to log with SQLServer Authentication and failed. I then logged with Windows Authentication and find out that somehow, somewhy, the user sa was "login disabled"... don't ask me...

Anyway, thank you both for the help!

Tenwit, please post something so I can give you credit for trying!

Sure. I can post a query for Max: does the "Didn't Help" link in the rating bit work the opposite to the "Did Help" link? That is, do they subtract credits? I think I've lost a few credits, and they could be from this thread, seeing as I've never seen anyone click the "Didn't Help" link before. If they do subtract credits, maybe the text of the link should change to "Completely confused me and wasted my time" ;)

Don't worry, I checked before clicking in "no" that it didn't take you credits, otherwise, I wouldn't have said no!

I guess I'm just confused then. Or maybe I created some topics while I wasn't looking, and used up my credits that way ;)