Author |
Topic |
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-25 : 12:55:52
|
i have 2comp...both 64bit win7 ultimate w/ vs2010 ultimate ive install on both pc the same software...now my problem is the sql server 2008 r2 gas different build versions one is version 9 the other was 10 how would i upgrade the version 9 to version 10? |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-25 : 14:15:58
|
I have not seen a build version 9 (but that does not of course, mean that it is not there). Where are you seeing the version 9 and version 10? |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-25 : 19:52:43
|
ill put it this way ive installed a vs2010 that includes a sql server 2005 then i install(upgrade) it to 2008 r2 but when i run sql 2008 r2..the version im still using is 2005(i dont really know how it happen but its true) if anyone has any idea about this pls help me out |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 03:14:34
|
ive installed a vs2010 that includes a sql server 2005do you mean compact edition? vs installation doesnt contain sql 2005------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 04:18:09
|
ohh sorry... visakh16... beforehand i have installed vs2005(and upgraded to vs2010) that has sql server 2005 and then i installed a new instance of sql server 2008 r2...which i think override the instance of sql server 2005 versionand now... sql server 2005(build # or version # 9.0.1399) is running on sql server 2008 r2...i really don't know how.. and why...please help.... (i hope you understand my story... and i hope it makes any sense) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 04:22:39
|
I dont understand you. SQL Server and vs are different installables. so didnt understand what you mean by vs2005(and upgraded to vs2010) that has sql server 2005 Did you mean BIDS projects in vs?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 04:34:39
|
ok ok ... maybe im really twisting things a bit... sorry for this inconvenience..so you mean... sql server is not included in any Visual Studio... but how does it happen that it produces a folder "MICROSOFT SQL SERVER 2005" with a folder named "CONFIGURATION TOOLS" inside the config folder theres 3 items "SQL Server Configuration Manager","SQL Server Error and Usage Reporting" and last one is "SQL Server Surface Area Configuration"....im sorry about this topic please have patience to me in clearing things... im so grateful your all there...to help out |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 04:42:02
|
can you point me link from which you got the exe?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 04:43:09
|
what exe?? |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 04:49:41
|
if my current installer is what you been talking about( SQLManagementStudio_x86_ENU -name of my installer)... i really don't know where i downloaded this because its been with me for i guess a year...i've look at my control panel search for installed programs i've noticed that there are 2 SQL server installed one is SQL SERVER 2005 and the other is SQL SERVER 2008 r2...whats boggling me is that why SQL 2005 is running on SQL erSERVER 2008 r2... and i don't see any sql SERVER 2005 Exe at all for me to use it and access database,tables etc... even before i install sql server 2008 r2 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-26 : 05:27:50
|
SQLManagementStudio_x86_ENU is the installatable for sql server so i guess what you were referring as VS was actually BIDS (business Intelligence Development Studio).And reading your second statement i think you've two instances of sql server installed (sql 2005 and sql server 2008 r2). So depending on which one you installed first one will be deafult instance and other named instance. if thats the case you can use sql management studio of 2008 r2 to connect to both. Use machine name as the server name for default instance and use machine name\instance name for the named instance.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-26 : 08:58:02
|
SQL Server Management Studio (or Business Intelligence Studio) is separate from SQL Server itself. To see what servers you have installed, Start-> Run -> services.msc. Then look for entress like "SQL Server(MSSQLSERVER)", "SQL Server(SQLExpress)" etc. That is, the word SQL Server followed by something in brackets. If you don't see any such entrees at all, you don't have the server installed on your box. SQL Server(MSSQLSERVER) is what they call default instance. Assuming it shows as "running" in services.msc, you can connect to that instance using SSMS and specifying the computername (or . or local). Any other instance, you will need to explicitly specify the instance name, for example YourComputerName\SQLExpress. |
|
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 21:16:31
|
would it be possible that sql server 2005 and sql server 2008 r2 have different GUI? or its in SSMS...and how would i access it separately? just like i would use 2005 or 2008 r2 (hence we can differentiate it by build #) |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
Yonkouturko
Yak Posting Veteran
59 Posts |
Posted - 2013-06-26 : 21:49:47
|
that's visual studio 2005... but the problem is i can't open the GUI for sql server 2005 thats comes with visual studio 2005... |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|