Avatar of hpsuser
hpsuser
 asked on

How do I access SQL Server installation from another machine in my home network?

Hello,

I have a SQL Server 2005 installed on my LENOVO machine.  On the LENOVO, within Excel, I can write queries and pull data into Excel from SQL Server.

What I would like to be able to do is perform the same functionality within Excel, but from another machine (PAVILION) on my home network.  This PAVILION machine can access my wireless network already, and can see a shared folder I set up on the LENOVO.  

However, when I try the following in Excel (DATA -> GET EXTERNAL DATA -> FROM OTHER SOURCES -> SQL SERVER -> FROM SQL SERVER) and enter in the Server Name and User Name and Password I get an error message saying access is denied.  

The above test in Excel I mentioned that caused an error, that was on the PAVILION machine.  When I try the exact same thing from the LENOVO machine it works fine.

Any help would be greatly appreciated.

Thanks!
Microsoft SQL ServerNetworking

Avatar of undefined
Last Comment
hpsuser

8/22/2022 - Mon
Kent Dyer

Are you trying to create a new ODBC Connector?

If so..  You are going to need to create a new account to access your SQL server or use the sa account with a password.

HTH,

Kent
hpsuser

ASKER
Thanks Kent.  

When you ask if I am "trying to create a new ODBC Connector", I think the answer is yes (I am trying to connect to my database from a new machine on my home network.)

I have created a new USER/PASSWORD on my SQL Server, and have tested that it works from the machine that SQL Server is installed on.

What I cannot get to work is being able to access SQL Server from another machine, and I'm not sure what I need to do.

Please let me know what other info I can provide.

Thanks
ASKER CERTIFIED SOLUTION
Qlemo

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Dave Baldwin

The default is Windows Authentication which works fine on the same machine.  But for remote access you not only need to set up a user with SQL Authentication but you also have to enable TCP/IP access (if you are not in a domain that can provide Windows authentication).
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
hpsuser

ASKER
This worked great...I made the changes using the Surface Area Configuration Tool to use "TCP/IP and Named Pipes", restated a few SQL Server services, and now I am able to query from the SQL Server on the new machine when I was getting connections errors beforehand.

Thanks!