Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Cannot connect to MSSQL on TCP 1433

Posted on 2009-07-10
8
Medium Priority
?
415 Views
Last Modified: 2015-01-05
osql -E fails, so then I tried to do telnet localhost 1433, and that fails as well.

No firewall in place.

A piece of custom software runs on this machine and is able to access MSSQL server.

My goal is to be able to run osql to do backups from a script.

How do I fix the osql / telnet 1433 connectivity problem?

Equipment: W2k3 SBS R2 Server (non-premium), SQL Server 2005 with Management Studio Express.
0
Comment
Question by:DrDamnit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
8 Comments
 
LVL 32

Author Comment

by:DrDamnit
ID: 24824260
Actual SQL Server Info:
Microsoft SQL Server Management Studio Express                                    9.00.2047.00
Microsoft Data Access Components (MDAC)                                    2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML                                    2.6 3.0 4.0 6.0
Microsoft Internet Explorer                                    6.0.3790.3959
Microsoft .NET Framework                                    2.0.50727.1433
Operating System                                    5.2.3790
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24824422
Hello DrDamnit,

Whats the Authentication ? if it is mixed mode, did u try it using
OSQL -u username -p password ?

Regards,

Aneesh
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24824443
I am not sure whether sql 2005 supports OSQL, you have to use sqlcmd utility
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 7

Expert Comment

by:wilje
ID: 24824763
If the is SQL Server 2005 Express - TCP/IP is disabled by default.  You have to go in an enable TCP/IP before you can use that protocol to connect.
0
 
LVL 32

Author Comment

by:DrDamnit
ID: 24825292
Mixed mode. Tried user / pass, no joy.
sqlcmd is giving me the same problem...probably because telnet cannot connect to it either.
wilje: Please confirm how I enable TCPIP.
0
 
LVL 18

Accepted Solution

by:
jmoss111 earned 2000 total points
ID: 24825930
hi Dr,

Why don't you just load up SQL Schedule from lazycoding.com and let that do your backups? It's a free scheduler and works great with SQL Express
0
 
LVL 18

Expert Comment

by:jmoss111
ID: 24825937
You enable TCPIP in Surface Configuration
0
 
LVL 7

Expert Comment

by:wilje
ID: 24826139
You use the surface area configuration tool - navigate to the network section and enable TCP/IP.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

715 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