| Author |
Topic |
|
redbrad0
Posting Yak Master
176 Posts |
 Posted - 2005-10-14 : 13:52:05
|
| I have a stranger problem going on. I have two windows 2000 servers one that host's websites and the other is a SQL Server. Everything has been running fine with nothing changed all of a sudden I am starting to get...[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.every 2-3 mins then it starts working again. If I restart both server's it fixes it for a couple hours. Any idea what could be going on?Quality NT Web Hosting & Design |
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-10-14 : 14:33:09
|
| Also on a side note that might have something to do is the site is very slow to respond. The web server sits around maybe 5% CPU & the SQL Server is sitting around 15% CPU Usage.Quality NT Web Hosting & Design |
 |
|
|
anuj164
Starting Member
49 Posts |
Posted - 2005-10-14 : 15:19:48
|
| Check for memomry leak; and SQL Server CPU and memory utilization. I rememver we had the same issue a way back .. and it was because of memory leak. You should also monitor the network traffic. |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-10-14 : 15:38:01
|
| How can I tell about memory leaks? I was watching the packets and how long it was taking and everything seemed normal.Quality NT Web Hosting & Design |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-14 : 16:18:06
|
| SQL Server shouldn't have any memory leaks as long as you are at least running sp3. In fact, the last memory leak that I recall was sp1 for SQL Server 7.0.But anyway, you can probably easily correct this problem if you setup an alias on the web server that explicitly states the db server's IP address and port number. You can do this via Client Network Utility (which you can get to if you setup a test DSN in ODBC Administrator) or via regedit.exe.Tara |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-10-14 : 16:35:16
|
| Tara,It is odd because this just started happening and been running smooth for awhile now. I am connecting right to the IP Address thru my ASP Pages so wouldnt setting up a Alias be the same thing? Here is what I use to connect...driver={SQL Server};server=111.111.111.111;uid=USERNAME;pwd=PASSWORD;database=DATABASEBradQuality NT Web Hosting & Design |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-14 : 16:43:17
|
| An alias would also include the port number, which is missing from your connection string. I believe you can include it though. I just can't remember if it's a comma or a colon after the IP address. If the connection string/alias thing doesn't work, then you'll need to look at why the web server is unable to connect to the SQL Server (which is what the error is). It could be that the web server is too slow with the connection, DNS issues, or other general network problems. Oh and one other thing, your error message is showing that you are using Named Pipes. You should be using TCP/IP. This can be corrected in the alias.Tara |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-10-14 : 17:06:47
|
| Ok I did the following... I opened SQL Server Client Network Utility and clicked on the Alias tab. I clicked and and said the Server alias is "ezsql" then the Network libraries was put on "TCP/IP" and the Server name I put the IP Address of the SQL Server. I unselected the "Dynamically determine port" and set it to 1433. The site is still very slow to load 15 seconds when it used to load in 1 sec. I even tried with Dynamically configure port checked and same response. Below is the new SQL String I am using...driver={SQL Server};server=ezsql;uid=USERNAME;pwd=PASSWORD;database=DATABASEQuality NT Web Hosting & Design |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-14 : 17:13:50
|
| Adding an alias or changing anything like this isn't going to change the speed of your site. It should help alleviate the error that you are getting.Tara |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-10-14 : 17:36:30
|
| You'll need to determine where the problem is by running SQL Profiler and Perfmon on the database server and Perfmon on the web server. You'll need to capture various performance counters to determine if you have any hardware bottlenecks. In SQL Profiler, you'd be interested in the slowest performing queries and trying to resolve those.Tara |
|
|
|
redbrad0
Posting Yak Master
176 Posts |
Posted - 2005-10-14 : 17:49:02
|
| Well I first checked and both drives need defragmenting as they looked pretty bad so that is running right now. Do you see that causing this problem or should I keep looping?Quality NT Web Hosting & Design |
|
|
|
himraj13
Starting Member
1 Post |
Posted - 2005-10-20 : 07:50:03
|
| guys, Discussion is goin in different way. the point is we are getting this error :[DBNETLIB]SQL Server does not exist or access denied.and now i'm also a victim so guys plz help me out.i've not changed anything in server. i got .net 1.1 and ms sql 2000 "developer edition" on one pc. now the problem is i'm not able to login in sql server using command line. i dont know what to do.if any of u has the solution plz do post |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2005-10-20 : 09:11:29
|
| When the problem comes up again, you could try to have a continuous ping from the client server to teh SQL Server, just to test the raw network layer. It could boil down to a loose network cable, a flaky NIC, or almost anything at that level.I take it that there are no clues in the SQL Server errorlog? |
|
|
|
|
Sql2K: SQL Server does not exist or access denied.