[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

MSDE installation and Network Path not found



I downloaded MSDE installation sql2kdesksp3.exe from http://www.microsoft.com/downloads/details.aspx?FamilyId=90DCD52C-0488-4E46-AFBF-ACACE5369FA3&displaylang=en
 and installed it using command line:
Setup.exe INSTANCENAME=NETSDK  SAPWD=sa

And after that I installed Northwind Database and other sample databses using ConfigSamples.exe  that comes with .Net.
SQL Service Manager icon on the system tray shows: Not Connected - \\. If I double-click it, it shows Service Manager, I tried connecting using A\NETSDK (A is my computer name) as server, it tries to connect but gives error "Network path not found".  Though in Visual Studio.net- Server Explorer I could register  A\NETSDK SQL Server instance and it lists all the databases  but when I try to add a new stored procedure in Northwind Databse I get error saying "The Operation could not be completed".

My question is:
1) How can I start  Sql Server

Operating system: Windows XP Professional.
0
SangeetaV
Asked:
SangeetaV
1 Solution
 
MajinLokiCommented:
When you boot your machine you should see an icon in the taskbar.  It looks like a computer tower with a little symbol in a white circle in the lower right corner.  Right click on this icon.

You should see the SQL Server Service Manager.  Choose SQL sever in the second dropdown box.  Check the box that says Auto-start service when OS starts.  Now, start the service by clicking the Start/Continue button.

Do the same for the SQL Server Agent.

Click the X in the upper right corner.

That should do it.

MajinLoki
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now