test user problem in MS Sql Server 2005

[Rakesh Chaudhary]

Hi Ranchers,

I am using MS SQL Server 2005.While deploying my application I get this error on the Tomcat log...The config..file for the local environment here has been set to different
1.database user
2.Login name

But some how I get this error where its trying to login to different database and different user...



I am using mixed mode authentication here ...I have enabled all the pipes....VIA,TCP/IP,Named pipes etc..

Have set the protocol for TCP/IP to 1433.

Started the service........Even I uninstalled the Db and installed it again ....

Still I getting this Exception for a Db which doesnt exist...I even checked the local Db files...and ders nothing like....test Db...

ERROR [main] (dataservices.JDBCService) - Connection Failed: Cannot open
database "test" requested by the login.
The login failed.
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "assa" requested by the login.

Please Help guys............

[Paul Sturrock]

assa and test databases must be named in your connection URL or as the default databases for the SQL Server login.

[Rakesh Chaudhary]

Hi Paul,

The thing is I am not at all trying to connect to the test or assa dB....or some crap username...My requirement here is different...like I trying to connect to a dB

named base and to a user base.


But some how its taking the reference of this test and assa ....from where I am not able to figure out.

The connection url I am using is having the reference to the base dB and user base...but its not taking ..it..

I tried installing the sql server...n number of times..but dont know ..where this reference is stuck....

All my config...files are correct and pointing towards....base and base...

I dont know how to assign ...the base dB as a default one...I have to try this..anyways..thanks for the reply..

[Paul Sturrock]

The connection url I am using is having the reference to the base dB and user base.

Not sure what this means. Can you explain? Your JDBC URL should include the database name and credentials to connect (if you are using SQL Server authentication). Perhaps you could show us the URL you are using?

I dont know how to assign ...the base dB as a default one...

SQL Server doesn't have a concept of a default database for the server. What do you mean by this? DO you mean default for the login? Have you checked the default database for the login you are using?