Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

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

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
tstrobel491
Asked:
tstrobel491
1 Solution
 
PatG042800Commented:
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
 
tstrobel491Author Commented:
We upgraded from MS SQL SP3 to MS SQL SP4 to resolve this issue
0
 
Computer101Commented:
PAQed with points refunded (250)

Computer101
EE Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now