Jump to content

marshalleboc

Member
  • Posts

    1
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    Netherlands

Everything posted by marshalleboc

  1. Hello, I'm trying to query a SQL 2005 database/server using vbscript running windows PE 2.1 (Vista + SP1). If it works I can finaly use the database to lookup the computername for OS-deployment. I tried a lot of things but still get an Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' error. I know this is caused by the nature of windows PE which uses Local Anonymous account for network connections. The SQL server is a domain connected Microsoft SQL 2005 server. The log shows me : Logon Error: 18456, Severity: 14, State: 11. Logon Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: 1.2.3.4] This state means the login was valid but server access failed. For connction I use the following connection string : sConnectString = "Provider=SQLOLEDB;Data Source=servername;Initial Catalog=database;User ID=domain\username;Password=password;Integrated Security=SSPI" The user is a domain user. I tried this script on a domain connected windows (win 7) machine and it works, so the trouble is in the local anonymous user network connections. Does anybody knows how to solve this problem or an other smart secure way to query a ms sql database under windows PE 2.1 ? Thanks.
×
×
  • Create New...