En cours

SQL Express 2005 Fix Connectivity Issue

I have a connection string that works from my home computer, but not form another server. I got a new hosted server mainly just ot host SQL 2005 express.

Would like to move my data there, but I'm connectivity problems from my other servers.

I have set up a database, it works fine and I can connect remotely using 2005 SQL Server Mgt Studio (Developer Edition) on my notebook and using VB/Script and via VB/Script running on my local computer. I can see the data and update it. I have attached “Surface Area Config”.

But when accessing from an ASP application (or VB/Script) on a different hosted server I have a problem.

[url removed, login to view]

- You can try different connection strings here.

I have tried several variations of this connection string, including the port 1433

Provider=SQLOLEDB;User Id=test;password=test;Initial Catalog=Students;Data

Source=[url removed, login to view]

Getting this error:

Error No: -2147467259

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

Source: Microsoft OLE DB Provider for SQL Server

SQLState: 08001

NativeError: 17

Of course, both hosting services claim it is not their problem. I have full admin rights and remote desktop to both hosted servers.

I have posted to Microsoft forums, no response. I'm willing to pay to get this fixed so I can get rid of a monthly server fee.

This project is based on success, if you take the project and cannot fix the problem, no pay.

Compétences : ASP, Administration Système

Voir plus : 2147467259 sql express, sql express 2147467259, sqlexpress 08001, sql express 2005 fix, 2147467259 sqlexpress, up string, string problems, string problem, services fix, my fix, m string, microsoft access database developer, get sql server port, get fix, fix services, fix home, fix home services, local host sql, 2147467259 dbnetlib 2005 express, 2147467259 sql, connect sqlexpress vbscript, fixd error 2147467259 dbnetlib, error 2147467259 sql express, vbscript sql express 2005, error 2147467259 dbnetlib

Concernant l'employeur :
( 59 commentaires ) Rockwall, United States

N° du projet : #44632

1 freelance a fait une offre moyenne de 30 $ pour ce travail

BilalNiaz

please see pmb. Bilal

30 $ USD en 1 jour
(2 Commentaires)
4.4