Analysis Service Connection Pooling

In SQL Server documentation it is mentioned that the SP3 Code sample contains
the Analysis Service Connection Pooling sample. Please help me in locating
the code sample.
Thanks in advance.
Manoj
http://msdn.microsoft.com/library/de...onnpooling.asp
Dave Wickert [MSFT]
dwickert@.online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
This posting is provided "AS IS" with no warranties, and confers no rights.
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:AF17E419-ED8D-4E97-AA3D-76A06BCFD465@.microsoft.com...
> In SQL Server documentation it is mentioned that the SP3 Code sample
contains
> the Analysis Service Connection Pooling sample. Please help me in locating
> the code sample.
> Thanks in advance.
> Manoj

analysis service

Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

ThanksOriginally posted by sjumma
Hi

I was doing steps on page 15 / 16 of attached sheet

I was doing the microsoft example about cube to setup DSN SOURCE CONNECTION to ACCESS database (food mart) when i do a test it works

but after i do design storage and go to Process the cube
it gives me error

'test connection failed because of an error in initializing provide
(microsoft) ODBC DRIVER manager data source name not found and no default driver specified

one more error found
Microsoft ODBC DRIVER MANAGER driver sql connect attr failed: IMOO6

Thanks

Ensure you have applied SP3. I'm pretty sure there is an MDAC upgrade.|||Hi

I have already upgraded with the patch but still does not work

Analysis Manager Remote Access

Hi,

I juste begin using Analysis Manager.

I want to know if i can create, process and manage cubes in a distant server.

I have the connection to the database on a distant server and i want to use Analysis Manager (installed on the server) from my PC (which have Anaylisi Manager Too).

I have just build a cube on my Analysis Manager with the server database but the cube does not appears on the Analysis Manager of the distant server.

Please help me, ;)

Thanks

moustachuAnalysis Services is in its second revision from Microsoft. It has a little while to go before it matures.

You can remotely administer an Analysis Services machine, but you need to have all of the datasources available on the remote machine with access to the data. Apparently the MMC application needs to get all metadata/dimension data for itself, rather than rely on the Analysis Services service to serve it up (ok, all together 5 times fast).

Good luck with it. I am hoping that AS makes many changes in the next revision.|||I thank you for your answer,

All the datasources are on the remote machine. But I do not Know How I can remotly administer an Analysis Services machine ?

moustachu

Originally posted by MCrowley
Analysis Services is in its second revision from Microsoft. It has a little while to go before it matures.

You can remotely administer an Analysis Services machine, but you need to have all of the datasources available on the remote machine with access to the data. Apparently the MMC application needs to get all metadata/dimension data for itself, rather than rely on the Analysis Services service to serve it up (ok, all together 5 times fast).

Good luck with it. I am hoping that AS makes many changes in the next revision.sql

Analysis Manager Error

I've been getting the following error message whenever I
try to connect to my remote server to work on some cubes.
"Cannot open connection to Analysis server 'WRPBI'
Error in data [possible data corruption]"
How can I fix it? I've reinstalled Analysis Manager but
it didn't help.
Thanks
Hi sacred,
You should apply SP3 for Analysis Services to the Analysis Services server.
If you are unable to upgrade the Analysis Services server to SP3, you can
also restore connectivity to the Analysis Server by replacing the
MSOLAP80.DLL,
MSOLAP80.RLL, MSMDGD80.DLL and MSMDCB80.DLL files on the client machine
with a
version equal to or less than the build number of your MSMDSRV.EXE
<><><><><><><><><><><><><><><><><><><><><><><><>
| Content-Class: urn:content-classes:message
| From: "sacred" <sacred21@.airpost.net>
| Sender: "sacred" <sacred21@.airpost.net>
| Subject: Analysis Manager Error
| Date: Wed, 29 Dec 2004 18:07:15 -0800
| Lines: 12
| Message-ID: <05dc01c4ee14$4852d080$a401280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcTuFEhSQNjxLD0AQgyujxk4ZUZu2w==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.clients
| Path: cpmsftngxa10.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.clients:29328
| NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.clients
|
| I've been getting the following error message whenever I
| try to connect to my remote server to work on some cubes.
|
| "Cannot open connection to Analysis server 'WRPBI'
| Error in data [possible data corruption]"
|
| How can I fix it? I've reinstalled Analysis Manager but
| it didn't help.
|
| Thanks
|
|
|
<><><><><><><><><><><><><><><><><><><><><><><><>
Yasemin Gunduz
Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.

An OLE DB error has occurred - Description: "Class not registered"

Hi

I have a package the connection of which is defined in a config file. When the source is on SQLserver, the package executes fine but when i change the connection to Oracle then i am getting this error.

TITLE: Microsoft Visual Studio

Error at DMND_PROBS_EXTRACT [Connection manager "DLWSDV18.PM"]: An OLE DB error has occurred. Error code: 0x80040154.
An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered".

Error at DMND_PROBS_EXTRACT [DEMANDPROBLEMDETAILS [1]]: The AcquireConnection method call to the connection manager "DLWSDV18.PM" failed with error code 0xC0202009.

ADDITIONAL INFORMATION:

Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)

BUTTONS:

OK

Please let me know if theres any solutions.

Thanks,

Vipul

Do you have the Oracle client tools installed?|||Yes Phil, there was some problem with my oracle install. I re-installed it and it worked.

An existing connection was forcibly closed by the remote host

It is very appreciated if someone can help me on this problem:

I have 2 machines, connected with workgroup (not domain machine), 1 is win2003 sp1, 1 is xp.

How can I connect SSAS from XP machine with windows authentication?

Looks the Native client fix the windows authentication with local user name.

When I connect from XP, my application with following codes:

string connstr = "Provider=MSOLAP.3;Data Source=amsserver;Password=accenture;User ID=administrator;Initial Catalog=MIP2ASProject";

AdomdConnection objConnection = new AdomdConnection();

// Assign the connection string and try to

//open a connection.

objConnection.ConnectionString = connstr;

objConnection.Open();

It give me this error:

An existing connection was forcibly closed by the remote host

First of all, you dont need the User ID and Password in the connection string if you are connecting using TCP/IP (you would use them only when connecting with HTTP using Basic auth).

Second, in order to use "Provider=MSOLAP.3" you will need to install "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" provider from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

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

|||

Hi Edward,

Yes, I have installed oledb AS9 provider.

If you think SSAS only support windows authentication which must use inside the domain, I really couldn't understand why oledbconnection works fine with same connection string?

I am not sure about whether impersonation belong to windows authentication, but, my testing prove that oledb can connect in this way, adomd can't.

BTW, thankful if anyone can let me know how to enable SSAS's anonymous connection?

Jerry

|||

it is an antivirus problem

uninstall antivirus and try again

what antivirus do you have?

|||

What version of ADOM.NET are you using?

Try downloading and installing "Microsoft ADOMD.NET " from http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

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

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 existing connection was forcibly closed by the remote host

Hi,

I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website:

A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I have also websites running with MySQL and those don't have this problem.
I searched google but I couldn't find usefull information on this problem.

Someone who knows what's going on here ?

All I've found untill now is that it has something to do with the server not responding within a certain time, and thus assuming the connection was closed.

I can't find how I can just let it reconnect again in stead of giving me this error message?

An established connection was aborted by the software in your host machine.

I am getting connection errors all over the place, in everything I'm doing related to native client and connection issues failing with my database. I have changed users, authentification from windows to sql, everything. The latest was when I tried to apply the properties of my existing OLE DB Connection editor, one that has been working fine up until today. Every time I try to reselect the database and table in the properties if this, it errors out with the below:

TITLE: Microsoft SQL Native Client

Communication link failure
TCP Provider: An established connection was aborted by the software in your host machine.

BUTTONS:

&Retry
Cancel

Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

Have you checked if remote connections are enabled for your server and what network protocols are available?

Please open SQL Server Surface Area Configuration tool and click 'Surface Area Configuraiton for Services and Connections' to set those settings.

An established connection was aborted by the software in your host machine.

I am getting connection errors all over the place, in everything I'm doing related to native client and connection issues failing with my database. I have changed users, authentification from windows to sql, everything. The latest was when I tried to apply the properties of my existing OLE DB Connection editor, one that has been working fine up until today. Every time I try to reselect the database and table in the properties if this, it errors out with the below:

TITLE: Microsoft SQL Native Client

Communication link failure
TCP Provider: An established connection was aborted by the software in your host machine.

BUTTONS:

&Retry
Cancel

Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

Have you checked if remote connections are enabled for your server and what network protocols are available?

Please open SQL Server Surface Area Configuration tool and click 'Surface Area Configuraiton for Services and Connections' to set those settings.

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 while receiving data: '10054(An existing connection was forcibly closed by th

What does this error mean? I get this in the transmission_status column of sys.transmission_queue

An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.

Also, does the number in this message correspond to error 10053 in sys.messages?

Thanks

It means that the peer is closing the connection during login, most likely due to lack of CONNECT permission on the endpoint. You need to attch the profiler to the peer and monitor the 'Security Audit/Audit Broker Login' and 'Broker/Broker connection' events.

10054 and 10053 are system errors (OS), they are WSAECONNRESET and WSAECONNABORTED. they are described here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winsock/winsock/windows_sockets_error_codes_2.asp

HTH,
~ Remus

|||

Thanks

What happened was that my certificates expired (set start date as 01/01/05 and neglected an expiry date)

An error occurred while receiving data: '10054(An existing connection was forcibly closed b

What does this error mean? I get this in the transmission_status column of sys.transmission_queue

An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.

Also, does the number in this message correspond to error 10053 in sys.messages?

Thanks

It means that the peer is closing the connection during login, most likely due to lack of CONNECT permission on the endpoint. You need to attch the profiler to the peer and monitor the 'Security Audit/Audit Broker Login' and 'Broker/Broker connection' events.

10054 and 10053 are system errors (OS), they are WSAECONNRESET and WSAECONNABORTED. they are described here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winsock/winsock/windows_sockets_error_codes_2.asp

HTH,
~ Remus

|||

Thanks

What happened was that my certificates expired (set start date as 01/01/05 and neglected an expiry date)

An error occurred while executing the query

Ferquently I am getting this error

An error occurred while executing the query.
ExecuteReader requires an open and available Connection. The connection's current state is closed.

ADDITIONAL INFORMATION:

ExecuteReader requires an open and available Connection. The connection's current state is closed. (System.Data)

If I refreshed the page it is working

Please help me why it is comming

Hi,

this the error becasue there is some problem with ur dataset.

click save all and close the soluton and then re-open the solution.

click refresh on the data set tab.

hope this helps...

An error occurred while established a connection

Hello

I am getting this err msg when trying to logon to my website on the web - on my machine there is no prob,

An error occurred while established a connection to the server.
When connection to Sql.S 2005, this failure may be caused by the fact that
under the default settings sql.s doesn't allow remote connection.
(provider ql.S Network interface, error:26- Error Location Server/Interface Specified)

(the files path is like in the web host s)

now this msg is related to the ASPNETDB.MDF (dont use sql.s db but this file)

thanks

Please check this blog for solutions:

http://blogs.msdn.com/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

|||

Do you have tcp/ip enabled on the server? If you connect from the local machine, you probably won't see the problem but when connecting from a remote machine, you will need tcp/ip enabled. Here are the steps from msdn:

Enable the TCP/IP protocol in SQL Server 2005. To do this, follow these steps:

1. Open SQL Server Configuration Manager. 2. Expand SQL Server 2005 Network Configuration. 3. Click Protocols for SQLInstanceName. SQLInstanceName is a placeholder for the name of the instance of SQL Server 2005. 4. Enable TCP/IP.

HTH

An error has occurred while establishing a connection to the server. When connecting to SQ

I get the following error and have been trying to figure out why I keep getting it. Initially, I had placed my project under wwwroot folder and ran it under IIS and it gave this error. Then I moved it to my local C drive and same thing. I am sharing this project with two other co-workers and all our config files and code files are same...they don't get this error but I do. I checked that SQL Server Client Network Utility has TCP/IP and the 'Named Pipes' enabled. I thought maybe I have setting in the Visual Studio 2005 that I'm not aware of that's causing this problem...it can't be the server since my co-workers aren't having this error and can't be anything in the code since all of us are sharing this project through vss. I dont' think using different version of .net framework can create this error. I changed the version from 2.0 to use 1.1x and it gave same error... Any help would be greatly appreciated. Thanks in advance.

Server Error in '/RBOdev' 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)] 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) +130 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 System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +84 System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +197 System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.GetConnectionHolder() +16 System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider.LoadPersonalizationBlobs(WebPartManager webPartManager, String path, String userName, Byte[]& sharedDataBlob, Byte[]& userDataBlob) +195 System.Web.UI.WebControls.WebParts.PersonalizationProvider.LoadPersonalizationState(WebPartManager webPartManager, Boolean ignoreCurrentUser) +95 System.Web.UI.WebControls.WebParts.WebPartPersonalization.Load() +105 System.Web.UI.WebControls.WebParts.WebPartManager.OnInit(EventArgs e) +497 System.Web.UI.Control.InitRecursive(Control namingContainer) +321 System.Web.UI.Control.InitRecursive(Control namingContainer) +198 System.Web.UI.Control.InitRecursive(Control namingContainer) +198 System.Web.UI.Control.InitRecursive(Control namingContainer) +198 System.Web.UI.Control.InitRecursive(Control namingContainer) +198 System.Web.UI.Control.InitRecursive(Control namingContainer) +198 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +692

---

Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

I actually figured out the problem. Under the <asp:WebpartManger> control, I had to specify Personalization-Enabled to "False"...I guess by default, if it is not set, it will be true...in that case, it'll look for a database in SQL Server 2005 which I"m not using...my database that I'm connecting to is in SQL Server 2000. However, the only thing that is still not clear to me is that my two other co-workers are sharing the same project with me using VSS. All their settings are the same as mine and clearly they had the WebpartManger and property for personalization was not set to false...but they did not get this error...why was I the only one getting it? Is there another location where the personalization property can be set to false? Thanks...

|||

Hi,

From your description, it seems that you are using WebParts feature in your website project, right?

Generally, when you are using WebParts in your application, it requires SQLExpress database, which is a built-in database in Microsoft Visual Studio 2005. Since webparts need personalization features , and all these personalization data would be stored in database.

Besides, in webparts there are several modes, including Browser,Design,Cateloge and etc. When you are in Browser mode, the personalization feature can be set in false status. But for other modes, it requires the personalization and database support.

Also, if you want to achieve personalization on the machine with a SQLServer 2000, you can use aspnet_regsql.exe tool to convert the ASPNETDB database in SQLExpress to your SQLServer database, and change the corresponding provider to achieve your personalization.

Thanks.

An error has occurred while establishing a connection to the server. error: 40

hi i got the following error message while connectiong to my sql server 2005

NB :i am connecting from the same pc where sq server is installed.

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) (Microsoft SQL Server, Error: 2)

Any idea?

Tarek

If you're using SQL Server 2005 Express, and you did the default install, and you're trying to connect using the sqlcmd utility, then you need to start sqlcmd like this:-

sqlcmd -S .\SQLEXPRESS

This is because the default for SQL Server Express is to install a named instance called SQLEXPRESS instead of the 'default' instance installed by other versions of SQL Server 2005.

|||I am using sql 2005 Enterprise editon on my laptop and I get the sam error. If someone knows how to resolve the problem please help, before sql 2005 I had sql 2000 installed. Thnx in advance .|||

Add me to the list of people having this problem.

Wylbur
============================

|||I installed sql server 2000 and run it. The problem solved. But I have to keep the 2000 running, otherwise, the problem will reappear.
|||Now THAT is vel-ly in-ter-es-tink.

OK guys: Does this suggest that there is a needed service that should be running at startup
but isn't?

... and, if so, which one(s)?

Wylbur
========================

|||

You can look at this blog for information on enabling remote connects. The blog is for the Express edition but this posting is applicable to all editions: https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Cheers,
Dan

|||

Having the same problem... here is how i resolved it.

Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server 2005 Surface Area Configuration.

Configure Surface Area for localhost -> Surface Area Configuration for Services and Connections

MSSQLSERVER + Database Engine -> Remote Connections

Select 'Local and remote connections' instead of 'Local connections only'

Select the appropriate option under this option, i picked Using both TCP/IP and named pipes.

An error has occurred while establishing a connection to the server. error: 40

hi i got the following error message while connectiong to my sql server 2005

NB :i am connecting from the same pc where sq server is installed.

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) (Microsoft SQL Server, Error: 2)

Any idea?

Tarek

If you're using SQL Server 2005 Express, and you did the default install, and you're trying to connect using the sqlcmd utility, then you need to start sqlcmd like this:-

sqlcmd -S .\SQLEXPRESS

This is because the default for SQL Server Express is to install a named instance called SQLEXPRESS instead of the 'default' instance installed by other versions of SQL Server 2005.

|||I am using sql 2005 Enterprise editon on my laptop and I get the sam error. If someone knows how to resolve the problem please help, before sql 2005 I had sql 2000 installed. Thnx in advance .|||

Add me to the list of people having this problem.

Wylbur
============================

|||I installed sql server 2000 and run it. The problem solved. But I have to keep the 2000 running, otherwise, the problem will reappear.
|||Now THAT is vel-ly in-ter-es-tink.

OK guys: Does this suggest that there is a needed service that should be running at startup
but isn't?

... and, if so, which one(s)?

Wylbur
========================

|||

You can look at this blog for information on enabling remote connects. The blog is for the Express edition but this posting is applicable to all editions: https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Cheers,
Dan

|||

Having the same problem... here is how i resolved it.

Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server 2005 Surface Area Configuration.

Configure Surface Area for localhost -> Surface Area Configuration for Services and Connections

MSSQLSERVER + Database Engine -> Remote Connections

Select 'Local and remote connections' instead of 'Local connections only'

Select the appropriate option under this option, i picked Using both TCP/IP and named pipes.

An error has occurred while establishing a connection to the server. error: 40

hi i got the following error message while connectiong to my sql server 2005

NB :i am connecting from the same pc where sq server is installed.

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) (Microsoft SQL Server, Error: 2)

Any idea?

Tarek

If you're using SQL Server 2005 Express, and you did the default install, and you're trying to connect using the sqlcmd utility, then you need to start sqlcmd like this:-

sqlcmd -S .\SQLEXPRESS

This is because the default for SQL Server Express is to install a named instance called SQLEXPRESS instead of the 'default' instance installed by other versions of SQL Server 2005.

|||I am using sql 2005 Enterprise editon on my laptop and I get the sam error. If someone knows how to resolve the problem please help, before sql 2005 I had sql 2000 installed. Thnx in advance .|||

Add me to the list of people having this problem.

Wylbur
============================

|||I installed sql server 2000 and run it. The problem solved. But I have to keep the 2000 running, otherwise, the problem will reappear.
|||Now THAT is vel-ly in-ter-es-tink.

OK guys: Does this suggest that there is a needed service that should be running at startup
but isn't?

... and, if so, which one(s)?

Wylbur
========================

|||

You can look at this blog for information on enabling remote connects. The blog is for the Express edition but this posting is applicable to all editions: https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Cheers,
Dan

|||

Having the same problem... here is how i resolved it.

Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server 2005 Surface Area Configuration.

Configure Surface Area for localhost -> Surface Area Configuration for Services and Connections

MSSQLSERVER + Database Engine -> Remote Connections

Select 'Local and remote connections' instead of 'Local connections only'

Select the appropriate option under this option, i picked Using both TCP/IP and named pipes.