Thanks for the reply.

From MS Access 2007 and ODBC setup I get the same error:

Connection failed
SQL state 01000
SQL error 2
SQL state 08001
SQL error 17

By "S.M. Studio Express" I meant SQL Server Management Studio Express
I'm able to use this utility to create a new DB and tables- so it's there
and running on this PC
Andrew, I tried to use SQL Server 10 and 6 years ago, and had the same kind
of issues; I couldn't connect, got frustrated
and went on to use open source tools.

I'd love to get it working and thanks for your help -








"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://msdn2.microsoft.com/en-us/library/ms345154.aspx Express Overview
http://msdn2.microsoft.com/en-us/library/bb264564.aspx User Instances
http://msdn2.microsoft.com/en-us/library/ms345318.aspx Tutorial on
connecting
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/ar...05/415084.aspx
Configuring Remote Access
http://www.kbalertz.com/Feedback_914277.aspx Configuring SQL2005 for
remote access
http://msdn2.microsoft.com/en-us/library/bb264562.aspx Embedding Express in
Apps
http://www.microsoft.com/downloads/d...DisplayLang=en
SSMS Express
http://blogs.msdn.com/rogerwolterblo...13/575974.aspx
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"barret bonden" <support (AT) networks-cc (DOT) com> wrote