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

Connecting to MS SQL Server without SQL Client

Hi,
I have MS SQL Server installed on Server Machine.  Also, I have Toad for SQL Server on client machine.
My question is: Can I connect to MS SQL Server from SQL Toad?

Thanks In Advance
0
ajexpert
Asked:
ajexpert
  • 3
  • 3
  • 2
  • +1
3 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
yes, that should be possible. is there any problem?
0
 
ajexpertAuthor Commented:
Yes.
Please find the attached screen shot
SQLTOADERR.doc
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
this seems to be the problem that you sql server is not allowing remote connections, which is the default in sql 2005.
please check the configuration tool in sql 2005 on the server to allow remote connections.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
grayeCommented:
If this is SQL Server Express, the "Server Name" should have "\SQLEXPRESS" tacked onto the end
0
 
ajexpertAuthor Commented:
Hi,
Its SQL Server Enterprise Edition.
I get this error
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
0
 
St3veMaxCommented:
Start - > Programs -> SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration

Configuration for Services & Connections

Expand Database Name
Remote Connections

Enable 'Local & Remote using TCP/IP Only'

Click OK.

Job Done!
0
 
ajexpertAuthor Commented:
I have already done that.

But still the same error
0
 
St3veMaxCommented:
Have you restarted the service?
0
 
St3veMaxCommented:
Thinking about - Can you create an ODBC connection from any machine and access the server? Just wondering if it's a server or application issue ?
0
 
grayeCommented:
So, what's the deal about installing the SQL drivers anyway...     I'd recommend that you at least temporarily install the SQL Client parts to see if that solves the problem.   The results of that test will determine where we should be concentrating our efforts
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

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