Hi Matt,

Thank you so much for your advice... whilst it wasn't what I really wanted to hear, it woke me up and made perfect sense.

Kinda strange why the hosting company...

Yes, exactly - from my machine to a dedicated web server that has MS SQL Server 2005 installed.

When you say "local admin ports being blocked"... I'm presuming the hosting...

Ok interesting - here's the last two log entries. I tried connecting first with a user I created (I changed the name here for security reasons!). Secondly I...

Hi Matt

I guess you're referring to the original connection error for "login failed"? The "state" is always a '1' with a "severity" 14:-

Server Name: xx.xxx.xxx.x

Error Number: 18456

Severity: 14

State: 1

Line...

Hi Tommy

Ok, I did that and the results are in a table:

Dedicated Admin Connection112TCP2TSQL0STARTED1

TSQL Local Machine214SHARED_MEMORY2TSQL0STARTED0

TSQL Named Pipes313NAMED_PIPES2TSQL0STARTED0

TSQL Default TCP412TCP2TSQL0STARTED0

TSQL Default VIA515VIA2TSQL0STARTED0

Hi Marios

Ok, I'll give that a shot, and see what happens!

Hi Tommy

I'm using SQL Server 2005 Developer Edition... remote connections are enabled and have been for some time.

Ok, so how do I create local DSN using 'named pipes' to the server. I tried, going to Admin Tools - Data Sources (ODBC) -> Add DSN -...

Yup - I agree, I was hoping for some help here after all, not some unnecessary thoughtless comment.

Harsh yes. I can see how eyebrows might be raised at the question, and I might come across as a bit of a newbie. I am new to...