By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,598 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Windows 2003 - SQL Server does not exist or access denied

P: n/a
ssp
G'Day All,

I have a web application sitting on my laptop and a Sql Server 2000
database on our INTRANET server running Windows 2003. Up until recently
I was able to access the database using my application. But recently it
started to give me the error as below:
****************
SQL Server does not exist or access denied.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does
not exist or access denied.

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection (Boolean&
isInTransaction) +484

System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString
options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
RingtonesComponents.Data.ViewCat1() in C:\dev\xxx\Data.cs:371
RingtonesCMS.Grab.AddCat1.Page_Load(Object sender, EventArgs e) in
C:\dev\xxx\cms\Grab\AddCat1.ascx.cs:33
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +750

****************

I have the following connection string in web.config file:

****************
<add key="sqlConnection1.ConnectionString" value="workstation
id=SUVPR;packet size=4096;user id=sa;data source=INTRANET;persist
security info=True;initial catalog=ringtones;password=xxx" />
****************

I am completely baffled by the situation.

I can access the INTRANET database using the Enterprise Manager on my
machine.

Any clues will be greatly appreciated.

SSP

Nov 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ssp
Found the solution... A very odd one though. Someone from Microsoft
should better explain this. Infact the problem and the solution is not
an ASP.NET one at all.

Well, what I did was change the TCP/IP Port from 1433 to 1096.
Restarted the Sql Server and ran my application. Still had the "Access
Denied" error. So I decided to revert to Port 1433 and restart the Sql
Server. I ran the application and it worked like a charm.

A complete fluke!

SSP.

Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.