SQL Express - Named Pipes Provider Error - Support, Bugz & Troubleshooting

Welcome Guest

Search | Active Topics | Members | Log In | Register

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » SQL Express - Named Pipes Provider Error

SQL Express - Named Pipes Provider Error

Options

Previous Topic · Next Topic

thingythingz

Posted: Monday, December 15, 2008 10:51:15 AM

Rank: Newbie
Groups: Member

Joined: 7/29/2008
Posts: 3
Points: 9
Location: Australia

Hi Guys,

I don't believe this is versaSRS HelpDesk problem, but more of a MS SQL Express issue, but hope you can assist.

After installing versaSRS, with no errors or issues, when trying to launch http://localhost/versasrs, I get a connection error that ends with;

"(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

This error is also shown in the versaSRS-SMC when connecting to the database (so I know its a database issue as the versaSRS HelpDesk application is not even involved at this point Drool

)

BTW - the database is SQL Express 2005 (and also does same wth 2008).

Cheers

Philip@versadev

Posted: Monday, December 15, 2008 11:09:45 AM

Rank: Administration
Groups: Administration , Member

Joined: 11/20/2008
Posts: 47
Points: 44
Location: Australia

Hi,

When you install SQL Server 2005, sometimes remote connection are not allowed by default.

To correct this, please launch SQL Server Configuration Manager. Select tree "SQL Serve 2005 Network Configuration -> Protocols for MSSQLSERVER" and enable "Shared Memory", "Named Pipes" and "TCP/IP".

Under "SQL Native Client Configuration -> Client Protocols", enable which are available.

Hope this solves your problem

Cheers,

Philip

Chean

Posted: Monday, December 15, 2008 11:15:45 AM

Rank: Administration
Groups: Administration , Member

Joined: 5/5/2008
Posts: 5
Points: 15
Location: Adelaide, Australia

Hi

By default, the versaSRS connection string is configured to connect to "localhost" as your default database server.

If you installed SQL Express 2005 or 2008 with default configuration, connecting to localhost will NOT work and will get the similar error as above.

To correct this, please make sure you connect to the database server in the following format; [SERVER_NAME]\SQLExpress. Where [SERVER_NAME] should be replaced with your actual server / pc name.

Cheers

Chean

Chean Phu
Senior Software Architect

VersaDev Group
www.versadev.com

134 Gilbert Street
Adelaide, South Australia, 5000
Tel: +61 8 8463 1914
Fax: +61 8 8212 8447
Sales: sales@versadev.com
Support: support@versadev.com

Australia : Singapore : India :
United Kingdom : Belgium :
United States : Venezuela

Users browsing this topic

Guest

VersaDev Community Forum » versaSRS » Support, Bugz & Troubleshooting » SQL Express - Named Pipes Provider Error

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.