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

Windows 2003 - SQL Server does not exist or access denied

P: n/a
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
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

Any clues will be greatly appreciated.


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

P: n/a
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!


Nov 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.