Solved

MSDE installation and Network Path not found

Posted on 2004-04-22
3
381 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
3 Comments
 
LVL 4

Accepted Solution

by:
MajinLoki earned 125 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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now