none
server is not configured for data access error

    Question

  • Hi all, Im relativly new to SQL Server so this may  be a bit of a dumb question.

    I have a user who originally was getting the error "could not find server in sys.servers...." when they were trying to delete a record.

    So I ran select * from sys.servers and sure enough it was not listed

    then

    sp_addserver 'SERVER'

    they are no longer receiving the could not find server error however they are receiving the server is not configured for data access error. 

    What is confusing to me is that this user can log into the database and query for data, just not delete any data.

    I am completely stumped as to what is causing this. Not to mention The servers name isn't even 'server' its 'iO' and the ODBC connection is configured properly.

    any help would be greatly appreciated

    Thanks!

    EDIT: the client is running SQL Server 2005
    Wednesday, November 19, 2008 4:36 PM

Answers

All replies