SQL Server 2012 Express on Network - cannot see attached databases - can see Master, etc.
-
I went through security and added. Checked the owners and added sa and admin account. I just can't seem to figure out what I have missed! DBs detached, copied, and moved from test server to actual network server seems to have not included a "setting" or "configuration". Any ideas? Using Windows Authentication. The odd is that I can connect and see the Master, but not the attached databases that were added. And yes, they were attached and brought online. The fact that I can see the master tells me that I have the router rules set correctly. I am open to any suggestions. Throw it at me. I have to have missed something obvious. FIXED! The problem exists in policy, whether group or user I did not explore further. Installed SQL Server as a local machine with local admin. I completely took the server offline for the initial setup. Reconnected using the suggested username/password as well. Not a problem at all.
-
I went through security and added. Checked the owners and added sa and admin account. I just can't seem to figure out what I have missed! DBs detached, copied, and moved from test server to actual network server seems to have not included a "setting" or "configuration". Any ideas? Using Windows Authentication. The odd is that I can connect and see the Master, but not the attached databases that were added. And yes, they were attached and brought online. The fact that I can see the master tells me that I have the router rules set correctly. I am open to any suggestions. Throw it at me. I have to have missed something obvious. FIXED! The problem exists in policy, whether group or user I did not explore further. Installed SQL Server as a local machine with local admin. I completely took the server offline for the initial setup. Reconnected using the suggested username/password as well. Not a problem at all.
What UI are you using to manage the databases?
Never underestimate the power of human stupidity RAH
-
What UI are you using to manage the databases?
Never underestimate the power of human stupidity RAH
-
I went through security and added. Checked the owners and added sa and admin account. I just can't seem to figure out what I have missed! DBs detached, copied, and moved from test server to actual network server seems to have not included a "setting" or "configuration". Any ideas? Using Windows Authentication. The odd is that I can connect and see the Master, but not the attached databases that were added. And yes, they were attached and brought online. The fact that I can see the master tells me that I have the router rules set correctly. I am open to any suggestions. Throw it at me. I have to have missed something obvious. FIXED! The problem exists in policy, whether group or user I did not explore further. Installed SQL Server as a local machine with local admin. I completely took the server offline for the initial setup. Reconnected using the suggested username/password as well. Not a problem at all.
The following are the only possibilities. - The database has not been attached, - You are not connecting to the database server that you think you are. - The user permissions are wrong.
PrissySC wrote:
The fact that I can see the master tells me that I have the router rules set correctly
If you couldn't route to the database server then you couldn't connect nor log in. It has nothing to do with whether you can see databases.
-
The following are the only possibilities. - The database has not been attached, - You are not connecting to the database server that you think you are. - The user permissions are wrong.
PrissySC wrote:
The fact that I can see the master tells me that I have the router rules set correctly
If you couldn't route to the database server then you couldn't connect nor log in. It has nothing to do with whether you can see databases.
See, that is where I am puzzled! I specifically went in and gave public access as well as set the Owner to the account. So then, thinking aloud, I should look at the owner. Should I look at builtin\users or default admin account? I already set the NT. From there, I assume, properties, user mapping. Checked the DB in question and provided membership to owner and public. I will check the server roles and grant status for the user too. Hmmm .... at least you agree with me! Thanks, and if you think of something else, I will check back and keep this thread updated. :)
-
See, that is where I am puzzled! I specifically went in and gave public access as well as set the Owner to the account. So then, thinking aloud, I should look at the owner. Should I look at builtin\users or default admin account? I already set the NT. From there, I assume, properties, user mapping. Checked the DB in question and provided membership to owner and public. I will check the server roles and grant status for the user too. Hmmm .... at least you agree with me! Thanks, and if you think of something else, I will check back and keep this thread updated. :)
If you have restored/attached the database from a different server you may need to drop and reapply the user permissions, while the name is the same the id values are different. While I use windows authentication in SSMS I have all my apps have a SQL identity and uses that, so a connection string ALWAYS has a userid and password, never integrated.
Never underestimate the power of human stupidity RAH
-
I went through security and added. Checked the owners and added sa and admin account. I just can't seem to figure out what I have missed! DBs detached, copied, and moved from test server to actual network server seems to have not included a "setting" or "configuration". Any ideas? Using Windows Authentication. The odd is that I can connect and see the Master, but not the attached databases that were added. And yes, they were attached and brought online. The fact that I can see the master tells me that I have the router rules set correctly. I am open to any suggestions. Throw it at me. I have to have missed something obvious. FIXED! The problem exists in policy, whether group or user I did not explore further. Installed SQL Server as a local machine with local admin. I completely took the server offline for the initial setup. Reconnected using the suggested username/password as well. Not a problem at all.
I would have agreed, but I created a new database on the SQL server. I went to a client machine to connect, and once again, the new database does not show in the list. I get the SQL list with master and such. Truly, this is really bothersome. It is almost as if there is a "scope" problem. Could the GPO affect this? It is an Admin of the domain, but what was given to me was that this admin account has full access. I would think to differ only because ... SQL installs with a local machine admin yes? Creator/Owner does have special permissions by default on 2008 ... would any portion of this effect the DATA folder where the database has been relocated for attachment? Lastly, I will try using nonintegrated methods and consider troubleshooting ID values as well per Mycroft Holmes' post.