asked on

one user cannot connect to sql server; can ping server

One of my network logins has lost his ability to connect to the SQL Server. Cannot create an ODBC connection. I am using SQL Authentication so the network login shouldn't matter. If someone else is logged on to this workstation, the connection works fine (still SQL Authentication).

The bad login can still Ping the SQL server.

The ODBC connection is using port 1433. Telnet to 1433 works fine.

Any ideas? Is MDAC user or workstation specific?

thanks

bonnie

nmcdermaid

Is that person a member of a group that has login rights to the SQL Server.

You should see the windows login (or a group that that person is a member of) under

Server / Security / Logins

in Enterprise Manager

If that all looks good, try running Profilfer with all the security audit events on and see what that says about the particular user.

bonniemckee

ASKER

thanks for the reply.

Yes, the person (officer2) is logging in using a SQL login name (svcreq). I'll try the Profiler

thanks

bonnie

bonniemckee

ASKER

the profiler shows a "Login line" with a bunch of setting set on/off in the text data. then a "Logout line" with 17 reads and the rest of the fields blank ok 0

How can just one specifid Windows login not be allowed to get to SQL Server with a totally different SQL Server login?? Other Windows logins can log in to SQL just fine with that same SQL login.

thanks

bonnie

ASKER CERTIFIED SOLUTION

nmcdermaid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bonniemckee

ASKER

turns out the problem was overzealous "web surf control"

thanks

nmcdermaid

Its curious that the TELNET worked in that case but I'm glad you got it solved.