My SQL DB is not available for selection, SQL Migration Assistant For Access

Check the schema of your database. i guess its not dbo, and hence its not displaying in the drop down list

I am very new to SQL Server.  How do I check what the Schema is now and how do I change it if it's not dbo?

I did some more research and I think the schema is dbo.  All of the tables in the DB have the prefix dbo.
Any other reasons the DB wouldn't appear?

Just to double-check, when you connect via SSMS, are you using the same SQL Server instance (MIKE72-PC\WIN72SQLSERVER) and credentials (Windows Authentication) as you do when you are using the utility?

If yes, your login has sufficient rights for the database to show up when an application tries to enumerate through the list of available databases.

If no, can you please trying using the same credentials on the utility as you do when you login via the SSMS?

I am using the same SQL Server instance and Windows authorization to connect in SSMS.

In this case, I think it's probably related to the schema settings on the target database. Does this help: http://blogs.msdn.com/b/ssma/archive/2011/05/25/how-to-migrate-to-a-schema-in-an-existing-database-using-ssma.aspx

"In this case, I think it's probably related to the schema settings on the target database. Does this help: http://blogs.msdn.com/b/ssma/archive/2011/05/25/how-to-migrate-to-a-schema-in-an-existing-database-using-ssma.aspx"

It is entirely possible that I am so new to SQL that your answers are on target and  just don't understand them.

The database has already been migrated and the schema is set to dbo.  I can see the DB and transfer the table when using the SQL Import Export Wizard 32-bit but this wizard doesn't retain the indexes.

Still, when I try to use SQL Server Migration Assistant this DB does not appear in the drop down list for selection.

In case this give any clarity to my issues here is a pic of what I see when logging into SQL Server Manager and the list of DB's in this SQL Server Instance.

As you can see, in the DB list there are two DB's, 'GRBSSMACreated01' and 'JTSConversion'.   As I mentioned in my very first post, when I open the SQL Server Migrations Assistant 'GRBSSMACreated01' is the only DB as an option to migrate data to, 'JTSConversion' is not shown as you can see in the second pic.

Still no resolution to this one.  Any other ideas?

Thank you Vitor:  Didn't realize it was editable.  I was able to type in JTSConversion and it pulled the table.  However, I got a message at the end that probably explains why JTSConversion wasn't appearing in the drop down but I'm not sure how to resolve it.

This is the message:


How do I resolve this?

How do I determine what my username is?

Is there a way to show the current owner name?

When you know the login name, open the Logins folder and double-click on the right one and go to Mappings where you'll see the user name that he has in the JTSConversion database: