Post reply

What do I do when the SQL server says access denied?

  • January 4, 2008 at 10:51 am

    #377890

    While trying to log on to the network, the I received the notice "Could not connect to lansync server database. Error is: SQL Server access denied"

    what does it take to permit a user access on the SQL server?

  • January 4, 2008 at 11:42 am

    #764938

    It could be related to a number of different issues. I would suggest to first see if the server is listening for incoming TCP connections on 1433. Open a command prompt and type:

    telnet lansync 1433

    If you get a blank window, good. If not start troubleshooting protocols, see BOL for more information.

    Are you a member of the local administrators group on the lansync server? Is the local administrator group a member of the SA role? Using Vista (see vista prov tool in SP2/BOL).

    Good luck 🙂

    Tommy

    Follow @sqlscribe

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply