mssql msg 945 level 14 state 2
Hi!
I moved two databases over from our old server MSSQL 2005 Express to our new server MSSQL 2008 Express. I have not been able to access these two databases since. Unfortunately, it looks like MSSQL 2008 Express does not come with SQL studio management so I am left with SQLCMD. I tried using use databases_name and go and got the following error...msg 945 level 14 state 2 database can not be opened due to inaccessible or insufficient memory. I am sure it is not a memory issue. So any ideas how to fix this using SQLCMD?
TIA
I moved two databases over from our old server MSSQL 2005 Express to our new server MSSQL 2008 Express. I have not been able to access these two databases since. Unfortunately, it looks like MSSQL 2008 Express does not come with SQL studio management so I am left with SQLCMD. I tried using use databases_name and go and got the following error...msg 945 level 14 state 2 database can not be opened due to inaccessible or insufficient memory. I am sure it is not a memory issue. So any ideas how to fix this using SQLCMD?
TIA
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
acperkins,
The installation errors out saying that I have to select one or more features.
The feature is selected as shown by the attached image and yet it will not let me past this screen.
Capture.PNG
The installation errors out saying that I have to select one or more features.
The feature is selected as shown by the attached image and yet it will not let me past this screen.
Capture.PNG
I am afraid I have no idea. I have never used any Express Edition.
choose all options.
ASKER
tigin44,
I tried select all and it still gives the same error. That I need to select a feature. I guess this is what keeps M$ in business.
I tried select all and it still gives the same error. That I need to select a feature. I guess this is what keeps M$ in business.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
tigin44,
I had to install advanced tools first, but I still am getting the same error when I try to access the databases with SSMS.
I had to install advanced tools first, but I still am getting the same error when I try to access the databases with SSMS.
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
it seems that your databases not attached to new server. Attach them prior to use.