SQL server data access-one db does not show

[mirage10]

sql server 2000
crystal version 8

Hi,
I am trying to create a datasource from crystal reports "create new data source" to sql server to get access from the tables in a new database which was created fairly recently.

when i am trying to change default database to access this particular db.. it does not show in the list of databases..

it shows all the other databases..

do you think.. it is an access problem??
pl. advise.
thanks

------------------------------------------
A Man can be only as happy.. as he makes up his mind to be

 

[vidru]

Could be that the login you're using doesn't have access to that database. Since it's the most recently created, that's the likely issue. Have the dba check it out.

-dave