Am new to web development, I recently installed visual studio 2010 while building my first website I try adding a database (visual basic) I keep getting this error.

I clicked on solution explorer, right click on App_Data, add new item, clicked on visual basic and sql server database. When I clicked on add. I get this error.

The error says "A network related or instance related 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 the sql server is configured to allowing remote connection. (Provider sql network interface : error 26 error locating server instance specified)"

Edited

Insufficient information. . . . .

ferdyferd:
Am new to web development, I recently installed visual studio 2010 while building my first website I try adding a database (visual basic) I keep getting this error

what does the error say? Do you have Sql server database (not sql compact database)

This is my connection strings setting

This is my server instance name "SQLEXPRESS"

basbone:


what does the error say? Do you have Sql server database (not sql compact database)

Yes I have sql server database. I have edited my first post its more explanatory now. Thank you

Also in my sql server configuration manager. My sql server refuse to start (not running) please see the screenshot below

The sql server state is "stopped " when I try to start it I get this error "Window could not start the sql server (SQLEXPRESS) on local computer. For more information review the system event log. If u
This is a non Microsoft service contact the service vendor and refer to the specific error code 17058"

Edited

This is my sql server settings bellow. While my built in account is "local system"

Please pardon d low quality in the images. And most importantly pardon my amateur description of the problem this is my first time. Thank you all for your assistance

Are you running sql server as an administrator?? And also, try to copy and paste the errors in text here(not screenshots)

basbone:
Are you running sql server as an administrator??
And also, try to copy and paste the errors in text here(not screenshots)

OK thanks. I have edited my post and typed the errors.

No am not running sql server as an administrator.

basbone
dhtml18

I have edited my post and typed the errors here. Hope this information is sufficient enough

basbone:


what does the error say? Do you have Sql server database (not sql compact database)

Yes I have sql server database. I have edited my first post its more explanatory now. Thank you

try to restart the server with admin account and ensure the server is running before connecting to it from visual studio.

Try the following:

1. try and run the service as an admin,
2. log in as admin and try restarting the service.
3. change the service status to local system OR Network service

Yeah, as the poster above me said. You can also start up visual studio as an administrator, and see if the problem is fixed.

your sql server could not be started so there is nothing you can unless you resolve that.

try restarting your system and check the configuration management whether the server is started automatically. if not, try starting it manually.

do these and give feedback

olarid01:
your sql server could not be started so there is nothing you can unless you resolve that.

try restarting your system and check the configuration management whether the server is started automatically. if not, try starting it manually.

do these and give feedback

restarted the system so many times. yes the server start mode is automatic.
I have changed it to manual, and try starting it manually still getting that error.

thanks

romme2u:
try to restart the server with admin account and ensure the server is running before connecting to it from visual studio.

Try the following:

1. try and run the service as an admin,
2. log in as admin and try restarting the service.
3. change the service status to local system OR Network service

I have done number 3. (local system, local service, network service) I have changed it to all 3 still getting the same error.

No 2: login as admin and try restarting the service. honestly I don't know how to do that.

No 1: I run SQL server configuration manager as admin, still the same error

thanks

basbone:
Yeah, as the poster above me said. You can also start up visual studio as an administrator, and see if the problem is fixed.

I have done that also still getting the same error in visual studio.

thanks

how do you perform the installations? which one did you installed first?

how do you perform the installations? which one did you installed first?
visual studio or sql server?

Anytime u find the error u got above, it is either the server is not running or the user account u are using does not have the require permission to access that server.

Remember: while troubleshooting the server, shutdown visual studio.

I have done number 3. (local system, local service, network service) I have changed it to all 3 still getting the same error.

Do this as an admin: then restart the system for it to take effect. u may need to run services.msc as admin

No 2: login as admin and try restarting the service. honestly I don't know how to do that.

concerning the No. 2, i meant, if u are not using an admin account on ur system, then logout and login with an admin account to be able effect the necessary changes.

No 1: I run SQL server configuration manager as admin, still the same error

Run the SQL server as admin[b]not[/b] the configuration manager.

if u cannot still access the server, run the SQL server, configuration manager and visual studio as administrator.

ferdyferd:
Am new to web development, I recently installed visual studio 2010 while building my first website I try adding a database (visual basic) I keep getting this error.
I clicked on solution explorer, right click on App_Data, add new item, clicked on visual basic and sql server database. When I clicked on add. I get this error.
The error says "A network related or instance related 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 the sql server is configured to allowing remote connection. (Provider sql network interface : error 26 error locating server instance specified)"
Edited

some apps like Skype do share ports with servers like mysql servers. try ensure its not having port conflict.

see the system logs, it would provide you more info on the error, looks like a port conflict or the sql server wasn't properly configured/installed

answer my question. how do you perform the installstions?

olarid01
godofbrowser
roome2u
and others who have contributed to this thread I say a big thank you.

I have resolved the issue. I downloaded a new sql server 2016 then I changed the instance name on VS to blank that did the trick.
thanks

ferdyferd:
olarid01
godofbrowser
roome2u
and others who have contributed to this thread I say a big thank you.

I have resolved the issue. I downloaded a new sql server 2016 then I changed the instance name on VS to blank that did the trick.
thanks

congrats!

This is very good @OP, now you have added a trick to your sleeve.

dhtml18:
This is very good @OP, now you have added a trick to your sleeve.

yes learning gradually...

@ OP: Re-installing didn't fix it but because you changed the named instance to a default instance. When next you have a named instance, you must specify the full instance name for a local connection or server path\Named Instance (IP address\Named Instance) for remote connection.

BlackMbakara1:
@ OP: Re-installing didn't fix it but because you changed the named instance to a default instance. When next you have a named instance, you must specify the full instance name for a local connection or server path\Named Instance (IP address\Named Instance) for remote connection.

Actually changed it to default instance didn't work, until I upgraded it from 2008 to 2016.

thanks got the new tip

BlackMbakara1:
@ OP: Re-installing didn't fix it but because you changed the named instance to a default instance. When next you have a named instance, you must specify the full instance name for a local connection or server path\Named Instance (IP address\Named Instance) for remote connection.

Actually changed it to default instance didn't work, until I upgraded it from 2008 to 2016.

thanks for the new tip