Solved

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

Posted on 2006-10-27
4
309 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

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

Scenerio: You have a server running Server 2003 and have applied a retail pack of Terminal Server Licenses.  You want to change servers or your server has crashed and you need to reapply the Terminal Server Licenses. When you enter the 16-digit lic…
While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

690 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