Đang Thực Hiện

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.

Kỹ năng: ASP, Quản trị hệ thống

Xem thêm: 2147467259 sql express, sql express 2147467259, sqlexpress 08001, sql express 2005 fix, 2147467259 sqlexpress, up string, the string problem, string problems, string problem, services fix, password problems, my sql developer, my fix com, my fix, m string, microsoft access database developer, get sql server port, get my fix, fix the problems, fix the issue, fix services, fix my home, fix home services, local host sql, sql express 2005 denied asp

Về Bên Thuê:
( 59 nhận xét ) Rockwall, United States

Mã Dự Án: #44632

1 freelancer đang chào giá trung bình $30 cho công việc này

BilalNiaz

please see pmb. Bilal

$30 USD trong 1 ngày
(2 Đánh Giá)
4.4