SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 build version problem..please help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Yonkouturko
Yak Posting Veteran

Philippines
57 Posts

Posted - 06/25/2013 :  12:55:52  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 06/25/2013 :  14:15:58  Show Profile  Reply with Quote
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

Philippines
57 Posts

Posted - 06/25/2013 :  19:52:43  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/26/2013 :  03:14:34  Show Profile  Reply with Quote
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

Philippines
57 Posts

Posted - 06/26/2013 :  04:18:09  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/26/2013 :  04:22:39  Show Profile  Reply with Quote
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

Philippines
57 Posts

Posted - 06/26/2013 :  04:34:39  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/26/2013 :  04:42:02  Show Profile  Reply with Quote
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

Philippines
57 Posts

Posted - 06/26/2013 :  04:43:09  Show Profile  Reply with Quote
what exe??
Go to Top of Page

Yonkouturko
Yak Posting Veteran

Philippines
57 Posts

Posted - 06/26/2013 :  04:49:41  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/26/2013 :  05:27:50  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 06/26/2013 :  08:58:02  Show Profile  Reply with Quote
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

Philippines
57 Posts

Posted - 06/26/2013 :  21:16:31  Show Profile  Reply with Quote
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)

Singapore
17431 Posts

Posted - 06/26/2013 :  21:31:00  Show Profile  Reply with Quote
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
Time is always against us

Go to Top of Page

Yonkouturko
Yak Posting Veteran

Philippines
57 Posts

Posted - 06/26/2013 :  21:49:47  Show Profile  Reply with Quote
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)

Singapore
17431 Posts

Posted - 06/26/2013 :  22:00:47  Show Profile  Reply with Quote
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
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000