unable to open Sql server 2008

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi
i could not open my sql server 2008(local database).

When i click on connect->database engine -> user name -> password ->connect

It throws an error as
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)"

can any one please help me to resolve this issue.

Thanks in advance.

Posted 1-Apr-14 0:59am

Appdev(Icode)

Add a Solution

4 solutions

Solution 1

Basically, it is saying "I can't find any SQL server where you told me"

So, try setting up a connection in VS with the Server Explorer pane:
1) Open Server Explorer.
2) Right click "Data connections" and select "Add connection"
3) In the dialog that follows, select your DataSource, and database, specify the security info, and press the "Test connection" button.
4) When the connection works, press "OK"
5) Highlight your database in the Server Explorer pane, and look at the Properties pane. A working example of the connection string will be shown, which you can copy and paste into your app or config file.
The dialogs should allow you to browse to the specific instance you want and then you can enter your name and password. (I find it a little easier than the SSMS version)

Posted 1-Apr-14 1:06am

OriginalGriff

Comments

[no name] 1-Apr-14 7:11am

In the server explorer of VS it doesn't listing my server name.
whats surprising is till morning it was worked quite but dont know suddenly what happens?
And FYI i also unable to open database in sql server 2008 also

OriginalGriff 1-Apr-14 7:36am

That kinda answers your question really , doesn't it: someone turned the server off, or unplugged it's LAN connection.

I assume this is a LAN server, rather than on your own PC?
If it's on your development PC, then it's probably the service has not started for some reason - easily fixed.

[no name] 1-Apr-14 7:13am

i have 1 doubt is there any relation ship between administrator password and sql server because morning i changed my admin password.

[no name] 1-Apr-14 7:39am

My problem is in my service there is no sqlexpress to start it....i don't know suddenly what happens because till morning it works fine so i assume that once i changed my pc admin password it got hide

OriginalGriff 1-Apr-14 7:54am

Try this:
Click the Start button, and type "local services"
You should get a Control Panel applet of that name - start it.
In the "Extended" tab of the right hand pane, scroll down to SQL Server
Check that SQL SERVER(yourinstancename), SQL Server Agent, and SQL Server Browser are all started.
If not, right the click the instance and try starting it.

[no name] 1-Apr-14 8:17am

That only i'm saying , in that "Extended" tab i couldn't see any of my SQL instance. Nothing is there which represents SQL.

OriginalGriff 1-Apr-14 8:39am

Are you sure you got the right PC? :laugh:
Or more to the point are you the right user? Did you install SQL server for a single user or all users?

[no name] 1-Apr-14 8:42am

hey dude till today morning it works fine....i'm facing this issue from noon only...that too i guess that i changed my pc administrator password around 11 pm...after that ony this issue its just my assumption but i'm not sure....should i reinstall????

OriginalGriff 1-Apr-14 10:27am

Check which user you are logged in as: it you changed the admin password, you might be logged in as admin, and SQL installed only for your user?

Solution 2

Duplicate : A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.[^]

Posted 1-Apr-14 1:10am

CodeReady

Solution 3

SQL

it says your server name is incorrect.

try this :
1) click servername combo box.
2) browse for more.
3) expand the database engine from browse for servers window.
4) choose your server name
5) hit on connect

Posted 1-Apr-14 1:10am

King Fisher

Comments

[no name] 1-Apr-14 7:13am

I checked every thing....i have 1 doubt is there any relation ship between administrator password and sql server because morning i changed my admin password.

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)

Appdev(Icode) · Accepted Answer · 2014-04-01T02:56:00

Solution 4

Hi thanks for all who showed interest on my question.

I reinstalled sql server 2008.now it was working fine.Don't know what causes the issue in sql server but finally i re-installed.

Posted 1-Apr-14 2:56am

Appdev(Icode)

Updated 1-Apr-14 2:57am

v2