analysis services

Hello.....

Anyone could help me? I found a difficulties to view the mining result(tree) from analysis services 2000 in my vb 6 application form. I've tried to view the tree by using DMbrowser in vb6 so please help me with some code lines.

Thanx a lot

Take a look at the included source code in this download for the DMSample app (it's written in VB and it launches the viewers from the app): http://www.sqlserverdatamining.com/DMCommunity/Downloads/Links_LinkRedirector.aspx?id=85

Note that the AS2000 license does not give you the ability to redistributable the viewers as part of your application.

Analysis of a 400GB database after SQL server restarts takes forever (or maybe hang)

Hello there,

We have a database used by a thrid party application that is 400GB in size. After the server gave some warnings, we restarted the machine and SQL server is doing an analysis on the database so it can be recovered. The recovery analysis of the 400GB database has been run for 3 days and only 7% complete. I doubt it'll ever finish. Because this recovery analysis is a background process which I can not kill, I can not drop the database either because it places an exclusive lock on the database when SQL server is doing analysis. We're using SQL server 2000 enterprise edition, sp3. Now I think that we probably should not have such a big database in the first place. Right now, I just want to stop the analysis if I can so I can either truncate the tables in that 400GB or drop the database completely. Not sure if start sql server in cmd with single user mode can do or not. Any suggestions are appreciated.

thanks,

-Jessie

if the database is not important and you do have a copy of it backed up, you can terminate sqlserver service; start a new session in console mode and drop the database.

e.g.

sqlservr.exe -c -f -m

|||

Thanks OJ for your reply! This database is important but we can't afford every time the server restarts, it takes 1 day to only recover 3% of this db. That "-f" stops the recovery of the user databases. But when I tried to run "use 400GBdb", it gave me this error:Server: Msg 913, Level 16, State 4, Line 1
Could not find database ID 12. Database may not be activated yet or may be in transition.

I'll first back the data/log files to tape before I drop the db. But are you sure I can drop the db even the system can not find the dbid?

-Jessie

|||

Jessie,

You can start sqlserver without doing any recovery of any user databases.

e.g.

sqlservr.exe -s"your_instance" -f -m

then connect to the instance and drop the database

drop database "your_db"

|||

Jessie,

You can start sqlserver without doing any recovery of any user databases.

e.g.

sqlservr.exe -s"your_instance" -f -m

then connect to the instance and drop the database

drop database "your_db"

|||

Thanks OJ! Yes, using -f can stop recovery of user database. But because user db is not recovered, they are not accessible. You'll get:dbid not found error. I rebooted the SQL serve twice and both recovery of the 400GB hung when the recovery is 99% complete. From SQL server error log: The Scheduler 3 appears to be hung. SPID 17, ECID 0, UMS Context 0x03716938. I guess 400 GB is beyong SQL server 2000 limit.

What I did is that I stopped the SQL server, delete the log file and restarted the SQL server. Then the db is marked as suspect and I deleted the db.

Analysis Manager & Msmdarch - Application Error

I have been receiving the follow error when I close Analysis

Manger:

mmc.exe

- Application Error

The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The

memory could not be “read”

I am also getting the following error when msmdarch completes an archive.

msmdarch.exe

– Application Error

The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The

memory could not be “read”

I

am not seeing anything in the event viewer for these errors.

The system is a Win2k3 Server SP1 with 3.75 GB of ram and Sql Server Standard

SP4.

I have scoured google looking for an answer, but I am coming up short.

Any insight into these errors?

Looks like something is wrong with the installation on your machine.

You can try and re-install Analysis Services on you machine. Please make sure you backup all your databases before doing so.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||the only reason I haven't tried that yet is that this is also happening on other machines, another Win2k3 box and an XP machine, I should have stated that.|||

RESOLVED!

unbelievable. the issues turned out to be the Oracle ODBC driver that we were

using as the Data Source. I updated the ODBC driver with the latest drivers

from Oracle and the issues have gone away for both analysis manager &

msmdarch.

|||

Interesting, I have been searching for a solution to a similiar error

DTSRun.exe - Application Error

The instruction at "0x7c8327f9" referenced memory at "0xffffffff". The memory could not be read.

when running a scheduled DTS package Win 2003 sp1 0S that runs fine when not scheduled. The package connects to an Oracle 8i DB to pull data into SQL server 2000 DB tables. Do you have a link for the Oracle Driver you used. I am using Instant Client version 10 driver?

|||I would just pull down the latest instant client from oracle, hopefully that will fix your issue.sql

Analysis Manager & Msmdarch - Application Error

I have been receiving the follow error when I close Analysis

Manger:

mmc.exe

- Application Error

The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The

memory could not be “read”

I am also getting the following error when msmdarch completes an archive.

msmdarch.exe

– Application Error

The instruction at “0x7c8327f9” referenced memory at “0xffffffff”. The

memory could not be “read”

I

am not seeing anything in the event viewer for these errors.

The system is a Win2k3 Server SP1 with 3.75 GB of ram and Sql Server Standard

SP4.

I have scoured google looking for an answer, but I am coming up short.

Any insight into these errors?

Looks like something is wrong with the installation on your machine.

You can try and re-install Analysis Services on you machine. Please make sure you backup all your databases before doing so.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||the only reason I haven't tried that yet is that this is also happening on other machines, another Win2k3 box and an XP machine, I should have stated that.|||

RESOLVED!

unbelievable. the issues turned out to be the Oracle ODBC driver that we were

using as the Data Source. I updated the ODBC driver with the latest drivers

from Oracle and the issues have gone away for both analysis manager &

msmdarch.

|||

Interesting, I have been searching for a solution to a similiar error

DTSRun.exe - Application Error

The instruction at "0x7c8327f9" referenced memory at "0xffffffff". The memory could not be read.

when running a scheduled DTS package Win 2003 sp1 0S that runs fine when not scheduled. The package connects to an Oracle 8i DB to pull data into SQL server 2000 DB tables. Do you have a link for the Oracle Driver you used. I am using Instant Client version 10 driver?

|||I would just pull down the latest instant client from oracle, hopefully that will fix your issue.

An existing connection was forcibly closed by the remote host

Hi,

I am using ASP.NET 2.0 application to fetch data from a SQL server 2005 using stroed proc.

Stored proc is also using one table from Linked Server (SQL 2000). Linked Server is configured to use login's current security context.

I am getting the following error message

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/15/2006 4:26:30 PM
Event time (UTC): 6/15/2006 8:26:30 PM
Event ID: 988964e6fa5249e38b1bc6c9a5ecd1e4
Event sequence: 850
Event occurrence: 7
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/MyApp-1-127948732130920720
Trust level: Full
Application Virtual Path: /MyApp
Application Path: C:\Inetpub\wwwroot\MyApp\
Machine name: MyServer
Process information:
Process ID: 352
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: SqlException
Exception message: TCP Provider: An existing connection was forcibly closed by the remote host.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Request information:
Request URL: http://MyServer/MyApp/Page1.aspx
Request path: /MyServer/MyApp/Page1.aspx
User host address: XX.XX.XXX.XX
User: DomainName/UserName

Is authenticated: True
Authentication Type: Negotiate
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

Please Guide

Thanks

Is it intermittent or consistent?

1. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

This looks like a consistent issue. It normally means that you need to configuration IIS account to access SQL Server. You can take a look at this link, http://support.microsoft.com/kb/247931/en-us.

2. TCP Provider: An existing connection was forcibly closed by the remote host.

This normally is an intermittent issue. It happens when you enable connection pooling and server closes the connection for reason like connection clean up, restart, network failure, the ASP.NET( sqlclient ) use dead connection from the pool to write data and thus get the failure you see. Re-retry connection should solve the issue.

|||

Hi Nan,

Re: 1. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

IIS is configured properly to access data from SQL Server and it is working fine when IIS & SQL are on the same box. But the above message comes only when the stored proc tries to access data from a 2nd SQL Server (linked server which is not on the same box as IIS). Somehow it is not passing the credential to the 2nd SQL Server. 2nd SQL server is linked using login's current security context. Also ASP.NET 2 web.config file says <identity impersonate="true" />. I am using NT domain right now. Is this issue of "Double hop"?

Re: 2. TCP Provider: An existing connection was forcibly closed by the remote host.

Is connection pooling is by default? Can we change so that it should not use it?

Thanks

Shafiq

an error while trying to read .sdf file from the pc application ? please help

hi

i have a problem with reading sql mobile database existed on the pc

i made a sql mobile database connection with ( Add New Datasource ) and then set

the datasource of dataviewgrid to display the returned dataset .

at run time i have an exception said :

cann't find the library with the name sqlceme.dll as i remember ,

can you help me solving this problem because i very need this step , please ?

regards

This looks to be a Sql Mobile setup or configuration issue. Moving the thread to the Sql Mobile forum.|||

SQL Mobile did not support Windows Applications before. It was integrated only with Device Applications. However, we will be releasing SQL Server Everywhere on desktop which you can use on desktop.

See the following URL for more details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295034&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||Is it posible to provide a link to the thread in the Sql Mobile forum?

an error while trying to read .sdf file from the pc application ? please help

hi

i have a problem with reading sql mobile database existed on the pc

i made a sql mobile database connection with ( Add New Datasource ) and then set

the datasource of dataviewgrid to display the returned dataset .

at run time i have an exception said :

cann't find the library with the name sqlceme.dll as i remember ,

can you help me solving this problem because i very need this step , please ?

regards

This looks to be a Sql Mobile setup or configuration issue. Moving the thread to the Sql Mobile forum.|||

SQL Mobile did not support Windows Applications before. It was integrated only with Device Applications. However, we will be releasing SQL Server Everywhere on desktop which you can use on desktop.

See the following URL for more details:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=295034&SiteID=1

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||Is it posible to provide a link to the thread in the Sql Mobile forum?

An error occurred during local report processing.

Occasionally when we are running reports in our web application we are
getting this error. It seems random and occurs even if a report has
just been run with the same criteria. Sometimes the error occurs a
couple of times in a row and then it will run after that fine.
An error occurred during local report processing.
An unexpected error occurred in Report Processing.
Object reference not set to an instance of an object.On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> Occasionally when we are running reports in our web application we are
> getting this error. It seems random and occurs even if a report has
> just been run with the same criteria. Sometimes the error occurs a
> couple of times in a row and then it will run after that fine.
> An error occurred during local report processing.
> An unexpected error occurred in Report Processing.
> Object reference not set to an instance of an object.
Sounds like on occasion there is an issue with the cached data for the
report. If you are caching the report data, I would suggest removing
the cache data setting. Also, you might want to delete the rdl.data
file in the interim. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > Occasionally when we are running reports in our web application we are
> > getting this error. It seems random and occurs even if a report has
> > just been run with the same criteria. Sometimes the error occurs a
> > couple of times in a row and then it will run after that fine.
> > An error occurred during local report processing.
> > An unexpected error occurred in Report Processing.
> > Object reference not set to an instance of an object.
> Sounds like on occasion there is an issue with the cached data for the
> report. If you are caching the report data, I would suggest removing
> the cache data setting. Also, you might want to delete the rdl.data
> file in the interim. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks Enrique. I was starting to suspect it was something to do with
caching. Do you know how I can remove the cache data setting? I did a
search for rdl.data files on the server and it couldn't find any.|||I've managed to fix it by stopping stopping the W3SVC (WWW Publisher
Service) and deleting all the files in
C:/Windows/Microsoft.NET/Framework/v2.0.50527/Temporary ASP.NET Files/|||On Dec 6, 7:56 pm, lachlan.h...@.gmail.com wrote:
> On Dec 7, 12:18 pm, EMartinez <emartinez...@.gmail.com> wrote:
>
> > On Dec 6, 6:12 pm, lachlan.h...@.gmail.com wrote:
> > > Occasionally when we are running reports in our web application we are
> > > getting this error. It seems random and occurs even if a report has
> > > just been run with the same criteria. Sometimes the error occurs a
> > > couple of times in a row and then it will run after that fine.
> > > An error occurred during local report processing.
> > > An unexpected error occurred in Report Processing.
> > > Object reference not set to an instance of an object.
> > Sounds like on occasion there is an issue with the cached data for the
> > report. If you are caching the report data, I would suggest removing
> > the cache data setting. Also, you might want to delete the rdl.data
> > file in the interim. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks Enrique. I was starting to suspect it was something to do with
> caching. Do you know how I can remove the cache data setting? I did a
> search for rdl.data files on the server and it couldn't find any.
You're welcome. Thanks for posting your resolution; that might help
someone in the future with a similar situation.
Regards,
Enrique Martinez
Sr. Software Consultant

An error has occurred while establishing a connection to the server

Hi I have just reinstalled .Net and SqlServer2005. I am running my application from local machine and sqlserver is also install local machine. but when I run application. Get follwing Error Message

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

What was the application trying to do when you got this message? It may be that the connection string is not correct, it may be that the server is setup for only windows authentication.

|||

Hi

From your description, it seems that you met error when you are trying to connect to your SQLServer,right?

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

For this kind of issue, we should use the following steps to diagnose the problem.

First, you also should make sure that if 1433 port has been enabled on your server, which is the default port for SQLServer remote connections.

Generally, you can try the following ways to handle your problem.

1. Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition
2. Enable the SQL Server Browser service
3. Create exceptions in Windows Firewall
4. Create an exception for SQL Server 2005 in Windows Firewall
5. Create an exception for the SQL Server Browser service in Windows Firewall

More details for each step, you may see the following link:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Thanks.

An error has occurred while establishing a connection to the serve

Server Error in '/indiatest' Application.
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred
while establishing a connection to the server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections. (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
Line 47: vSQL="select max(pdate) from uploadlog where
logreport='Salesorder Upload Completed'"
Line 48: objCmd = New SqlCommand(vSQL, objConn)
Line 49: objConn.Open()
Line 50: dataReader = objCmd.ExecuteReader()
Line 51:
Source File: D:\indiatest\login1.aspx Line: 49
Stack Trace:
[SqlException (0x80131904): An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject) +685966
System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject) +109
System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383
System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.login1_aspx.ftip(Object Src, EventArgs E) in
D:\indiatest\login1.aspx:49
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET
Version:2.0.50727.832
Error you get is all about the connection to your SQL Server instance.
I wish you'd share the Connection String with us. Then it would be easier to
track the path.
Ensure you enter the right info to the Server property in your Connection
String. If your SQL Server instance is a Named instance then you should
enter this info as "ServerName\NamedInstance", if it's a Default Instance
then only the ServerName would be enough.
Is this your server, or a server of a hosting company? If it's yours and
ensure that you set the Firewall settings of the Windows Server to allow the
port that your SQL Server instance uses. And ensure you enabled TCP protocol
and configured it well. Ensure you use a static port for this purpose (if
it's a Default Instance then it'll be using 1433 static port, if it's a
Named Instance then it'll be using a Dynamic Port by default)
Ekrem ?nsoy
"Yogesh Bate" <YogeshBate@.discussions.microsoft.com> wrote in message
news:02D393E8-F9BA-4D5F-9BF3-CD57E336356E@.microsoft.com...
> Server Error in '/indiatest' Application.
> ----
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: Named Pipes Provider, error: 40 - Could not open a connection
> to
> SQL Server)
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Data.SqlClient.SqlException: An error has
> occurred
> while establishing a connection to the server. When connecting to SQL
> Server
> 2005, this failure may be caused by the fact that under the default
> settings
> SQL Server does not allow remote connections. (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server)
> Source Error:
>
> Line 47: vSQL="select max(pdate) from uploadlog where
> logreport='Salesorder Upload Completed'"
> Line 48: objCmd = New SqlCommand(vSQL, objConn)
> Line 49: objConn.Open()
> Line 50: dataReader = objCmd.ExecuteReader()
> Line 51:
>
> Source File: D:\indiatest\login1.aspx Line: 49
> Stack Trace:
>
> [SqlException (0x80131904): An error has occurred while establishing a
> connection to the server. When connecting to SQL Server 2005, this
> failure
> may be caused by the fact that under the default settings SQL Server does
> not
> allow remote connections. (provider: Named Pipes Provider, error: 40 -
> Could
> not open a connection to SQL Server)]
> System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException
> exception, Boolean breakConnection) +739123
> System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject
> stateObj) +188
> System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
> SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
> integratedSecurity, SqlConnection owningObject) +685966
> System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo
> serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, SqlConnection owningObject) +109
> System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(String
> host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> +383
> System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance) +181
> System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity
> identity, SqlConnectionString connectionOptions, Object providerInfo,
> String
> newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
> +170
> System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions
> options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
> owningConnection) +359
> System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnection
> owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
> System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection
> owningObject) +424
> System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection
> owningObject) +66
> System.Data.ProviderBase.DbConnectionPool.GetConne ction(DbConnection
> owningObject) +496
> System.Data.ProviderBase.DbConnectionFactory.GetCo nnection(DbConnection
> owningConnection) +82
> System.Data.ProviderBase.DbConnectionClosed.OpenCo nnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory) +105
> System.Data.SqlClient.SqlConnection.Open() +111
> ASP.login1_aspx.ftip(Object Src, EventArgs E) in
> D:\indiatest\login1.aspx:49
> System.Web.UI.Control.OnLoad(EventArgs e) +99
> System.Web.UI.Control.LoadRecursive() +47
> System.Web.UI.Control.LoadRecursive() +131
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
>
>
> ----
> Version Information: Microsoft .NET Framework Version:2.0.50727.832;
> ASP.NET
> Version:2.0.50727.832

An error has occurred while establishing a connection to the serve

Server Error in '/indiatest' Application
----
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: An error has occurred
while establishing a connection to the server. When connecting to SQL Server
2005, this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections. (provider: Named Pipes
Provider, error: 40 - Could not open a connection to SQL Server)
Source Error:
Line 47: vSQL="select max(pdate) from uploadlog where
logreport='Salesorder Upload Completed'"
Line 48: objCmd = New SqlCommand(vSQL, objConn)
Line 49: objConn.Open()
Line 50: dataReader = objCmd.ExecuteReader()
Line 51:
Source File: D:\indiatest\login1.aspx Line: 49
Stack Trace:
[SqlException (0x80131904): An error has occurred while establishing a
connection to the server. When connecting to SQL Server 2005, this failure
may be caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: Named Pipes Provider, error: 40 - Could
not open a connection to SQL Server)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +739123
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) +188
System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject) +685966
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
timerExpire, SqlConnection owningObject) +109
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
host, String newPassword, Boolean redirectedUserInstance, SqlConnection
owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +383
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
owningObject, SqlConnectionString connectionOptions, String newPassword,
Boolean redirectedUserInstance) +181
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, Object providerInfo, String
newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
owningConnection) +359
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +496
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
owningConnection) +82
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.SqlClient.SqlConnection.Open() +111
ASP.login1_aspx.ftip(Object Src, EventArgs E) in
D:\indiatest\login1.aspx:49
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Control.LoadRecursive() +131
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
----
Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET
Version:2.0.50727.832Error you get is all about the connection to your SQL Server instance.
I wish you'd share the Connection String with us. Then it would be easier to
track the path.
Ensure you enter the right info to the Server property in your Connection
String. If your SQL Server instance is a Named instance then you should
enter this info as "ServerName\NamedInstance", if it's a Default Instance
then only the ServerName would be enough.
Is this your server, or a server of a hosting company? If it's yours and
ensure that you set the Firewall settings of the Windows Server to allow the
port that your SQL Server instance uses. And ensure you enabled TCP protocol
and configured it well. Ensure you use a static port for this purpose (if
it's a Default Instance then it'll be using 1433 static port, if it's a
Named Instance then it'll be using a Dynamic Port by default)
--
Ekrem Ã?nsoy
"Yogesh Bate" <YogeshBate@.discussions.microsoft.com> wrote in message
news:02D393E8-F9BA-4D5F-9BF3-CD57E336356E@.microsoft.com...
> Server Error in '/indiatest' Application.
> ----
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: Named Pipes Provider, error: 40 - Could not open a connection
> to
> SQL Server)
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about
> the error and where it originated in the code.
> Exception Details: System.Data.SqlClient.SqlException: An error has
> occurred
> while establishing a connection to the server. When connecting to SQL
> Server
> 2005, this failure may be caused by the fact that under the default
> settings
> SQL Server does not allow remote connections. (provider: Named Pipes
> Provider, error: 40 - Could not open a connection to SQL Server)
> Source Error:
>
> Line 47: vSQL="select max(pdate) from uploadlog where
> logreport='Salesorder Upload Completed'"
> Line 48: objCmd = New SqlCommand(vSQL, objConn)
> Line 49: objConn.Open()
> Line 50: dataReader = objCmd.ExecuteReader()
> Line 51:
>
> Source File: D:\indiatest\login1.aspx Line: 49
> Stack Trace:
>
> [SqlException (0x80131904): An error has occurred while establishing a
> connection to the server. When connecting to SQL Server 2005, this
> failure
> may be caused by the fact that under the default settings SQL Server does
> not
> allow remote connections. (provider: Named Pipes Provider, error: 40 -
> Could
> not open a connection to SQL Server)]
> System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
> exception, Boolean breakConnection) +739123
> System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
> stateObj) +188
> System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,
> SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
> integratedSecurity, SqlConnection owningObject) +685966
> System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
> serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64
> timerExpire, SqlConnection owningObject) +109
> System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String
> host, String newPassword, Boolean redirectedUserInstance, SqlConnection
> owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
> +383
> System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection
> owningObject, SqlConnectionString connectionOptions, String newPassword,
> Boolean redirectedUserInstance) +181
> System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
> identity, SqlConnectionString connectionOptions, Object providerInfo,
> String
> newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
> +170
> System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
> options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection
> owningConnection) +359
> System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection
> owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
> System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
> owningObject) +424
> System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
> owningObject) +66
> System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
> owningObject) +496
> System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection
> owningConnection) +82
> System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection
> outerConnection, DbConnectionFactory connectionFactory) +105
> System.Data.SqlClient.SqlConnection.Open() +111
> ASP.login1_aspx.ftip(Object Src, EventArgs E) in
> D:\indiatest\login1.aspx:49
> System.Web.UI.Control.OnLoad(EventArgs e) +99
> System.Web.UI.Control.LoadRecursive() +47
> System.Web.UI.Control.LoadRecursive() +131
> System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
>
>
> ----
> Version Information: Microsoft .NET Framework Version:2.0.50727.832;
> ASP.NET
> Version:2.0.50727.832

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hello All,

I'm developing pocket PC application.. when I want to replicate my data from pocket pc to development pc.. I've got this error on my pocket pc.. "An error has occurred on the computer running IIS"

Any ideas? Any help?

I'm using SQl Server 2000, SQL Server CE 2.0, VS.Net 2003

Thanks

I am sure get more than 5 hits for this error on this forum. Let me not repeat the stories, please try out the solutions previously posted.

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Ev, Microsoft Corporation

|||try to set it up according to this step-by-step guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp?frame=true

greets
florian

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

An error has occurred on the computer running IIS

Hi, i was following the tutorial in SQL Mobile Books online "Creating a Mobile Application with SQL Server Mobile ", but when i try to run the application using the pocket PC 2003 emulator, the got the following error, "An error has occurred on the computer running IIS, Try restarting the IIS server.", any idea why?

Check to see if the IIS URL is missing double quotes in your application. Compare with an example in Books Online.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Check to see if the IIS URL is missing double quotes.

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

thanks for your reply Syed..

I have checked the IIS URL and it has double quotes. one thing my application is different from the tutorial sample is, on the tutorial

repl.PublisherSecurityMode = SecurityType.NTAuthentication;

but in my application,

repl.PublisherSecurityMode = SecurityType.DBAuthentication;

repl.PublisherLogin = @."sa";

repl.PublisherPassword = @."<admin1234admin>";

repl.Publication = @."SQLMobile";

repl.Subscriber = @."SQLMobile";

repl.SubscriberConnectionString = @."Data Source='" + filename + "';Password='';Max Database Size='128';Default Lock Escalation ='100';";

because i am using SQL Server Authentication rather than DBAuthentication used in the sample. would this have made the impact?

|||

Check to see if Pocket IE on the emulator is able to browse the IIS URL. Also you may want to generate a server agent log on IIS as described in

SQL Server 2005 Mobile Edition Books Online topic :"Enabling Logging by Using SQL Server Mobile Server Agent."

Thank you!

Syed N. Yousuf

Microsoft Developer Support Professional

This posting is provided “AS IS” with no warranties, and confers no rights.

|||

Hi Syed,

I followed the tutorial, couldn't connect to IIS URL from the emulator. I am testing this on my standalone PC with local IIS. Can you suggest me what needs to be checked.

Regards

Aravind

|||

Dear FeiH,

I also have the same error as u already faced, like An error has occurred on the computer running IIS , could u solve this pbm, then pls give a good suggestion, pls help me.

|||

sorry Jeyaseelan,

whatever i've tried didn't work for me and I haven't investigated on it since.

|||How are you connecting to the IIS machine, are you using anonymous authentication or basic/integrated authentication.|||

hi , Udaya

This error happens when the device is not able to get conne ted with the IIS. Before running the program just open IE and try browsing some websites. If that is ok , try entering the SQL CE Server agent URL .

If you are using the RDA tutorial , the link will be something like :

http://121.247.150.xxx/yourvirtuladirectory/sqlcesa30.dll

If your IIS is configured properly you can see a simple webpage with a text message

SQL Server Mobile Server Agent 3.0 .

|||

Hi Every Body

I have been having a tough time with Configuring IIS.

My IIS is Configured Properly and it Shows the Text Message on the URl

"SQL Server Mobile Server Agent 3.0"

But Still in the Every Last Step it says "Unable To Connect to Computer Running IIS".

Me Using My Local Machine.

- I have Tried Using Anonyous Acess.

- Tried to user the IUSR_[MAchineName]

But None Worked for me.

IF any one can Help.

Regards

Adnan.

|||

Hi ,

Do not worry , U cam correct it!!

In fact u do not have to stick to all the steps in e book.

Regarding IIS configuration u can perfiorm many other steps.

If I start explaining , it may take many pages. The best thing u can do in this regard is watch this video.

http://channel9.msdn.com/Showpost.aspx?postid=209464

Are u trying to run this in a pocket PC/mobile device.?

f yes, make sure it is connected to INternet.

Either through Active Sync or through GPRS.

-Aneesh

an easy question....

I have to connect to a SQL server 2000 database from a VB6 application that runs on a different PC....
PC name = FR_SERVER
SQL server name = FR_SERVER
file name = SQLlab_data.mdf
database name=SQLlab

thank you
Degia

Missing question:
I tried different connectionStrings, but I get a lot of different errors....

|||Try http://www.connectionstrings.com/.|||

Hi degia,

What are the exact connection strings and the corresponding errors messages that you're seeing? Also, have you checked the firewall settings on your server? These KB articles may be of some assistance for configuring the firewall:

http://support.microsoft.com/kb/287932/en-us
http://support.microsoft.com/kb/841249/en-us

Thanks,
Il-Sung

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UNC
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true
"Uri Dimant" wrote:
> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me two
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:
> Assuming you are using the default settings, the .mdf and .ldf files must be
> located in the same directory as your application on the server. The other
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >I have a problem with Microsoft SQL Server 2005 Express,
> > My web application runs fine on my development PC, but when I copy it to
> > my
> > server (My server is running Windows 2000 Server) and try to access it
> > from
> > the web I get following error:
> >
> > An attempt to attach an auto-named database for file
> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> > same name exists, or specified file cannot be opened, or it is located on
> > UNC
> > share.
> >
> > The ASPNET account has full control of the database.
> > Is this a known bug in Microsoft SQL Server?
> > What should I do?
> >
> > Thanks for your help in advance,
> >
> > Noah.
> >
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>> Assuming you are using the default settings, the .mdf and .ldf files must
>> be
>> located in the same directory as your application on the server. The
>> other
>> common cause for this is having the database open in the IDE or having
>> the
>> database files with no write permissions for the ASPNET account. There
>> is
>> more info here:
>> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Noah" <Noah@.discussions.microsoft.com> wrote in message
>> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>> >I have a problem with Microsoft SQL Server 2005 Express,
>> > My web application runs fine on my development PC, but when I copy it
>> > to
>> > my
>> > server (My server is running Windows 2000 Server) and try to access it
>> > from
>> > the web I get following error:
>> >
>> > An attempt to attach an auto-named database for file
>> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
>> > the
>> > same name exists, or specified file cannot be opened, or it is located
>> > on
>> > UNC
>> > share.
>> >
>> > The ASPNET account has full control of the database.
>> > Is this a known bug in Microsoft SQL Server?
>> > What should I do?
>> >
>> > Thanks for your help in advance,
>> >
>> > Noah.
>> >
>>|||Yes.
"Roger Wolter[MSFT]" wrote:
> So, you eliminated one of the three things I suggested. How about the other
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
> > As I said... The ASPNET account has full control of the database and of
> > the
> > application root folder.
> > Read, Write, Modify, etc.
> > I thought that was the problem, but it isn't. I had already given the
> > ASPNET
> > account full control when I had problems with a hit counter. That took me
> > two
> > days to figure out...
> > Anyway,
> > With the info you have now what do you suggest I do?
> >
> > Thanks,
> > Noah.
> >
> > "Roger Wolter[MSFT]" wrote:
> >
> >> Assuming you are using the default settings, the .mdf and .ldf files must
> >> be
> >> located in the same directory as your application on the server. The
> >> other
> >> common cause for this is having the database open in the IDE or having
> >> the
> >> database files with no write permissions for the ASPNET account. There
> >> is
> >> more info here:
> >>
> >> http://msdn.microsoft.com/sql/express/default.aspx?pull=/library/en-us/dnsse/html/sqlexpuserinst.asp
> >>
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >> Use of included script samples are subject to the terms specified at
> >> http://www.microsoft.com/info/cpyright.htm
> >>
> >> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> >> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
> >> >I have a problem with Microsoft SQL Server 2005 Express,
> >> > My web application runs fine on my development PC, but when I copy it
> >> > to
> >> > my
> >> > server (My server is running Windows 2000 Server) and try to access it
> >> > from
> >> > the web I get following error:
> >> >
> >> > An attempt to attach an auto-named database for file
> >> > C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with
> >> > the
> >> > same name exists, or specified file cannot be opened, or it is located
> >> > on
> >> > UNC
> >> > share.
> >> >
> >> > The ASPNET account has full control of the database.
> >> > Is this a known bug in Microsoft SQL Server?
> >> > What should I do?
> >> >
> >> > Thanks for your help in advance,
> >> >
> >> > Noah.
> >> >
> >>
> >>
> >>
>
>

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UNC
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.
Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>
|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/expres...xpuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>
|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDirectory|aspn etdb.mdf;User Instance=true
"Uri Dimant" wrote:

> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>
|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me two
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:

> Assuming you are using the default settings, the .mdf and .ldf files must be
> located in the same directory as your application on the server. The other
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/expres...xpuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>
|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...[vbcol=seagreen]
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
|||Yes.
"Roger Wolter[MSFT]" wrote:

> So, you eliminated one of the three things I suggested. How about the other
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
>
>

An attempt to attach an auto-named database failed

I have a problem with Microsoft SQL Server 2005 Express,
My web application runs fine on my development PC, but when I copy it to my
server (My server is running Windows 2000 Server) and try to access it from
the web I get following error:
An attempt to attach an auto-named database for file
C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
same name exists, or specified file cannot be opened, or it is located on UN
C
share.
The ASPNET account has full control of the database.
Is this a known bug in Microsoft SQL Server?
What should I do?
Thanks for your help in advance,
Noah.Noah
How do you perform an attach operation?
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||Assuming you are using the default settings, the .mdf and .ldf files must be
located in the same directory as your application on the server. The other
common cause for this is having the database open in the IDE or having the
database files with no write permissions for the ASPNET account. There is
more info here:
http://msdn.microsoft.com/sql/expre...expuserinst.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>I have a problem with Microsoft SQL Server 2005 Express,
> My web application runs fine on my development PC, but when I copy it to
> my
> server (My server is running Windows 2000 Server) and try to access it
> from
> the web I get following error:
> An attempt to attach an auto-named database for file
> C:\Inetpub\okbehappy.net\App_Data\aspnetdb.mdf failed. A database with the
> same name exists, or specified file cannot be opened, or it is located on
> UNC
> share.
> The ASPNET account has full control of the database.
> Is this a known bug in Microsoft SQL Server?
> What should I do?
> Thanks for your help in advance,
> Noah.
>|||I use the following command:
data source=.\SQLEXPRESS;Integrated
Security=SSPI;AttachDBFilename=|DataDire
ctory|aspnetdb.mdf;User Instance=tru
e
"Uri Dimant" wrote:

> Noah
> How do you perform an attach operation?
>
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>|||As I said... The ASPNET account has full control of the database and of the
application root folder.
Read, Write, Modify, etc.
I thought that was the problem, but it isn't. I had already given the ASPNET
account full control when I had problems with a hit counter. That took me tw
o
days to figure out...
Anyway,
With the info you have now what do you suggest I do?
Thanks,
Noah.
"Roger Wolter[MSFT]" wrote:

> Assuming you are using the default settings, the .mdf and .ldf files must
be
> located in the same directory as your application on the server. The othe
r
> common cause for this is having the database open in the IDE or having the
> database files with no write permissions for the ASPNET account. There is
> more info here:
> http://msdn.microsoft.com/sql/expre...expuserinst.asp
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:227BE70D-49A8-4987-8CF3-DCADFDEE777E@.microsoft.com...
>
>|||So, you eliminated one of the three things I suggested. How about the other
two? Di reading the article give you any things to try?
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Noah" <Noah@.discussions.microsoft.com> wrote in message
news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...[vbcol=seagreen]
> As I said... The ASPNET account has full control of the database and of
> the
> application root folder.
> Read, Write, Modify, etc.
> I thought that was the problem, but it isn't. I had already given the
> ASPNET
> account full control when I had problems with a hit counter. That took me
> two
> days to figure out...
> Anyway,
> With the info you have now what do you suggest I do?
> Thanks,
> Noah.
> "Roger Wolter[MSFT]" wrote:
>|||Yes.
"Roger Wolter[MSFT]" wrote:

> So, you eliminated one of the three things I suggested. How about the oth
er
> two? Di reading the article give you any things to try?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Noah" <Noah@.discussions.microsoft.com> wrote in message
> news:C270718F-C4ED-4D9D-9154-BE54671192B2@.microsoft.com...
>
>