• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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