Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 build version problem..please help

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?
Go to Top of Page

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
Go to Top of Page

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 2005

do you mean compact edition? vs installation doesnt contain sql 2005

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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 version
and 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)
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

Yonkouturko
Yak Posting Veteran

59 Posts

Posted - 2013-06-26 : 04:43:09
what exe??
Go to Top of Page

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
Go to Top of Page

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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

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.
Go to Top of Page

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 #)
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-06-26 : 21:31:00
if not mistaken, Visual Studio comes with SQL Server Express edition

You must have Express 2005 (version 9). For a later version of SQL Server Express, you can go for 2008R2 or 2012

Microsoft® SQL Server® 2008 R2 SP2 - Express Edition http://www.microsoft.com/en-sg/download/details.aspx?id=30438
Microsoft® SQL Server® 2012 Express http://www.microsoft.com/en-sg/download/details.aspx?id=29062


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

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...
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2013-06-26 : 22:00:47
Not sure what GUI you are referring to .. if it is the SQL Server Management Studio, you can try this

Microsoft SQL Server Management Studio Express


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -