How do I open the SQL server 2008 successfully....?

Question

1.33/5 (2 votes)

See more:

After Formatting My Laptop i just installed sql server 2008 but when i open it, it shows an error that "A network related or instance specific error occured..."

What I have tried:

To resolve this i start all the SQL services...And trying to stop windows firewall service but unable to stop this service and open SQL server 2008...
plzz help...
Thanks in Advance...

Posted 6-Sep-18 0:30am

Mohan Ghawade

Updated 6-Sep-18 5:08am

Add a Solution

Comments

CHill60 6-Sep-18 7:51am

Things to try
1. Perform a disk check e.g. as described at Perform Disk Check on Windows 10[^]

2. Reinstall SQL Server 2008 (New versions are available free of charge is this is for your own use)

3. Reinstall SQL Server Management Studio

4. Stopping your firewall service would leave your PC vulnerable to attack - I don't know why you would want to do that. Most firewalls allow you to configure them for specific requirements.

By "when i open it" I presume you mean SQL Server Management Studio. Is this before or after you have connected to a database?

Mohan Ghawade 6-Sep-18 13:48pm

I just installed SQL Server 2008......

[no name] 6-Sep-18 8:33am

If you have successfully installed SQL server there may be chance that SQL services are not up and causing you this error. Refer below URL to validate this scenario -

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/start-stop-pause-resume-restart-sql-server-services?view=sql-server-2017

Mohan Ghawade 6-Sep-18 13:49pm

All SQL services are running except SQL server agent because that is not supported by express edition...

Mohan Ghawade 6-Sep-18 13:57pm

SQl server agent is not running...Beacuse of that this error occured...??

CHill60 6-Sep-18 14:27pm

I doubt that is the cause - I don't have that service running either

CHill60 6-Sep-18 11:15am

Another piece of advice - remove your email from your user name - this is an open site that could be targetted by spam bots

Mohan Ghawade 6-Sep-18 13:50pm

ok...Thank you ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 13640486 · Answer 1 · 2018-09-06T05:08:00

Solution 1

try
check the old username and passwords used For SQL connection and your new password and username in sql string if any change occur replace with new one
you can find SQLConnection in Web.config file

Posted 6-Sep-18 5:08am

Member 13640486

Comments

CHill60 6-Sep-18 11:14am

I would have thought that Incorrect username/password would result in a message indicating that the wrong username or password had been used, not "A network related or instance specific error occured..."

Mohan Ghawade 6-Sep-18 13:55pm

Sorry but i don't have old username and password...