Invalid authorization specification error with Classic ASP accessing SQL Server

Posted by Scott on Stack Overflow See other posts from Stack Overflow or by Scott
Published on 2010-05-13T06:04:46Z Indexed on 2010/05/13 7:24 UTC
Read the original article Hit count: 263

Filed under:

asp-classic

|

sql-server

Hi,

I am getting the following error: Invalid authorization specification

I've narrowed down the error to my connection string. I have verified the server name, database, user & password are correct. Here is the string:

"Provider=SQLOLEDB;Server=xxxxx.db.12345.hostedresource.com;Database=foo;UID=fooUser;PWD=fooPW"

The SQL server is hosted on Godaddy so I don't have access to its settings.

Please help, I've scoured the internet for a solution!

© Stack Overflow or respective owner

Related posts about asp-classic

Looping through an array and calling a function on each pass in v-basic / asp classic

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I loop through an array and call a function on each pass? At the minute I'm trying the following... if Request.Form("authorize") <> "" then dim post_ids, ids post_ids = Request.form("authorize") ids = split(post_ids, ",") For i = LBound(ids) to UBound(ids) … >>> More
ASP Classic Session Variable Not Always Getting Set

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a classic ASP site I'm maintaining and recently we wanted to do special rendering actions if the visitor was coming from one specific set of websites. So in the page where those visitors have to come through to get to our site, I put a simple line setting a session variable: <!-- #include… >>> More
ASP Classic page quit working

as seen on Stack Overflow - Search for 'Stack Overflow'
I've had a set of legacy pages running on my IIS7 server for at least a year. Sometime last week something changed and now this line: Response.Write CStr(myRS(0).name) & "=" & Cstr(myRS(0).value) which used to return nothing more exciting than the string: 'Updated=true' (the sproc processing… >>> More
in visual studio 2008, when I stop debugging an asp classic website visual studio always crashes

as seen on Stack Overflow - Search for 'Stack Overflow'
We are running visual studio 2008 (with the service pack) and having troubles when we are debugging an asp classic website. We can attach to the w3p process and debug just fine. breakpoints work, we can view variable values. The difficulty arises when it comes time to detach or stop the debugger… >>> More
HTML to PDF conversion from hosted ASP classic?

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to convert HTML to PDF on the fly from a hosted ASP classic page. WkHtmlToPDF is great, but unfortunately requires installation on the server which is not possible in this case. Is there something out there that would do this? >>> More

Related posts about sql-server

SQL SERVER – Beginning SQL Server: One Step at a Time – SQL Server Magazine

as seen on SQL Authority - Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time. My association with SQL Server Magazine has been quite long, I have written nearly… >>> More
How to install SQL Server 2005 Configuration Manager without installing SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
Hi, I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager. I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't… >>> More
[MAJ] SQL Server 2005 Express Edition - La version gratuite de SQL Server 2005

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Modification technique pour le site de l'article. >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
sql server 2000 error, error trying to connect to sql server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error: When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections What… >>> More