Problem connecting to a SQL Express Database

[Amida]

Hi Guys

I've been recking my brain trying to connect a Webmonitor application to a SQL Express database.

The problem I'm having is I can connect with SQL Studio Management Express to the database with the login in details but trying to get the Webmonitor application to connect with the same details and the same computer doesn't work.

I keep getting the following error:

DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I've googled around but nothing I've tried works.

My problem is if SSME can connect why can't the application?

 

[Deenem]

By default SQL Express doesn't listen on TCP or Named Pipes, it only listens on the the local connection.

To connect to it over a network you go into the Configuration Manager and enable the Named Pipe and TCP protocols.

 

[Amida]

By default SQL Express doesn't listen on TCP or Named Pipes, it only listens on the the local connection.

To connect to it over a network you go into the Configuration Manager and enable the Named Pipe and TCP protocols.

I have followed a tutorial to enable it for remote connections and I can connect remotely with SSMSE with the same details from the same computer.

 

[Amida]

What authentication mode is your SQL Server set up as Windows/Mixed Mode?

What Webmonitor application are you trying to get to connect? this one or something you've writted yourself.

Also SQL Server express doesn't allow for remote connections, have you tried putting in localhost for the server name in the settings where you configure your connection?

EDIT: Just saw Deenem's post, not sure if it doesn't allow remote connections or you have to configure it. I've never worked with the Express Edition I just know this is an issue.

Hi Dequadin

I've changed the Authentication to Mixed mode for windows and sql authentication.

The application I'm trying to connect with is GFI Webmonitor they have released a freeware version.

 

[Amida]

Hmmm, what firewall are you running? Maybe as a test, turn off your firewall (third party and windows) and see if it works.

Also try your sa user, you could have SQL permission issues...

basically how it works is I have a ISA 2006 server which has the webmonitoring software installed now I'm trying to connect the webmonitoring software to another server on the LAN which runs SQL Express.

Firstly I couldn't even connect with SSMSE then after some tracing I figured out the ISA was blocking the requests so I allowed all the correct ports. Then SSMSE could connect. so I know the connection is working. I've also checked the SQL server and the firewall is disabled.

I've tried the sa account and that also gives the exact same error message.

Any other ideas?

Thanks for the help so far.

 

[Amida]

Okay I'm out of ideas

Just check that your SQL Server is set up correctly to accept remote connections, look here, here and here

Has a quick skim through the second link check this out:


That bit in bold could be your problem as the SSMSE probably knows about that, but the webmonitor doesn't...

Thanks will check out the links.

So you think I should configure a static port for the SQL server and then try to connect to it.

 

[Amida]

Dequadin you are a star turning the dynamic ports of and configuring a static port solved the problem.

Thanks very much!

 

[FarligOpptreden]

Also SQL Server express doesn't allow for remote connections, have you tried putting in localhost for the server name in the settings where you configure your connection?

Just read this thread now... I would've given you some flak for that statement if I jumped in right after that post!