I installed SQL Server CTP version and tried to connect from Command Prompt, but failed from either osql or sqlcmd:
osql [/sqlcmd] -H localhost -E
or,
osql [/sqlcmd] -H localhost -U sa -P SAPWD
The error message is:
Named Pipes Provider: Could not open a connection to SQL Server, ...
Please note named pipes are enabled from client protocol configuration.
without Management studio, how can I connect to the server
Thanks.
PS: I had searched in the forum, but didn't find answer to above question.
Connect to SQL Server from Command Prompt?
Hot Topic
- How to move Tasks between packages
- SQL Server 2005 Express June CTP Setup Error
- Report Header
- Update part of a string
- Easiest way to start and read a trace from within a SSIS package
- how do i get date into dd-mm-yy format??
- Does not have permission to register endpoint
- Database tables etc vanishing?
- Can I copy cube from other project to my current project by using XMLA?
- Selecting multiple values for a parameter
SQL Server
- Scope defined on Member Properties
- Validate Subscriptions, turn it off
- Meta Data Management / Dependancy Analysis
- Unable to install SQL Server 2005 Standard
- Schema Changes between RS 2000 and RS 2005
- Task converting xls files to csv files ?
- How to design Data Warehouse for Traditional OLTP System
- backup of existing Reports and restore on new server
- Overloaded Stored Procedure
- Decryption Question
Connect to SQL Server from Command Prompt?
Shadow Listener
Aman Dhingra
sqlcmd -S (local) -E sqlcmd -S (local)\SQL01 -E
For a windows authenticated connection to the default instance on the local machine you don't need any parameters for sqlcmd e.g
sqlcmd
JustKuzya
After a few attempts, I found the following command works:
osql (or sqlcmd) -S .\SQLEXPRESS -E
without instance name, it always timed out.