[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

I can only access MS SQL server by localhost and need to access by IP

Posted on 2006-10-27
4
Medium Priority
?
322 Views
Last Modified: 2012-08-14
I have MS SQL server setup on a W2003 box, and I can only setup an OCBC driver on the server to access via localhost. If I setup an ODBC driver on the server using the server name, or server IP address, I receive access denyed. I need to be able to access the ms sql server with an odbc connection via the server name or server ip address. The server works fine sharing files by the server name.
0
Comment
Question by:tstrobel491
[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
4 Comments
 
LVL 8

Expert Comment

by:PatG042800
ID: 17833190
Are you using Windows authentication or SQL Server authentication?
Has the user been granted access to the database you are trying to connect to?
0
 

Author Comment

by:tstrobel491
ID: 17838821
We upgraded from MS SQL SP3 to MS SQL SP4 to resolve this issue
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 18016090
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

649 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