?
Solved

SQL Server Does Not Allow Remote Connections When Using sqlcmd on Local Machine

Posted on 2007-04-03
6
Medium Priority
?
1,189 Views
Last Modified: 2012-06-27
I am trying to backup databases in SQL 2005 Express on SBS 2K3 SP1, which doesn't have the SQL Agent. I am attempting to access the database directly from the server it is installed on. I want to use a batch file to access the database and run the backup T-SQL command, but it tells me the SQL server does not allow remote connections. I have verified that remote connections was enabled in the Surface Area Configuration, and also double-checked that the SQL Server Browser process is running. I am pretty sure that the server has been rebooted since those settings were enabled. I have tried using sqlcmd and osql, but neither is successful. Actually, osql gives me doesn't exist or access denied errors. Any help would be greatly appreciated.

Biziteks
0
Comment
Question by:Biziteks
[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
6 Comments
 
LVL 4

Expert Comment

by:davidsperling
ID: 18843770
Guess you've read a similar instruction like this:
http://www.datamasker.com/SSE2005_NetworkCfg.htm

For me it didn't work until I checked "Using both TCP/IP and named pipes" in surfice area configurator. -And rebooted, I guess.

(My problem was that I couldn't connect from visual studio. Using sqlserver2k5 express.)
 
0
 

Author Comment

by:Biziteks
ID: 18843792
Yeah, I did see that article and a couple other ones, including a KB from Microsoft, I think. The option for both was already checked when I went in Surface Area Configuration. If all else fails I will reboot the server tonight for kicks and giggles, and hopefully fix this. Any additional suggestions are always welcome.

Biziteks
0
 
LVL 42

Expert Comment

by:dqmq
ID: 18843797
The remote connections message is a red herring. You are simply not passing the correct server name or do not have the right permissions.

Try using '.' to identify the server when connecting or append /SqlExpress to the real server name.
0
Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

 

Author Comment

by:Biziteks
ID: 18843964
When I use Management Studio, I see <servername>\<databasename> in the Server name field. I can login this way using either sa or Windows Authentication. I have given the Windows domain user (also a domain admin acct) access to all the Server Roles and went in User Mapping and selected the user to have all roles for the db. I still cannot get it to run.

An error that I missed earlier pops up before the remote connections error and reads: HResult 0x15, Level 16, State 1  Encryption not supported on the client.

Biziteks
0
 
LVL 5

Expert Comment

by:nakul_vachhrajani
ID: 18846317
Try installing latest version of the SQL 2005 feature pack - that will give you support for osql commands (however, I doubt they will be of much help on SQL 2005 Express).
0
 
LVL 3

Accepted Solution

by:
abhijit_k earned 1000 total points
ID: 19417991
Go to Start-Control Panel-Administrative TOOLs-Component Services
Right CLick and go to Security Configuration and Check the Boxes allow inbound Connections
0

Featured Post

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

765 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