• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 851
  • Last Modified:

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........
0
kvnsdr
Asked:
kvnsdr
  • 2
1 Solution
 
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
 
GranModCommented:
Closed, 250 points refunded.
GranMod
The Experts Exchange
Community Support Moderator of all Ages
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now