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
LVL 14
ajexpertAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.