Post reply

Need help connecting to SQL 2005 database

  • May 4, 2007 at 2:06 am

    #173246

    Hi,

    REALLY hope someone can help.

    I'm trying to upgrade our existing system to SQL 2005 but I can't get my VB.net 1.1 webservices to connect to my databases.

    The databases and webservices are on separate Windows server 2003 machines and I'm attempting to establish a trusted connection using TCP/IP kerberos authentication.

    I've set up the SQL box to use TCP/IP on the default port of 1433 and it seems to be listening quite happily.

    However, when I try and connect from my webservices I get the following error:

    "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'" which is logged as the following in the sql log:

    "Error: 18456, Severity: 14, State: 11."

    According the Windows event logs I'm successfully loging on to the sql server from my web server as a known windows user with Kerberos authentication, but it just doesn't instanciate a sql connection with sql.

    In order to try and remove anonymous logon I have the following in my webservices web.config files:

    <

    authentication mode="Windows" />

    <identity impersonate = "true" />

    <authorization>

    <deny users="?"/>

    </authorization>

    My sql connection string is as follows, with the server name including the full domain name:

     "Data Source=<DatabaseServerName>; Initial Catalog=<DatabaseName>; Trusted_Connection=true; Network Library=dbmssocn"

    It may also be worth pointing out that I'm using SqlClient.SqlDataAdapter as my connection object to try and connect to my database.

    I think it's a SQL 2005 problem because if I point my webservices at our current live sql 2000 database the connection works fine. If I change my connection string to use the sa account and password that connects fine to my 2005 databases.

    If anyone has any advice on what to try next I would really appreciate it.

    Thanks in advance

    Coll

  • May 4, 2007 at 11:02 am

    #704427

    Try the link below for how to fix your problem, post again if it is not resolved.  Hope this helps.

    http://blogs.msdn.com/sql_protocols/archive/2006/12/02/understanding-kerberos-and-ntlm-authentication-in-sql-server-connections.aspx

    Kind regards,
    Gift Peddie

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

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