?
Solved

MSDE installation and Network Path not found

Posted on 2004-04-22
3
Medium Priority
?
399 Views
Last Modified: 2008-02-01


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
Comment
Question by:SangeetaV
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Accepted Solution

by:
MajinLoki earned 500 total points
ID: 10892689
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month12 days, 19 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question