[AccessD] Further to "can's see SQL Server database...

Charlotte Foust charlotte.foust at gmail.com
Sat Jan 8 23:36:25 CST 2011


You don't have permissions on the database.  You can see that it
exists, but that's all.  As the SA from a machine that has full
access, probably the server, you need to grant appropriate permissions
to you role or Windows login or whatever you're using to open the
database.

Charlotte Foust

On Fri, Jan 7, 2011 at 9:06 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> I went back in with MSE and looked at that server.  While I can see the
> databases of interest, if I click on them and try to see the tables inside,
> I get an error "the database DISCO is not available" and the plus symbol in
> front of the database disappears.
>
> So I can see that the db exists but not actually access it (from my
> workstation).
>
> I can see and open the database from MSE on the server itself.
>
> Is this an ownership / rights kind of issue?  I am not getting an actual
> error number from my workstation, just an "not available" generic kind of
> message.
>
> If it is ownership / rights, how do I go about discovering how to fix it?
>
> --
> John W. Colby
> www.ColbyConsulting.com
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list