SQLEXPRESS 2005 and OSQL Remote Connection Denied???

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........
LVL 1
kvnsdrAsked:
Who is Participating?
 
GranModCommented:
Closed, 250 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0
 
raopsnCommented:
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
0
 
kvnsdrAuthor Commented:
Well, my mistake again. I did not include the -S flag like below:

OSQL -E -S localhost\SQLEXPRESS
0
 
raopsnCommented:
that is good, please close the question now
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.