ansaurus

Question

Invalid authorization specification error with Classic ASP accessing SQL Server

Answer 1

A:

You did not specify what version of SQL server.

See this site for all the allowed connection strings - you will need to look at your version under the OLE DB driver.

Oded 2010-05-13 06:12:33

It is SQL Server 9.0.4053

Scott 2010-05-13 06:14:17

That appears to be SQL Server 2005

Scott 2010-05-13 06:14:56

Thank you for the link. I compared my connection string to their examples. The only item I was missing was Trusted_Connection=False; which I added. Unfortunately it did not change the result. I am still getting the same error.

Scott 2010-05-13 06:22:43

@Scott - can you connect to the server from SSMS? Where have you specified the connection string?

Oded 2010-05-13 06:31:00

Yes, I can use SSMS to connect using the same credentials. The connection string is specified in the code, I don't know what you mean by this latter question.

Scott 2010-05-13 06:34:10

@Scott - config file? What section? Directly in the code?

Oded 2010-05-13 06:37:16

@Scott - try creating a file DSN with these credentials (control panel -> Admin Tools -> Data Sources (ODBC)) and test it. Examine it and convert to a connection string.

Oded 2010-05-13 06:38:29

Try swapping from `SQLOLEDB` for the Native Provider by using `Provider=SQLNCLI10` or `Provider=SQLNCLI`

Alex K. 2010-05-13 11:08:12

Answer 2

A:

try with:

Provider=SQLOLEDB.1;Initial Catalog=fooDB;Data Source=xxxxx.db.12345.hostedresource.com;User ID=fooUser;Password=fooPW;Persist Security Info=True

Eduardo Molteni 2010-05-13 11:37:58

ansaurus

tags:

views:

answers:

Invalid authorization specification error with Classic ASP accessing SQL Server

related questions