Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2014
    Posts
    3

    Unanswered: sql server express connection over network problem

    Alert me
    |
    Edit
    |
    Delete
    |
    Change type
    Question
    You cannot vote on your own post
    0

    I have just installed SQL Server Express on a windows 8.1 pro machine and migrated my access db to it.

    I have an application written in VB .Net which works perfectly when run on the computer with SQL Server on it. (the app was written to work with both access and sql server)

    however, when i go to another computer where i have a mapped drive to the computer with the SQL server on it and i run the application from that mapped drive i get this error:

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

    My connection string is

    Provider=sqloledb;Data Source=ANTEC\SQLEXPRESS;Initial Catalog=CATSSQL;TRUSTED_CONNECTION=Yes;

    i know it can be done as it works at other places with the same setup.

    i have checked the things like TCP/IP and Name Pipe is enabled. sql server browser is running, windows firewall is set to allow the incoming connections etc.

    obviously the server machine is visible to the client as the mapped drive works fine.

    any help would be appreciated.

    thanks

  2. #2
    Join Date
    Nov 2014
    Posts
    3

    sql server express connection over network problem

    I have just installed SQL Server Express on a windows 8.1 pro machine and migrated my access db to it.

    I have an application written in VB .Net which works perfectly when run on the computer with SQL Server on it. (the app was written to work with both access and sql server)

    however, when i go to another computer where i have a mapped drive to the computer with the SQL server on it and i run the application from that mapped drive i get this error:

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

    My connection string is

    Provider=sqloledb;Data Source=ANTEC\SQLEXPRESS;Initial Catalog=CATSSQL;TRUSTED_CONNECTION=Yes;

    i know it can be done as it works at other places with the same setup.

    i have checked the things like TCP/IP and Name Pipe is enabled. sql server browser is running, windows firewall is set to allow the incoming connections etc.

    obviously the server machine is visible to the client as the mapped drive works fine.

    any help would be appreciated.

    thanks

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The drive mapping is not needed for SQL Server. SQL Server actually listens on a network port (You will need to make sure the SQL Server services is running, and probably the SQL Browser service as well). You are probably facing a network configuration problem. By default, SQL Express is configured with no network access. On the machine running SQL Server Express, open SQL Server Configuration Manager, and enable the TCP network protocol for the instance you have installed. Once that is done, you may need to open ports on the firewalls of both machines.

  4. #4
    Join Date
    Nov 2014
    Posts
    3
    Quote Originally Posted by MCrowley View Post
    The drive mapping is not needed for SQL Server. SQL Server actually listens on a network port (You will need to make sure the SQL Server services is running, and probably the SQL Browser service as well). You are probably facing a network configuration problem. By default, SQL Express is configured with no network access. On the machine running SQL Server Express, open SQL Server Configuration Manager, and enable the TCP network protocol for the instance you have installed. Once that is done, you may need to open ports on the firewalls of both machines.
    i have done all of the above.

    the mapped network drive is done as the software is run from that drive on the server, so it is required. tcp/ip is on, firewall is allowing connections, named pipes is on remote connections are allowed.

    its very strange

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As MCrowley pointed out, you'll need to open port 1434 and whichever port the ANTEC\SQLEXPRESS instance is using on every router/switch/etc. between your client and your service machines.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •