SQL server 2000 connectivity issue

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL server 2000 connectivity issue

Author

Topic

matt_damon
Starting Member

7 Posts

Posted - 2007-08-27 : 09:19:31

hi everybody...
I got a connectivity issue with Sql server .Net application.
I can access Sqlserver which located at server through Query Analyser,
Enterprise Manager, Windows application. But when I create a web application(asp.net) and try to connect it to sqlserver,
it gives an error.. "SQL SERVER DOESNT EXIST OR ACCESS DENIED"
I think its some connectivity issue.. But cant rectify it..
I hope some1 out there can help me..
One morething.. It was working fine till 2days back..Yest morninig when I tried to run d web application, it showed the error...
This is the reason why I think the issue is with connectivity and not with the code.
Pls help....................................

mverma82
Starting Member

5 Posts

Posted - 2007-08-27 : 11:04:12

Do you have more than one instance of sql server on same server (like sql serve 2000 or 2005 ) ?

Manish

nheidorn
Starting Member

28 Posts

Posted - 2007-08-27 : 16:44:33

Here's a Microsoft kb article that has helped me in the past:

http://support.microsoft.com/kb/328306/en-us

In our case, it was the MaxUserPort and TcpTimedWaitDelay setting that was causing the problem:

http://support.microsoft.com/kb/328476/en-us

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-27 : 21:56:47

What's connection string in your web app?

matt_damon
Starting Member

7 Posts

Posted - 2007-08-28 : 03:20:21

mverma82
No.. I use only Sql Server 2000

nheidorn
Thanks.. Lemme check it out...

rmiao
Connection string is defined in web.config file..
<add key="interConn" value="User ID=sa;Password=;Initial Catalog=iLink;Data Source=SQLSERVER"/>

nheidorn
Starting Member

28 Posts

Posted - 2007-08-28 : 17:46:38

You might not have mixed mode security enabled. Check the Security tab of the SQL Server Properties dialog in Enterprise Manager. It needs to be set to "SQL Server and Windows" instead of "Windows Only" for that connection string to work.

As an aside, using an sa login for a web app is asking for big trouble down the road. Much less an sa login without a password. I would plan on changing that before you go live.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-28 : 21:49:11

Did you specify sql instance in connection string?

matt_damon
Starting Member

7 Posts

Posted - 2007-08-29 : 07:04:33

Yes i did...

quote:
Originally posted by rmiao

Did you specify sql instance in connection string?

matt_damon
Starting Member

7 Posts

Posted - 2007-08-29 : 07:07:14

No.. Its having Mixed mode security enabled.
Yeah i noe d trouble in using sa login.. But it is an inhouse server.
So I dont bother much abt it now...

quote:
Originally posted by nheidorn

You might not have mixed mode security enabled. Check the Security tab of the SQL Server Properties dialog in Enterprise Manager. It needs to be set to "SQL Server and Windows" instead of "Windows Only" for that connection string to work.

As an aside, using an sa login for a web app is asking for big trouble down the road. Much less an sa login without a password. I would plan on changing that before you go live.

matt_damon
Starting Member

7 Posts

Posted - 2007-08-30 : 04:05:43

Please... Somebody help me... I cant find a solution for it anywhere...

quote:
Originally posted by matt_damon

hi everybody...
I got a connectivity issue with Sql server .Net application.
I can access Sqlserver which located at server through Query Analyser,
Enterprise Manager, Windows application. But when I create a web application(asp.net) and try to connect it to sqlserver,
it gives an error.. "SQL SERVER DOESNT EXIST OR ACCESS DENIED"
I think its some connectivity issue.. But cant rectify it..
I hope some1 out there can help me..
One morething.. It was working fine till 2days back..Yest morninig when I tried to run d web application, it showed the error...
This is the reason why I think the issue is with connectivity and not with the code.
Pls help....................................

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-31 : 00:33:43

Can you connect to sql serever with odbc on that machine? Any firewall between them?

matt_damon
Starting Member

7 Posts

Posted - 2007-09-02 : 07:14:14

ya... I can create ODBC.. I can work on crystal reports without any problem.. only problem comes when I use web application...
No firewall...

quote:
Originally posted by rmiao

Can you connect to sql serever with odbc on that machine? Any firewall between them?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-02 : 17:49:20

What's your connection string look like in web app?

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-04 : 15:31:17

very useful link
http://www.connectionstrings.com/

HTH

--------------------
keeping it simple...

matt_damon
Starting Member

7 Posts

Posted - 2007-09-06 : 09:45:05

THANKS A LOT GUYS FOR UR RESPONSES..
I COULD SOLVE THE PROBLEM WITH THE HELP OF MY FRIEND..
SINCE MY SQLSERVER 2000 WAS OF SP1, IT GAVE SOME CONNECTIVITY ISSUE..
I RAN THE LATEST SP N NOW ITS WORKING FINE..

WILL BE BACK SOON WITH ANOTHER ISSUE...(HOPEFULLY!!!!)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources