error 26

Hello
I'm trying to make a connection from Web developer 2005 express to a sql
database (sql server 2005 express), which has worked for me a dozen times
before but now I'm getting the error 26 message...error locating server. My
web site is file based on my computer. I'm unable to resolve this and move
forward.
My status is best describe as a Novice.
Chris
Hi Chris
On the server try using NET START or looking at the services applet under
the control panel to see if SQL Server is running.
If it is running, check that you can PING the server.
Try accessing the Server with SQLCMD or osql.
Check the Service Area Configuration Tool SQLSAC.exe to see that the
protocols are still enabled. You may also want to check SQL Server
Configuration Manager SQLServerManager.msc
If the server is responding to PINGS check that there are no firewall rules
that are blocking the SQL Server ports
http://support.microsoft.com/default...;en-us;287932, you could try
opening these ports with TELNET.
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris
|||Hi
You may also want to read:
http://support.microsoft.com/default...b;en-us;827422
and check out the SQL Server logs as well!
John
"ChrisCB" wrote:

> Hello
> I'm trying to make a connection from Web developer 2005 express to a sql
> database (sql server 2005 express), which has worked for me a dozen times
> before but now I'm getting the error 26 message...error locating server. My
> web site is file based on my computer. I'm unable to resolve this and move
> forward.
> My status is best describe as a Novice.
> Chris
|||John
Thanks, the SQL Server and SQL Server Browser were both stopped but are both
now running and I can access my SQL Database.
Many thanks for your directions.
Chris
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> You may also want to read:
> http://support.microsoft.com/default...b;en-us;827422
> and check out the SQL Server logs as well!
> John
>
> "ChrisCB" wrote: