Installing MSSQL EXPRESS 2008 problems [modified]
-
Just some ideas: *I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly. *Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected? I recommend uninstalling and installing again. If you don't have the permission to perform the install, have an administrator at your company install the software for you. Also, run chkdsk to ensure your hard drive does not have any errors on it. This page explains some possible causes of the error. One reason might be that some files got corrupted or are not available (e.g., on a disconnected drive).
[
S<T>::f(U) // Out of line.
](http://msdn.microsoft.com/en-us/library/8yk3t00s(v=vs.71).aspx)
AspDotNetDev wrote:
*I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly.
Where can i turn off the compression?
AspDotNetDev wrote:
*Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected?
Nope no external drive was installed and the network was on s:\ , so i don't think it will be e:\.
AspDotNetDev wrote:
If you don't have the permission to perform the install, have an administrator at your company install the software for you.
I don't know if local admin right is enough to perform the install. I mean i can edit registry or change computer settings. I just can't create a new account. And asking the people in IT is like begging for mercy, I'd really like to avoid that until necessary.
AspDotNetDev wrote:
Also, run chkdsk to ensure your hard drive does not have any errors on it.
Nope no errors.
-
I'm trying to install MSSQL EXPRESS 2008 on my companies work computer. I have the local admin right,just not the super admin. it gives me this not enough permission error. When I did finally successfully install the MSSQL. It just that it gives these errors
2011-04-28 11:50:32.05 spid51 Error: 17204, Severity: 16, State: 1.
2011-04-28 11:50:32.05 spid51 FCB::Open failed: Could not open file e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\model.mdf for file number 1. OS error: 3(The system cannot find the path specified.).
2011-04-28 11:50:32.05 spid51 Error: 17207, Severity: 16, State: 1.
2011-04-28 11:50:32.05 spid51 FileMgr::StartLogFiles: Operating system error 2(The system cannot find the file specified.) occurred while creating or opening file 'e:\sql10_main_t.obj.x86fre\sql\mkmastr\databases\objfre\i386\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.I did do some searching online. It says that this is caused because i wasn't able to finish the installation. Is there any way to fix this or install the MSSQL? Since I'm just a normal dude in this company. There's no way I can get the super admin right. or even create another user account. Any help? #EDIT all installation is directed to c:\ only. But it seems the default is e:\ weird setting presuming everyone has an E:\
modified on Thursday, April 28, 2011 4:29 AM
-
What drive are you installing from? a CD? Also, did you run the install as administrator?
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
S Douglas wrote:
What drive are you installing from? a CD?
From C:\ a downloaded File at Microsoft.
S Douglas wrote:
Also, did you run the install as administrator?
My account is the local admin account. Except create account, I basically have right to everything ( I think ).
-
S Douglas wrote:
What drive are you installing from? a CD?
From C:\ a downloaded File at Microsoft.
S Douglas wrote:
Also, did you run the install as administrator?
My account is the local admin account. Except create account, I basically have right to everything ( I think ).
loveangel888 wrote:
From C:\ a downloaded File at Microsoft.
Was it an installer file (EXE, MSI) or a virtual disk (ISO)? Speaking of, do you have drive emulator software that may have been enabled at some point (e.g., Alcohol 120% emulates DVD-ROM drives)?
[
S<T>::f(U) // Out of line.
](http://msdn.microsoft.com/en-us/library/8yk3t00s(v=vs.71).aspx)
-
AspDotNetDev wrote:
*I have had trouble with compression turned on. Once I turned off compression, my SQL installation went smoothly.
Where can i turn off the compression?
AspDotNetDev wrote:
*Perhaps you had an external drive (e.g., flash drive or USB hard drive) plugged in during the install? Maybe it's a network drive that has since been disconnected?
Nope no external drive was installed and the network was on s:\ , so i don't think it will be e:\.
AspDotNetDev wrote:
If you don't have the permission to perform the install, have an administrator at your company install the software for you.
I don't know if local admin right is enough to perform the install. I mean i can edit registry or change computer settings. I just can't create a new account. And asking the people in IT is like begging for mercy, I'd really like to avoid that until necessary.
AspDotNetDev wrote:
Also, run chkdsk to ensure your hard drive does not have any errors on it.
Nope no errors.
loveangel888 wrote:
Where can i turn off the compression?
I am speaking of NTFS compression. Right click the root drive (C:\ I suppose) and ensure "compress this drive to save disk space" is unchecked. Also, any folders that SQL installs to (e.g., Program Files) should also be uncompressed.
[
S<T>::f(U) // Out of line.
](http://msdn.microsoft.com/en-us/library/8yk3t00s(v=vs.71).aspx)
-
loveangel888 wrote:
Where can i turn off the compression?
I am speaking of NTFS compression. Right click the root drive (C:\ I suppose) and ensure "compress this drive to save disk space" is unchecked. Also, any folders that SQL installs to (e.g., Program Files) should also be uncompressed.
[
S<T>::f(U) // Out of line.
](http://msdn.microsoft.com/en-us/library/8yk3t00s(v=vs.71).aspx)
Well I checked them just now and I don't see this option anywhere. I suppose its not open by default . BTW the file name I used to install is SQLEXPRWT_x86_ENU.exe *EDITED NVM I found it , it wasn't opened
-
S Douglas wrote:
What drive are you installing from? a CD?
From C:\ a downloaded File at Microsoft.
S Douglas wrote:
Also, did you run the install as administrator?
My account is the local admin account. Except create account, I basically have right to everything ( I think ).
right click installer, run as adminitrator. sql needs to install stuff that has to run as the local admin, which sounds like you have permissions to do so.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
-
right click installer, run as adminitrator. sql needs to install stuff that has to run as the local admin, which sounds like you have permissions to do so.
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
Yes, But the part that worries me, is will the installation create an Account of it self. Which if it does, then that's probably the reason why I cannot install the whole thing. nevertheless i will try out to run as later as i'm working on other stuffs now. Will report result later ;) .
-
Yes, But the part that worries me, is will the installation create an Account of it self. Which if it does, then that's probably the reason why I cannot install the whole thing. nevertheless i will try out to run as later as i'm working on other stuffs now. Will report result later ;) .
OK.. I found the reason. It seems I don't have the debug right for the programs in my account. As a result I won't be able to install MSSQL into the computer. This kinda sucks. And I found a KB about it. It seems this happens a lot in big companies.
-
OK.. I found the reason. It seems I don't have the debug right for the programs in my account. As a result I won't be able to install MSSQL into the computer. This kinda sucks. And I found a KB about it. It seems this happens a lot in big companies.