Monday, February 20, 2012

Looking for how to for SQLexpress

I recently installed SQL express on my winXP machine at home... Installed
and configured IIS as requested. I have created a simple table for testing
but cannot establish a DSN connection using either SQL or SQL Native driver
It mentioned something about allowing remote connections, but that feature
is turned on.. so not sure what else i need to configure to allow me to
connect so i can start testing some things out..
any sites or even books i can take a look at to complete this would be
great.
Hi Daniel
"Daniel" wrote:

> I recently installed SQL express on my winXP machine at home... Installed
> and configured IIS as requested. I have created a simple table for testing
> but cannot establish a DSN connection using either SQL or SQL Native driver
> It mentioned something about allowing remote connections, but that feature
> is turned on.. so not sure what else i need to configure to allow me to
> connect so i can start testing some things out..
> any sites or even books i can take a look at to complete this would be
> great.
>
A remote connection should only be needed if you are trying to access your
SQL Express instance from another machine. It can be changed by using the the
Surface Area Configuration Tool SQLSAC.exe see previous post
http://tinyurl.com/23dum6 for links on this.
John
|||I figured as much... when i installed it i took all the defaults and didnt
change anything.. but i will try this later tonight...
thanks for the reply.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:75A3F905-C157-4283-A407-3DA7BA72A7D7@.microsoft.com...
> Hi Daniel
> "Daniel" wrote:
> A remote connection should only be needed if you are trying to access your
> SQL Express instance from another machine. It can be changed by using the
> the
> Surface Area Configuration Tool SQLSAC.exe see previous post
> http://tinyurl.com/23dum6 for links on this.
> John

No comments:

Post a Comment