Set oRSz = Server.CreateObject("ADODB.RecordSet")ĥ.Are there any suggestions on how to solve this problem? I do not want to use AUTHORITY\ANONYMOUS to connect to the SQL server which if I added to the logins of the SQL server 2008 the page works just fine. Set oConn = Server.CreateObject("ADODB.Connection")
#Odbc driver for sql server 10.00.17763 code#
Nothing fancy, plain vanilla code as you can see by the following VBScript section of a page: I belong to the administrator group of the domain and I have administrator rights on both SQL Servers.Ĥ.The pages that connect to the database were created using regular ASP/ADO and VBScript. Source: Microsoft OLE DB Provider for ODBC Driversģ.The servers are located in the same domain. using the SQL Management Studio.Ģ.I go to Server 1 and change the ODBC connection to point to the new location (Server 2) and I get the following error when I try to access the database thru Internet Explorer on my PC.ĭescription: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I can access the data in both servers without any problem and run all store procedures, etc., etc. Here it is the change I am trying to accomplish:ġ.A moved the database from Server 1 (SQL 2000) to Server 2 (SQL 2008). Even thought, I installed IIS in this server, I do not use it for anything else but Reporting Services. Windows Server 2008 (Datacenter), SQL Server 2008. Download Microsoft ODBC Driver 17 for SQL Server - Windows, Linux y macOS from Official Microsoft Download Center Internet Explorer 11 se retir el 15 de junio de 2022 Si visitas un sitio que requiere Internet Explorer (IE), puedes volver a cargarlo con el modo IE en el nuevo navegador Microsoft Edge. IIS, ODBC and SQL server are using Windows authentication (Anonymous is disable in the IIS.) The ODBC verify the authenticity of the login ID with Windows NT authentication using the network login ID. An ODBC connection is used to connect the pages on the IIS to the database in SQL. Windows Server 2003 with IIS and SQL Server 2000 running together. Here you have a better description of the problem: Maybe I did not explain myself very clear.
0 kommentar(er)
