System dbs are are not available | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

System dbs are are not available

Hi!
When we installed sql server on our new server everything was fine.It has 7 user dbs.This is our new testing server.Today when I clicked the tree view of database in EM I was shocked to see that none of the system dbs exist in tree view.Then I tried to connect to this sql server by QA.But I got the following error
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection.
When I tried to attach these system databases from the data folder I was unable to do so and got the error message as"Error 5123:CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process)while attempting to open or create the physical file ‘C:programFilesMicrosoft SQL ServerMSSQLDatamaster.mdf’
Where are my system dbs gone.How can I get them back.and what this error all about.pls suggest
did you try to re-install the sql server
try to read SQL errorlog file.. from log folder of SQL installtion directory; and event logs.<br /><br />try to read sql setup and sql service pack upgrade files.. from root system directory, to check installations errors .<br /><br /><br />Another, you did not get only system db’s in enterprises manager tree view.. that can be caused by you might have not checked "Show system database and system objects" while registring server in EM.<br /><br />offcourse you will system32 and sharing voilation errors if you will try to delete or create duplicate files.<br /><br /><img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br /><br /><br />Deepak Kumar<br /><br />–An eye for an eye and everyone shall be blind
No I havent tried to reinstall the sql server
I had the issue some time back. I can’t remember exactly what was the error message. then I reinstall the SQL server and was able to work there after.
I anything didn’t work. try with reinstalling.
i would go with Deepak’s response and check it out. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />The problem of system dbs not showing on the EM tree is solved now.It was because "Show system database and system objects" was unchecked<br />But still I am not able to connect to the db server remotely by QA or any application.The error I got is<br />[Microsoft][ODBC SQL Server Driver][DBNETLIB]Invalid Connection.<br />What is the issue here.I checked the error logs and event viewer, but didnt got some thing releated to this problem.
Good thing is one problem is solved.
Ensure the LMHOSTS has an entry for this SQL server, and you can ping the server properly. Define the proper alias using name and as well as IP Address Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Me too experienced the same problem (i.e. sys DBs not displaying in EM)…..
n get resolved by suggestion given by deepakontheweb
]]>