Solved

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

Posted on 2007-04-03
6
1,177 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 

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 250 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

726 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