September 17, 2003 at 11:42 am
Odd thing is hapenning with our IIS server and our SQL 2000 server.
We noticed that we were suddenly getting a lot of SQL-process locks, obviously from the database server. The locks multiplied very quickly and nothing that we could do would release the locks. Even logging in to Hthen database server ermione via PCAnywhere and then using Microsoft Enterprise Manager to execute very simple SQL statements (statements that should run in milliseconds) did not complete at all.
After restarting the database server, the webserver could not ‘see’ the database server at all. The error we were getting, from the webserver, was: “The server does not exist or access denied”. This is an OLE/ODBC error – i.e. there is no database to access!
Is this an MDAC issue? We are running 2.7 Refresh1. Or an application issue? Or something else?
September 17, 2003 at 12:02 pm
Is the database in EM?
I suspect someone changed something. Be sure the server network utility and client network utility match for access. Also, are these the same box?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 17, 2003 at 12:11 pm
No, they are on two separate machines. It's an intermittent issue. Can you explain 'network utility' and client utility' 'matching'?
September 17, 2003 at 12:37 pm
On the sql server, there is a server network utility that is in the MS SQL Server program group. Check that for the libraries that are running. Client Network Utility on the client if there are tools, otherwise this can be set for a DSN.
If it's intermittent, then it's likely a network problem. Can you see the SQL Server from a DSN on the webserver? Is there a firewall/router in between?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 17, 2003 at 12:47 pm
On Server Network Utility, we have the following libraries:
named pipes
tcp/ip
multiprotocol
nwlink ipx/spx
appletalk
banyan vines
via (qlogic)
September 17, 2003 at 1:19 pm
we don't use dsn.
client and server network util.ity report same protocol in use.
firewall and router are not 'inbetween' the servers - they are both behind them.
September 17, 2003 at 1:38 pm
Can you ping to SQL Server from IIS box? Any changes made to both servers? Make sure SQL Server is running.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply