April 21, 2008 at 6:10 am
I have installed MS Visual Studio 2005 to do .net tutorials.My friends suggest me to be strong in back end database.So I thought of working SQL Server turorails.My question is whether VS.net 2005 is enough to practice sql server tutorials by adding database to windows application or I should separately install SQL Server 2005.Is it true that if I go ahead to install SQL Server seperately,I should uninstall VS.net 2005?Please help me.
April 21, 2008 at 6:16 am
[font="Courier New"]Gopi,
I hope VS2005 setup accompanies SQL server 2005 Express edition, hence you can install the same from VS2005 setup. If you can't find it there, you can refer the below link to download the same.
http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41[/font]
Regards..Vidhya Sagar
SQL-Articles
April 21, 2008 at 9:42 am
will this install sql server separately otherthan one in vs.net?
April 21, 2008 at 10:12 am
You will need to install sql server seperately from vs.net, it does not matter what order you install them in.
Do you currently have acces to a sql server, and want to install management studio locally?
or are you looking at installing SQL server 2005 completly on a server?
April 22, 2008 at 12:07 am
Iam working on my home pc.VS.Net 2005 is installed.I want to work in sql server separately, so I found tutorials where were done using management studio.The link is
http://www.functionx.com/sqlserver/Lesson01.htm
The database connection inside vs.net 2005 doesnt have many functionalities I think,like query analyzer etc.So I thought of installing sql server 2005 completely in my system as given in that tutorial.Now what to do do,Please help me
April 22, 2008 at 2:16 am
unless you have SQL server avilaible to you either locally or over a network on a server, you will not be able to use it in VS.net.
the basic functionalitly is similar in Vs.net and most developers i know design tables and write procs in VS.net.
But it cant hurt to intall SSMS if you have access to it, as you can do a lot more advanced and important things in it , like indexes, replication and lots more...
April 22, 2008 at 2:29 am
SSMS=SQL Server 2005?.Can you tell me any link for trail software.I downloaded SQLEVAL for 2 times but it says it is corrupted when i run it.When I read the documentation it says, I should uninstall VS.Net 2005, .Net framework before installing SQL Server 2005.Iam confused.
April 22, 2008 at 3:03 am
SSMS = sql server management studio, it is the client side for sql server.
sql server should be run off a server , though you can run it locally.
If you are just learning, i recommend downloading a copy of sql server express, as this will have all the funcitonality that you need and is free from microsoft.
April 22, 2008 at 3:47 am
Steve Thanks for your patience.
I did it previously, my start menu shows MS SQL Server 2005-Configuration tools-sql server configuration manager,sql server error and usage reporting,sql server surface area configuration, Reporting services configuration.
I dont know why enterprise manager,query analyzer,service manager are not installed.
One more question whats the difference between "when we take right click to our project and create new item as sql database(in vb.net)" and database created sql server outside vs.net.
Thanks once again
April 22, 2008 at 4:03 am
Okay it sounds like you have installed the server tools locally, you need to run the install again and select management studio client tools to install on your client computer.
do you have a server avialable for Sql server, or are you do you need to install in as a local instance?
you can create sql objects from a number of front end tools, VS.net , SSMS, they all send t-sql to the server which creates the objects. so there is not really any difference in how you create them.
April 22, 2008 at 4:28 am
I think I didnt install server on this system.How to do that.I ran the set up for sql server express edition.When I run the set up again after selecting all the services like Database services,Reporting Services,Client Components->connectivity components,software development kit,management studio express and click next+next+next,it says "None of the selected features can be installed
April 22, 2008 at 4:31 am
I think I didnt install server on this system.How to do that.I ran the set up for sql server express edition.When I run the set up again after selecting all the services like Database services,Reporting Services,Client Components->connectivity components,software development kit,management studio express and click next+next+next,it says "None of the selected features can be installed or upgraded.Setup cannot proceed since no effective change is being made to the machine.To continue click back and select features to install.To exit sql server setup,click cancel"
how to do now,I understand we should have server installed in this system and front end tool can be anything like vs.net, management studio,or any other thing.
Only VS.net is not enough?
December 13, 2008 at 12:12 pm
i am also getting same error , can u help how did u solve that problem.....
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply