Hi, I'm using some aplications that use ODBC to connect the aplications with the database in a windows 2003 SQL server.

The problem is that when the users try to see the reports there is a runtime error. The person who programmed the aplications says that it works prefectly with computers outside the domain using a XP Computer as a server.

I wonder if the restrictions that the users have are not allowing them to access the databse and the ODBC without problems.

If I use in administrator account it is working fine.When I want to access in active directory user i am adding odbc database i am unable to connect server.It is giving error.Access is denied.Even though if i give administrator prevelious for that user.I am unable to access.

I really could use some help in this matter. Thanks.

Thanks in advanced

Is the machine hosting the SQL Server on the Domain?

Life's more painless for the brainless.

Thanks for replay

Yes

No problem in administrator mode.Only problem in user.Unable to connect odbc database.

Error Message

Microsoft SQL Server login

Connection failed:
SQLstate: '01000'
SQLserver Error: 10054
[Microsoft][odbc sql server driver[Tcp/IP sockets]ConnectionRead (recv()).
Connection failed:
SQL State: '08So1'
SQL Server Error: 11
[Microsoft][odbc sql server driver][Tcp/IP sockets]General network error. check your network documentation.

Thanks in advanced