SQLEXPRESS 2005 and OSQL Remote Connection Denied???

Posted on 2006-04-06
Last Modified: 2012-06-27
I have installed the SQLEXPRESS 2005 on my XP workstation and access it regularly thru the SQL2005 Management Studio.

I'm experimenting with my command prompt using OSQL -E (local)\SQLEXPRESS  which works through VS2005, however the connection does not work.

Q. Is there a way to change the Remote Connection properties through command prompt?

Q. Is there another way of installing through command-line so Remote Connection works?

I will be deploying the MS SQLEXPRESS on other workstations, so the initial install is critical........
Question by:kvnsdr
    LVL 9

    Expert Comment

    Did you enable TCP/IP when you installed SQL 2005 ?

    if not you can do so by setting the command line option when you install DISABLENETWORKPROTOCOLS=0
    LVL 1

    Author Comment

    Well, my mistake again. I did not include the -S flag like below:

    OSQL -E -S localhost\SQLEXPRESS
    LVL 9

    Expert Comment

    that is good, please close the question now

    Accepted Solution

    Closed, 250 points refunded.
    The Experts Exchange
    Community Support Moderator of all Ages

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now