Solved

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

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Join & Write a Comment

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…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now