• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 273
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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