June 11, 2005 at 7:22 am
Hi I've just registered here hoping that I can get help on a strange (at least to me) issue with SQL Server 2000
It had been working fine for a while on Windows 2003 Server, and when SP1 was installed some problems came up. First the server couldn't be accessed via internet (SQL Server does not exist or access denied), we had that problem fixed and it worked fine for a day, when we started getting the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'xxx' where xxx is any user that has any access to the database, however we are able to login into the database on the computer where it is installed, the problem is that the database cannot be accessed remotely via the internet, I would realy appreciate any suggestions and hints thanks
June 13, 2005 at 8:54 am
Hi Valentin,
When you say Internet do you mean Internet (via proxy) or Intranet (web access on the same network). Also, is user XXX an SQL standard login or Windows login? You have said that it was working for a day. Did something change? Maybe IIS admin changed authentication method?
Where is you application located? Please, describe briefly the architecture: where is the app, where is the web server, where is a database, where is a user, are you using the same machine for everything or they are different computers? What is the application? Classic ASP, ASP.NET or something else like Java or Perl
What I would do is to track the identity of the user that is trying to connect to SQL Server all the way from his browser to SQL Server and the submitted statements. I would run SQL Server Profiler first to audit failed logins, I would check Security Log in Event viewer, I would check IIS logs . Everything for the time up to the second when you try to run the app
Yelena
Regards,Yelena Varsha
June 21, 2005 at 9:20 am
Thak you Yelena.
I had it fixed, however for me it still remains a mystery how. Since it works now, and I am no longer responsible for the server itself, I'm leaving this issue behind
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply