Interview Question in Data Management


 

Interview Question :: I have installed Visual studio 2005 and management studio


I cant see the Microsoft sql server data source in change data source window...How to add microsoft sql server data provider in visual studio 2005?
Answers to "I have installed Visual studio 2005 and management studio"
RE: I have installed Visual studio 2005 and management studio?

Management Studio is different from the database engine itself. Mgmt studio gives u the necessary clients to connect to a DB engine and execute queries, design tables, etc.



If you haven't already, download the SQL Express DB engine from: http://www.microsoft.com/Sqlserver/2005/... , install it and (remembering ur 'sa' password if you specified one), connect to it with mgmt tools.



To confirm whether the DB engine is installed (if u think u have already) do the following:



1) Start > Run > Type 'services.msc'

2) Look for a service called SQL Server (SQLEXPRESS) or similar



If it's there then I'm wrong so tell me and I'll think of something else.
 
Vote for this answer ::  
Update Alert Setting