Mark Breen
marklbreen at gmail.com
Mon Jan 10 04:56:20 CST 2011
Hello John, Charlotte's diagnose sounds quite correct. One thing to watch, the db might be showing a user named jcolby that was created from machine A When you move it to machine b, you may also have a user named jcolby, but it not the same user. Trying to assign jcolby to the db on machine b failed because it says the user already exists. The solution is to drop the user from the db, when you are on machine b, then re-assign jcolby, and it works perfect. If you back machine b and restore to machine a, you will probably have to do the same thing. just a note to watch out for, Mark On 9 January 2011 05:36, Charlotte Foust <charlotte.foust at gmail.com> wrote: > 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 > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >