Solved

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

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

So you have two Windows Servers and you have a directory/folder/files on one that you'd like to mirror to the other?  You don't really want to deal with DFS or a 3rd party solution like Doubletake. You can use Robocopy from the Windows Server 200…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.

856 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