June 22, 2009 at 12:52 am
i did this install so i can develop an asp application that uses the 2008 filesteaming.
i downloaded and installed the trial 180 day sqlserver 2008, all looked good cept i don't seem to have a 2008 instance installed/running. see attachment for the discovery report of what is installed, the hpwja, (hp jetadmin) and sqlexpress (visual studio 2005) were already installed so 2008 seems to have taken them under its wing so to speak. it looks like i have 2008 but see attachment 2, pic from the management studio, there is no 2008 instance, just the hpwja and sqlexpress????
if 2008 is truly there, what do i have to do to access it, so i can create a database, tables etc, etc???
one thing i noticed on the install, see third attachment. it didn't have all the categories that a ms install video indicated, http://msdn.microsoft.com/en-us/library/dd299415.aspx, i think one of which included filestream, so even though the install was very long and detailed it seems to have fallen short somewhere or i'm missing something very basic here
June 22, 2009 at 1:20 am
You have 2 instances of SQL Express running .
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
June 22, 2009 at 10:07 am
ok i see that, but can you elaborate on that? i don't seem to have access to them from the management studio and i don't have filestream installed to the instance of sqlexpress the shows in sql configuration manager, see attachment. maybe i missed it but i dont' remember the install asking if i wanted filestream. i'm thinking a 'full' version of 2008 not an sqlexpress, i'm thinking/guessing that a full version is required to have filestream please see 2nd attachment that shows list of install options show on ms install video, still wondering why that list is so different from the list i get, see attachment in the original post
June 22, 2009 at 9:09 pm
Filestream is verymuch supported in SQL Express.But you need to have it on a 64 bit server .Even if you have 32 bit version of SQL Sevrer on a 64 bit Server it wont work (we call it Windows on Windows or WoW).
Filestream will also not work if you have installed SQL Server 2005 (it will also show up in SQL Server 2008 configuration manager due to backward compatibility).
Next is filestream .Even if you have not enabled filestream during the setup , you can do so after the setup following simple steps in BOL .
Finally, to open the instance in management studio you need to enter
servername\SQLEXPRESS
servername\HPWJA
ope this helps
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
June 23, 2009 at 12:05 am
so if i understand this
Filestream is verymuch supported in SQL Express.But you need to have it on a 64 bit server .Even if you have 32 bit version of SQL Sevrer on a 64 bit Server it wont work (we call it Windows on Windows or WoW). my server is 32bit, so i will not be able to run filestream on current setup, further i will need to unistall sql express since i don't have 64bit
Filestream will also not work if you have installed SQL Server 2005 (it will also show up in SQL Server 2008 configuration manager due to backward compatibility). i will have to uninstall server 2005 as well
Next is filestream .Even if you have not enabled filestream during the setup , you can do so after the setup following simple steps in BOL . BOL?? but from above stmts i can't enable filestream in my current installation anyway due to the 64 bit and sql 2005
Finally, to open the instance in management studio you need to enter
servername\SQLEXPRESS
servername\HPWJA
they are both there already in management studio, so not sure what your getting at here
ope this helps
June 23, 2009 at 12:20 am
Yes you need to have :
x64 version of SQLExpress 2008 and x64 version of OS .
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)
June 23, 2009 at 9:02 am
is there a 32bit setup possible,?
in my case
1 uninstall ss2005
2 uninstall sqlexpress 2008 (or upgrade?)
3 install 32bit enterprise/developer version of ss2008
????
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply