"Too many requests being handled for user" error while accessing Report Manager

Hi,
When I try to access Report Manager(http://<reportserver>/Reports) I'm
getting the following error message:
"There are currently too many requests being handled for user:
[DOMAIN]\[USER]. Please wait until the current requests have finished
processing before issuing any more."
However there are no problems when I try to access the Report
Server(http://<reportserver>/ReportServer).
Has anyone encountered a similar situation before?
Thanks.
RamkiRestarting IIS resolves the issue. Increasing the
"MaxActiveReqForOneUser" in RSReportServer.config from its default of
20 might also be an option.
Ramki

"Syntax error or access violation" with new (July 22 2003) driver

Hi,
I'm having troubles with the SQL Server ODBC driver 2000.81.9001.40 dated on
July 22 2003. It is incompatible with our custom application developed with
Centura SQLWindows/32 Version 1.5.1-PFT2. When running some queries, the
error message reported by the driver is
Error No: 20035
Error Text: [Microsoft][ODBC SQL Server Driver]Syntax error or access
violation
The only suspicious fact is that the command is broken by a CR-LF (new line)
combination. This code had worked for years without any problem, sending
such broken line commands
The SQL command sent is:
{call spEjeSelectRem ('vCtePedTem_ChecaPoliticas
20,20,159,1,935502,17700024,1200148,null,
1')}
Note there is a new-line sequence behind the last parameter
My questions are:
Can It be the cause of the above mentioned error?
Wat can I do, install the previous version?
The ODBC driver is dated July 22 2003. It was automatically downloaded by
Microsoft Automatic Update. How can I protect specifically from ODBC driver
version updates?
Thanks in advance
FaustinoOk,
I did the following:
-"Uninstall" MDAC by
dasetup.exe /u
(actually the uninstall procedure didn't work, but at least it leave the
ODBC in such inconsistent state that I could install a previous version)
-Installed the MDAC v.2.7 that I had before the bug appeared. The bug didn't
appear again.
However yesterday the Microsoft Update suggested to install the security
patch 823718 related to MDAC. I crossed my fingers and applied it. No
problem. SQL Server driver is now 2000.81.9041.40 and the bug didn't show
again.
Hope this helps somebody
Faustino
"faustino Dina" <fdina@.matusa.com.mx> wrote in message
news:eo%23$lJ%23aDHA.2016@.TK2MSFTNGP10.phx.gbl...
> Hi,
> I'm having troubles with the SQL Server ODBC driver 2000.81.9001.40 dated
on
> July 22 2003. It is incompatible with our custom application developed
with
> Centura SQLWindows/32 Version 1.5.1-PFT2. When running some queries, the
> error message reported by the driver is
> Error No: 20035
> Error Text: [Microsoft][ODBC SQL Server Driver]Syntax error or access
> violation
> The only suspicious fact is that the command is broken by a CR-LF (new
line)
> combination. This code had worked for years without any problem, sending
> such broken line commands
> The SQL command sent is:
> {call spEjeSelectRem ('vCtePedTem_ChecaPoliticas
> 20,20,159,1,935502,17700024,1200148,null,
> 1')}
> Note there is a new-line sequence behind the last parameter
> My questions are:
> Can It be the cause of the above mentioned error?
> Wat can I do, install the previous version?
> The ODBC driver is dated July 22 2003. It was automatically downloaded by
> Microsoft Automatic Update. How can I protect specifically from ODBC
driver
> version updates?
> Thanks in advance
> Faustino
>

"SQL: The Complete Reference" source?

I purchased a used copy of the SQL book listed in the subject but the
CD is missing. I have access to SQL Server 2000 and so don't need the
trial software but would like to get the source for the database used
in the examples. Does anyone know where I can get this?What's the name of the sample database used in the examples?
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
"SteveH" <steve.holle@.gmail.com> wrote in message
news:1139507451.169408.5450@.f14g2000cwb.googlegroups.com...
>I purchased a used copy of the SQL book listed in the subject but the
> CD is missing. I have access to SQL Server 2000 and so don't need the
> trial software but would like to get the source for the database used
> in the examples. Does anyone know where I can get this?
>|||SteveH wrote:
> I purchased a used copy of the SQL book listed in the subject but the
> CD is missing. I have access to SQL Server 2000 and so don't need the
> trial software but would like to get the source for the database used
> in the examples. Does anyone know where I can get this?
Have you checked the publisher's web site. Many publishers post the
source code from books. Also, you might try the author's home page (if
you have it), which may have some information as well.
--
David Gugick - SQL Server MVP
Quest Software

"SQL Server does not exist or access denied." after installing XP SP2

Hi!

I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.

I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.

I'm trying to connect with trusted_connection.

Can you guys help me out?Try this Microsoft KB article:

http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,

Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,

no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.

"SQL Server does not exist or access denied", again...

I'm have that darn problem...

Here is our setup:

Remote clustered SQL Server 2000 running on a Windows Server 2003 Enterprise Edition box.

Local IIS 5.1 web server (my development box) running on Windows XP Tablet Edition.

I'm using Visual Studio.Net 2003 and using ASP.Net 1.1.4322.

I have an ASP.Net application that hits the remote SQL Server. When I'm on my development box and viewing my ASP.Net project locally via IE, the application retrieves values from the remote SQL Server with no problems. If I get onto another machine, launch IE, and then hit my development box's web server (which is running the asp.net app), I get the dreaded "SQL Server does not exist or access is denied" msg.

In my ASP.Net app, I have impersonate set to true and the website is set only to windows authentication. The remote SQL Server is set to SQL and Windows authentication.

I'm at a loss on what to do, any help would be greatly appreciated.

Thanks,

ExitusLSU

Hi,

This seems to be firewall issue.
Check it after disabling firewall.
http://bhatiaworld.blogspot.com/2005/12/dot-net-error-aspnet-website-or-web.html|||

I also forgot to mention my connection string. It is:

"Data Source=<server name>;Integrated Security=SSPI;Initial Catalog=<database name>"

I've tried using the IP address, but that didn't work.

Thanks,

ExitusLSU

"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?
I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"SQL Server does not exist or access denied" error when trying to connect from a Windows S

Hi!

I understand that this topic is one of the most discussed topics ever. However i could not find the relevant information after going through (almost) all the posts so far. Hence this post.

I am getting the 'SQL Server does not exist or access denied' error when I am trying to access SQL Server from a WINDOWS SERVICE. SQL Server and the Windows service are running on two different machines. (When they are on the same machine, it works). All the solutions I found so far are related to web apps. What should I do in the case of a windows service? My connection string uses SQL server authentication. (I tried with windows authentication. Its not working either.). Under what login does windows services run and how can I add it to valid SQL server logins?

what version of sql server you are using SQL 2000 or SQL 2005. If sql 2005 have you enabled remote connection on sql server|||I am using SQL Server 2000. My Connection String is "Data Source=Proficio3;Initial Catalog=PRO-TMS_2.5;User ID=service_login;Password=service"|||

Hi,

Please try to check if the SQL Server you're connecting to is the default instance on that server. If not, you will need to add instance name after the server name like:

Data Source=Proficio3\SQLInstance

"SQL Server does not exist or access denied" error message

Hello!

When I start my .aspx with ASP.NET Web Matrix Server, it work, but when i try to start it with IIS I get error message.

TIA,

Misha

What is your connection string to the database like? Are you using a trusted connection? Is IIS running under a different account than Web Matrix? SQL Server needs to know about which accounts are acceptable.

|||string ConnectionString = "server=SERVER;database=pubs;trusted_connection=true";
SQL is on server PC, Web Matrix on Workstation.

"SQL Server does not exist or access denied" error

I'm trying to create to set up connection between my web application on the server and
the database on another box and getting "SQL Server does not exist or access denied" error.
Both the web server and the database machine are Windows 2003 Server, there's no firewall
enabled, there's mixed authentication enabled on the sql server. The machines are not on the
same domain so I'm using SQL Server authentication from web.config. Here's my connection string:
<add key="ConnectionString" value="Server=sqlboxip;User id=sqlaccountname;Pwd=sqlpass;Initial catalog=dbname">
I've also got <identity impersonate="true"> set in web.config.
Had it the connection working at some stage but then with more tweaking and app reinstall
back square one... Please help!</identity></add>Hi,
Are you able to connect to the SQL Server Database using the same credentials from SQL Server (Enterprise Manager or Query Analyzer?)
Thanks.|||Yes, I can connect to it from my dev box in ASP.NET
|||Did you set the connection string of your connection on that page of the app?

I put this in the page load.
this.cnMainConnection.ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["ConnectionsString"].ToString();

|||Hi,
Ok, can you post the code which you are trying to execute.
Thanks.

"SQL Server does not exist or access denied"

Hi everyone!

I receive error "SQL Server does not exist or access denied" when I try to run a web application from my notebook. (when I'm working at home) The weird thing is that it occurs sporadically. Sometimes the connection works just fine. Other times it fails. When I run the application on my workstation at the office everything works perfectly.

Here's the stack trace:

[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
Torris.Common.Data.GetDataSet(String ConnectionString, String sql) in c:\_\Manager\common\data.cs:14
Torris.Manager.Sizes.ListSizes() in C:\_\Manager\Sizes.ascx.cs:145
Torris.Manager.Sizes.Page_Load(Object sender, EventArgs e) in C:\_\Manager\Sizes.ascx.cs:77
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.Control.LoadRecursive() +98
System.Web.UI.Page.ProcessRequestMain() +731

-----------------

Of course, I make sure to change the connection strings in both environments.

Anyone have an idea of what I can look at to try to troubleshoot?

Thanks as always!!

Emi ^_^Hi Emi,

This is virtually always an access issue. How are you trying to connect to the db? IOW, what is your connection string? Are you sure your laptop is setup properly?

The other thing that strikes me is connection pooling. Do you do anything with pooling--change defaults, etc.--in the app?

Don|||Hi!

Thanks for responding. Still having the issue - it's so frustrating. I'm storing my connection string in the web.config which is then read and used in my Data.cs (database class)

Here's the connection string. In this case, the database is on the same machine as the web application. (similar to the how the client's production server is setup):

<add key="ConnectionString" value="server=MyComputerName;database=DatabaseName;uid=sa;pwd=NonBlankPassword;" />

An example of the actual data access - nothing complex here.

public static void ExecuteSql(string ConnectionString, string sql)
{
SqlConnection conn = new SqlConnection(ConnectionString);
SqlCommand cmd = new SqlCommand(sql,conn);
conn.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
conn.Dispose();
}

Like I mentioned before, all works great on my workstation at the office. This might totally be a hardware - issue. Is there anything wrong with the above code that would cause any pooling problems.

Thanks again!

Emi ^_^|||Hi Emi,

Okay, assuming that your sa password in the actual connection string is right, everything else looks okay.

One thing to check is whether the SS2K server is set up to use SQL Server authentication rather than Windows integrated authentication only. You can do that in Enterprise Manager, right-clicking on the server, and selecting Properties. Under the Security tab make sure that "SQL Server and Windows" is selected.

Sigh. But never mind about that. This doesn't explain the sporadic nature of the error. There is something going on with the connection pool. You're not doing anything with the connection pool in your code, but it has a problem when it goes to the pool for a connection. Hmm. And it's happening deep within the .NET framework.

Have you monitored the pool to make sure that connections are still available? It's a weird error to get for a depleted pool, though.

This will take more research. Anyone else have any ideas?

Don

"Sql server does not exist or access denied"

Hello,

I am walking step y step with this tour:

http://www.asp.net/webmatrix/tour/section2/createnewdb.aspx

But when I came to this step:

http://www.asp.net/webmatrix/tour/section2/image/22_EnterDbName.jpg

I got the fallowing error message:

Could not create the database.

Sql server does not exist or access denied ConnectionOpen (Connect()).

I just installed:

http://www.asp.net/msde/default.aspx?tabindex=0&tabid=1

Your help is greatly appreciated.that error is based on the connection string. where's the sql server/msde, and are you using the right login info?

by the way, the angrycoder might be offended you took his name.|||As I mentioned I am using WebMatrix.

- I guess If the name was token I weren't be able to register it! :D|||when you set up your msde/sql server, did you allow for sa passwords? or did you use nt security?|||Never mind... I merly had to reboot my machine!

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
Kapila
Where is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila
|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:

> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from the
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> solve
>
>

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
Kapila
Is the SQL Server running?
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
> solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila
|||Yes, it does. It is shown on the status bar and also in Services. However, it
is not appearing in the computer management console of MS Server 2003.
Best wishes.
Kapila
"Kalen Delaney" wrote:

> Is the SQL Server running?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
>
>
|||It is possible for the SQL Enterprise or iSQL applications to see and work
with SQL server instances while other non-SQL tools such as VS.Net may not
see your SQL servers at all. (based on your problem description)
1. Check to see how the SQL Security is configured on the server. The best
practice is to configure it with Windows Integrated.
2. I always configure SQL Server with Mixed modes (W and Sql). Reason: My
developer PC may not always log on to the Windows Server/Domain where my SQL
Instance is hosted. If such condition exists, then SQL Authentication mode
kicks in to allow me to log on to it.
3. Another suggestion is that if your server is not in the DNS system, then
it is safe to put it in your Windows/HOSTS file. This way everybody
(applications) on your PC can see it.
John Webb

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaIs the SQL Server running?
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
> solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||Yes, it does. It is shown on the status bar and also in Services. However, i
t
is not appearing in the computer management console of MS Server 2003.
Best wishes.
Kapila
"Kalen Delaney" wrote:

> Is the SQL Server running?
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:61B0D79D-A657-4D25-AC9C-69349C3286B3@.microsoft.com...
>
>|||It is possible for the SQL Enterprise or iSQL applications to see and work
with SQL server instances while other non-SQL tools such as VS.Net may not
see your SQL servers at all. (based on your problem description)
1. Check to see how the SQL Security is configured on the server. The best
practice is to configure it with Windows Integrated.
2. I always configure SQL Server with Mixed modes (W and Sql). Reason: My
developer PC may not always log on to the Windows Server/Domain where my SQL
Instance is hosted. If such condition exists, then SQL Authentication mode
kicks in to allow me to log on to it.
3. Another suggestion is that if your server is not in the DNS system, then
it is safe to put it in your Windows/HOSTS file. This way everybody
(applications) on your PC can see it.
John Webb

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaWhere is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:

> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from th
e
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> solve
>
>

"Server does not exist or access is denied"

Hi,
I am trying to connect a web service to an SQL Server 2000 database. SQL
Server is installed and started and the database appears on the Enterprise
MAnager window but it does not appear in the Server Explorer in VS2003.NET
IDE window.It gives the error "Server does not exist or access is denied".
I have re-installed both SQL server and VS but have not being able to solve
this problem.
Can someone help me out ? A prompt reply will be highly appreciated.
Regards
KapilaWhere is the Server Explorer installed? Is it on a different machine or
different network? Based on the error message, it looks like the Server
Explorer is unable to find your SQL Server on the network. A network issue
is more likey to be the case. Can you ping the SQL Server computer from the
Server Explorer box?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
SERVER EXPL@.discussions.microsoft.com> wrote in message
news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> Hi,
> I am trying to connect a web service to an SQL Server 2000 database. SQL
> Server is installed and started and the database appears on the Enterprise
> MAnager window but it does not appear in the Server Explorer in VS2003.NET
> IDE window.It gives the error "Server does not exist or access is denied".
> I have re-installed both SQL server and VS but have not being able to
solve
> this problem.
> Can someone help me out ? A prompt reply will be highly appreciated.
> Regards
> Kapila|||The server explorer is installed on the same system. I am not on a network.
The services are running.
Thanks
Kapila
"Narayana Vyas Kondreddi" wrote:
> Where is the Server Explorer installed? Is it on a different machine or
> different network? Based on the error message, it looks like the Server
> Explorer is unable to find your SQL Server on the network. A network issue
> is more likey to be the case. Can you ping the SQL Server computer from the
> Server Explorer box?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "CAN'T SEE THE SERVER FROM VS SERVER EXPL" <CAN'T SEE THE SERVER FROM VS
> SERVER EXPL@.discussions.microsoft.com> wrote in message
> news:B122F925-40E5-4CFA-AA57-279E47242E4F@.microsoft.com...
> > Hi,
> >
> > I am trying to connect a web service to an SQL Server 2000 database. SQL
> > Server is installed and started and the database appears on the Enterprise
> > MAnager window but it does not appear in the Server Explorer in VS2003.NET
> > IDE window.It gives the error "Server does not exist or access is denied".
> >
> > I have re-installed both SQL server and VS but have not being able to
> solve
> > this problem.
> >
> > Can someone help me out ? A prompt reply will be highly appreciated.
> >
> > Regards
> >
> > Kapila
>
>

"rsAccessDenied" Error when Anonymous User from a Virtual directory access the Reporting S

Hi,
My setup is that i have a IIS virtual directory with Anonymous user (
enable anonymous ) to access Reporting Server. Both are in same server
anyway.
I have a web page in the virtual directory with url link to the
Reprting Server.
if I grant this anonymous user with admin privilege , then it works.
Why ' what kind of privilege is needed in fact ? There are some clue
but i dont know how to intepret.
The error log from Event log is as below:
Event Type: Error
Event Source: DCOM
Event Category: None
Event ID: 10016
Date: 18/01/2006
Time: 10:41:23
User: NT AUTHORITY\NETWORK SERVICE
Computer: SVR071
Description:
The application-specific permission settings do not grant Local
Activation permission for the COM Server application with CLSID
{BA126AD1-2166-11D1-B1D0-00805FC1270E}
to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This
security permission can be modified using the Component Services
administrative tool.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.What is the configured identity of the 'ReportServer' service? Is it
interactive user? What is the security configuration for the
ReportServer virtual directory? What is the security configuration for
connecting to your SQL serrver?
If you're accessing the virutal directory as an anonymous user and the
RS service is configured to run as the interactive user, then the
interactive user (in this case anonymous) would need priviledges to
connect to SQL and any other necessary resources.
Andy Potter

"Read Only" problem from Access 2003 to SQL Server

I am unable to add/update/delete data in the SQL Server database from Access
2003. I can connect just fine using either an ODBC link or via an ADO
connection in VBA. However, any time I try to change any SQL Server data (or
run a stored procedure) it either "times out" or gives me a message to the
effect that "...another user is attempting to change the data at the same
time...". Since I am the only one on the network, I know this is not the
real problem. I have SQL Profiler running in order to see what may be
happening when I try to run a stored procedure. The SQL Server doesn't get
the request at all. Access seems to be blocking any calls to stored
procedures and blocking any attempt to change data.
I can change data with no problem from within Enterprise Manager. The SQL
Server User (in the ADO connection) has db owner rights and rights to all
objects being accessed.
Here is the configuration: I am running Win 2K Pro with SQL Server 2000 on
PC-1 and Win XP Pro and Access 2003 on PC-2. I have an Access 2003 database
application on PC-2 that needs to modify the SQL data on PC-1. I have tried
Windows authentication and SQL Server Authentication (modifying the SQL
Server settings and ADO connection string settings as needed). Both ways of
connecting give the same result - read only.
When I installed Access 2003 I saw a message relating to security and Access
not allowing potentially destructive code to run. I took no action on the
message although I did remember seeing something about a necessary update to
2003 for the issue (I figured I'd revisit it later). This issue may be
related to the problem, but I don't know. There are no outstanding updates
available for Access 2003 from MS. Now I can't figure out what it was
talking about. I may uninstall the software and reinstall to see if I can
catch it again.
I have tried everything I can think of, including soliciting help from
peers, searching the knowledge databases and reading many posts. No luck.
It appears as though no one has had this particular issue come up. I tried
to ask Microsoft (using my one free question) but my (valid) Product ID was
rejected by their system.
Anyone out there have any experience with this one? Three days stuck on one
issue is getting old.
Thanks and regards,
--
Ken Wells
President
Smart Computing Solutions, LLCAll it took was a post. I have, for all intents and purposes, solved this
problem myself.
I broke down and rewrote the code (inherited from another developer), basing
it on code that I had done in the past. I can now execute a stored procedure
and update or add records in the SQL database from Access 2003 using an ADO
connection and SQL Server Authentication.
I still cannot directly modify ODBC-linked SQL table data from the database
window, but that is a minor consideration at this point.
"SmartComputing" wrote:
> I am unable to add/update/delete data in the SQL Server database from Access
> 2003. I can connect just fine using either an ODBC link or via an ADO
> connection in VBA. However, any time I try to change any SQL Server data (or
> run a stored procedure) it either "times out" or gives me a message to the
> effect that "...another user is attempting to change the data at the same
> time...". Since I am the only one on the network, I know this is not the
> real problem. I have SQL Profiler running in order to see what may be
> happening when I try to run a stored procedure. The SQL Server doesn't get
> the request at all. Access seems to be blocking any calls to stored
> procedures and blocking any attempt to change data.
> I can change data with no problem from within Enterprise Manager. The SQL
> Server User (in the ADO connection) has db owner rights and rights to all
> objects being accessed.
> Here is the configuration: I am running Win 2K Pro with SQL Server 2000 on
> PC-1 and Win XP Pro and Access 2003 on PC-2. I have an Access 2003 database
> application on PC-2 that needs to modify the SQL data on PC-1. I have tried
> Windows authentication and SQL Server Authentication (modifying the SQL
> Server settings and ADO connection string settings as needed). Both ways of
> connecting give the same result - read only.
> When I installed Access 2003 I saw a message relating to security and Access
> not allowing potentially destructive code to run. I took no action on the
> message although I did remember seeing something about a necessary update to
> 2003 for the issue (I figured I'd revisit it later). This issue may be
> related to the problem, but I don't know. There are no outstanding updates
> available for Access 2003 from MS. Now I can't figure out what it was
> talking about. I may uninstall the software and reinstall to see if I can
> catch it again.
> I have tried everything I can think of, including soliciting help from
> peers, searching the knowledge databases and reading many posts. No luck.
> It appears as though no one has had this particular issue come up. I tried
> to ask Microsoft (using my one free question) but my (valid) Product ID was
> rejected by their system.
> Anyone out there have any experience with this one? Three days stuck on one
> issue is getting old.
> Thanks and regards,
> --
> Ken Wells
> President
> Smart Computing Solutions, LLC|||"SmartComputing" <kennethwells@.NO_SPAM_yahoo.com> wrote in message
news:9F4BA364-B69B-4026-AD67-CF024DE7FEDD@.microsoft.com...
> All it took was a post. I have, for all intents and purposes, solved this
> problem myself.
> I broke down and rewrote the code (inherited from another developer),
> basing
> it on code that I had done in the past. I can now execute a stored
> procedure
> and update or add records in the SQL database from Access 2003 using an
> ADO
> connection and SQL Server Authentication.
> I still cannot directly modify ODBC-linked SQL table data from the
> database
> window, but that is a minor consideration at this point.
I reckon it's the connection parameters are most likely the problem.
Go into the linked table manager.
If you hover over the connected tables you should see a connection string in
there.
Whilst you're there, refresh the connections and check that doesn't help.
Check out your DSN or connection strings.
Oh...
Access wants unique keys to allow updates.
Looking at the table definition in access, you see a primary key on the
tables?
There's also joins can make a query not updateable but if nothing works this
seems unlikely.
--
Regards,
Andy O'Neill

"Read Only" problem from Access 2003 to SQL Server

I am unable to add/update/delete data in the SQL Server database from Access
2003. I can connect just fine using either an ODBC link or via an ADO
connection in VBA. However, any time I try to change any SQL Server data (or
run a stored procedure) it either "times out" or gives me a message to the
effect that "...another user is attempting to change the data at the same
time...". Since I am the only one on the network, I know this is not the
real problem. I have SQL Profiler running in order to see what may be
happening when I try to run a stored procedure. The SQL Server doesn't get
the request at all. Access seems to be blocking any calls to stored
procedures and blocking any attempt to change data.
I can change data with no problem from within Enterprise Manager. The SQL
Server User (in the ADO connection) has db owner rights and rights to all
objects being accessed.
Here is the configuration: I am running Win 2K Pro with SQL Server 2000 on
PC-1 and Win XP Pro and Access 2003 on PC-2. I have an Access 2003 database
application on PC-2 that needs to modify the SQL data on PC-1. I have tried
Windows authentication and SQL Server Authentication (modifying the SQL
Server settings and ADO connection string settings as needed). Both ways of
connecting give the same result - read only.
When I installed Access 2003 I saw a message relating to security and Access
not allowing potentially destructive code to run. I took no action on the
message although I did remember seeing something about a necessary update to
2003 for the issue (I figured I'd revisit it later). This issue may be
related to the problem, but I don't know. There are no outstanding updates
available for Access 2003 from MS. Now I can't figure out what it was
talking about. I may uninstall the software and reinstall to see if I can
catch it again.
I have tried everything I can think of, including soliciting help from
peers, searching the knowledge databases and reading many posts. No luck.
It appears as though no one has had this particular issue come up. I tried
to ask Microsoft (using my one free question) but my (valid) Product ID was
rejected by their system.
Anyone out there have any experience with this one? Three days stuck on one
issue is getting old.
Thanks and regards,
Ken Wells
President
Smart Computing Solutions, LLC
All it took was a post. I have, for all intents and purposes, solved this
problem myself.
I broke down and rewrote the code (inherited from another developer), basing
it on code that I had done in the past. I can now execute a stored procedure
and update or add records in the SQL database from Access 2003 using an ADO
connection and SQL Server Authentication.
I still cannot directly modify ODBC-linked SQL table data from the database
window, but that is a minor consideration at this point.
"SmartComputing" wrote:

> I am unable to add/update/delete data in the SQL Server database from Access
> 2003. I can connect just fine using either an ODBC link or via an ADO
> connection in VBA. However, any time I try to change any SQL Server data (or
> run a stored procedure) it either "times out" or gives me a message to the
> effect that "...another user is attempting to change the data at the same
> time...". Since I am the only one on the network, I know this is not the
> real problem. I have SQL Profiler running in order to see what may be
> happening when I try to run a stored procedure. The SQL Server doesn't get
> the request at all. Access seems to be blocking any calls to stored
> procedures and blocking any attempt to change data.
> I can change data with no problem from within Enterprise Manager. The SQL
> Server User (in the ADO connection) has db owner rights and rights to all
> objects being accessed.
> Here is the configuration: I am running Win 2K Pro with SQL Server 2000 on
> PC-1 and Win XP Pro and Access 2003 on PC-2. I have an Access 2003 database
> application on PC-2 that needs to modify the SQL data on PC-1. I have tried
> Windows authentication and SQL Server Authentication (modifying the SQL
> Server settings and ADO connection string settings as needed). Both ways of
> connecting give the same result - read only.
> When I installed Access 2003 I saw a message relating to security and Access
> not allowing potentially destructive code to run. I took no action on the
> message although I did remember seeing something about a necessary update to
> 2003 for the issue (I figured I'd revisit it later). This issue may be
> related to the problem, but I don't know. There are no outstanding updates
> available for Access 2003 from MS. Now I can't figure out what it was
> talking about. I may uninstall the software and reinstall to see if I can
> catch it again.
> I have tried everything I can think of, including soliciting help from
> peers, searching the knowledge databases and reading many posts. No luck.
> It appears as though no one has had this particular issue come up. I tried
> to ask Microsoft (using my one free question) but my (valid) Product ID was
> rejected by their system.
> Anyone out there have any experience with this one? Three days stuck on one
> issue is getting old.
> Thanks and regards,
> --
> Ken Wells
> President
> Smart Computing Solutions, LLC
|||"SmartComputing" <kennethwells@.NO_SPAM_yahoo.com> wrote in message
news:9F4BA364-B69B-4026-AD67-CF024DE7FEDD@.microsoft.com...
> All it took was a post. I have, for all intents and purposes, solved this
> problem myself.
> I broke down and rewrote the code (inherited from another developer),
> basing
> it on code that I had done in the past. I can now execute a stored
> procedure
> and update or add records in the SQL database from Access 2003 using an
> ADO
> connection and SQL Server Authentication.
> I still cannot directly modify ODBC-linked SQL table data from the
> database
> window, but that is a minor consideration at this point.
I reckon it's the connection parameters are most likely the problem.
Go into the linked table manager.
If you hover over the connected tables you should see a connection string in
there.
Whilst you're there, refresh the connections and check that doesn't help.
Check out your DSN or connection strings.
Oh...
Access wants unique keys to allow updates.
Looking at the table definition in access, you see a primary key on the
tables?
There's also joins can make a query not updateable but if nothing works this
seems unlikely.
Regards,
Andy O'Neill