SQL Alternative to cursor: connect

Showing posts with label connect. Show all posts

Sunday, March 25, 2012

Analysis Server database stop responding...

Hi, everyone, I'm new in SSAS... Yesterday I mapped a new hierachy to a perspective and then the database died... I tried to connect to it in Visual Studio and open it in Management Studio, however, neither responsed, then the delay notification appeared... Database engine and analysis service are alright, the tables are quite small (less then 50MB).

Dose anyone have ideas about this? Thanks a lot.

The version of my SQL Server is 9.00.2047.00, runs on Windows 2003 Server SP1.

Suspect your data got corrupted somehow.

Try stopping Analysis Server. Delete files from the database folder in the Analysis Server data folder.

Then start the server again and try re-deploying the project again.

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

|||

Ed:

Thanks for your reply. I think I've found the reason. This is not caused by my modifications on the SSAS db, one of our databases grew too fast and makes the server running slowly, our DBA has solved this problem.

regards,

Thursday, March 22, 2012

analysis server

How do I connect to the analysis server? I have installed 2005 and
manually started the analysis services (2005). However, when I tried
to use data source view wizard (after creating a data source
AdventureWorksDW) I got an error message 'sql server does not exist or
access denied'. I am new to analysis services and trying to jump start
the 2005 tutorials. By the way, where is this database? I tried to
locate it on the SQL server and its not there. How do browse objects
on Analysis Server? I can not even connect to the Analysis Server
using SSMS even though I have started the analysis service. I got an
error message, 'encure that sql browser is running'. It is running!
Thanks.On Sep 17, 12:07 pm, SB <othell...@.yahoo.com> wrote:
> How do I connect to the analysis server? I have installed 2005 and
> manually started the analysis services (2005). However, when I tried
> to use data source view wizard (after creating a data source
> AdventureWorksDW) I got an error message 'sql server does not exist or
> access denied'. I am new to analysis services and trying to jump start
> the 2005 tutorials. By the way, where is this database? I tried to
> locate it on the SQL server and its not there. How do browse objects
> on Analysis Server? I can not even connect to the Analysis Server
> using SSMS even though I have started the analysis service. I got an
> error message, 'encure that sql browser is running'. It is running!
> Thanks.
Now I am getting another error and asking for user id and password for
AdventureWorksDW! The sa password for sql server does not work. I am
getting login failed message after I modified the data source. This is
all done on my local SQL server PC.|||On Sep 17, 12:07 pm, SB <othell...@.yahoo.com> wrote:
> How do I connect to the analysis server? I have installed 2005 and
> manually started the analysis services (2005). However, when I tried
> to use data source view wizard (after creating a data source
> AdventureWorksDW) I got an error message 'sql server does not exist or
> access denied'. I am new to analysis services and trying to jump start
> the 2005 tutorials. By the way, where is this database? I tried to
> locate it on the SQL server and its not there. How do browse objects
> on Analysis Server? I can not even connect to the Analysis Server
> using SSMS even though I have started the analysis service. I got an
> error message, 'encure that sql browser is running'. It is running!
> Thanks.
Now I am getting another error and asking for user id and password
for
AdventureWorksDW! The sa password for sql server does not work. I am
getting login failed message after I modified the data source. This
is
all done on my local SQL server PC. I have changed the server from
'localhost' (data source designer) to the instance of sql 2005 on my
machine.|||Is SQL Server Browser service perhaps running as a Network Service? Are there
any SSAS related messages in the SQL Server Error Log?
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/|||On Sep 17, 3:24 pm, ML <M...@.discussions.microsoft.com> wrote:
> Is SQL Server Browser service perhaps running as a Network Service? Are there
> any SSAS related messages in the SQL Server Error Log?
> ML
> --
> Matija Lah, SQL Server MVPhttp://milambda.blogspot.com/
Thanks. I have everything (sql server, analysis server) installed on
my local pc.|||You haven't answered any of my questions. Using the SQL Server Configuration
Manager make sure the SQL Server Browser service is using a Local System
account or a dedicated user account, and not the Network Service account.
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/|||On Sep 18, 12:54 pm, ML <M...@.discussions.microsoft.com> wrote:
> You haven't answered any of my questions. Using the SQL Server Configuration
> Manager make sure the SQL Server Browser service is using a Local System
> account or a dedicated user account, and not the Network Service account.
> ML
> --
> Matija Lah, SQL Server MVPhttp://milambda.blogspot.com/
Ok thanks. I got it working.

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Pete, A coworker of mine helped me figure this. I knew there was somethign wrong with the Jet engine on my machine but repeated attempts to fix the Jet did not seem to help. Finally we used Microsoft Access Driver (shown below) instead of the OLEDB JET

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

While trying to connect to a remote Analysis Server using Analysis Manager, I get the following error in a pop up window:

=================================================

Analysis Manager:

Cannot connect to repository.

Analysis Server: <server name>.

Error:

Provider cannot be found. It may not be properly installed.

=================================================

Can somebody help?

Thanks,

John T

Please try this:

- with Analysis Manager, right click on the server item (or the server name) and use "Edit Repository Connection String"

- there are 2 connection strings there: the local one (for the client running on the AS2000 server machine) and the remote one; from the error message, it seems that the remote one is improperly set

Adrian.

|||

Adrian, I checked th connection string. It matches the connection string on my other machine from which I can connect without any issues. Any thoughts?

John T

|||my problem was that i was using jet 3.5 not 4.0 there is a solution for creating a connection string here:
http://support.microsoft.com/?kbid=330244|||

Driver={Microsoft Access Driver (*.mdb)};Dbq=\\<servername>\MsOLAPRepository$\msmdrep.mdb

Thank you for you help.

John T

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.

Tuesday, March 20, 2012

An Unknown error has occured in WMI provider

Hi All,

I am new to sql server 2005.

I tried to connect to reporting services configuration manager.

it gives an error

An Unknown error has occured in WMI provider.

error code 80040219.

so please help me out regarding this issue.

Hi sandy_patil,
I encounter the same error as well. Did you manage to fix this error?

Daren|||I have the same error.

Uninstalled SQL Server 2005 Express and installed SQL Server 2005 Standard edition. Go to configure the "Report Service" and got the same error. Uninstalled 2005 many times and still not working.

Henry|||

I had the same problem, accompanied by the following error in the event log:

The description for Event ID ( 133 ) in Source ( Report Server ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config.

Since the system seemed to be looking for
C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config
I tried copying another of the MSSQL.x directories (containing Reporting Services) to
C:\Program Files\Microsoft SQL Server\MSSQL.3

I'm not sure if this is a complete solution, but it resolved the 8004219 error. It will be interesting to see if it causes any other problems.

|||

I eventually realized that the MSSQL.3 reference was related to an instance called "SQL2005" that was left over from a previous install of an SQL Server evaluation copy. The mysterious "SQL2005" instance kept reappearing so many times that I started thinking it was supposed to be there. After finally getting rid of it (not fun), I think the 80040219 error might be solved correctly now.

Here are some links about manually removing a stubborn instance:
http://support.microsoft.com/kb/909967
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1

Neither msiexec nor msizap were very effective for me. I eventually found myself deleting files and registry entries manually, with my fingers crossed ...

|||Thanks for the tips. I eventaully uninstall sql server 2005 and followed this simple steps http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx
to remove old instance. It works now.sql

An Unknown error has occured in WMI provider

Hi All,

I am new to sql server 2005.

I tried to connect to reporting services configuration manager.

it gives an error

An Unknown error has occured in WMI provider.

error code 80040219.

so please help me out regarding this issue.

Hi sandy_patil,
I encounter the same error as well. Did you manage to fix this error?

Daren|||I have the same error.

Uninstalled SQL Server 2005 Express and installed SQL Server 2005 Standard edition. Go to configure the "Report Service" and got the same error. Uninstalled 2005 many times and still not working.

Henry|||

I had the same problem, accompanied by the following error in the event log:

I'm not sure if this is a complete solution, but it resolved the 8004219 error. It will be interesting to see if it causes any other problems.

|||

Neither msiexec nor msizap were very effective for me. I eventually found myself deleting files and registry entries manually, with my fingers crossed ...

|||Thanks for the tips. I eventaully uninstall sql server 2005 and followed this simple steps http://blogs.msdn.com/astebner/archive/2005/12/08/501885.aspx
to remove old instance. It works now.

Sunday, March 11, 2012

An exception occurred during the DBComms.receive method.

I am getting SQLException when I connect SQL Server 2005. I would like to know how to correct this problem.

I get this error randomly. Never seenit before. Sometimes I get this error one day later from application begins, sometimes two days later, sometimes 3 day later.

DBCP borrowObject failed: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context Sad 841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
org.apache.commons.dbcp.DbcpException: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
at org.apache.struts.util.GenericDataSource.getConnection(GenericDataSource.java:276)
at com.y.util.DbAccess.getConnection(DbAccess.java:29)
at com.y.biz.UserMgr.leftDays(UserMgr.java:404)
at com.y.action.LoginAction.login(LoginAction.java:194)
at sun.reflect.GeneratedMethodAccessor303.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280)
at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:220)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:446)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:266)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: An exception occurred during the DBComms.receive method. Operation:Connection reset. Context841) [Thread[http-8080-Processor18,5,main], IO:457d2, Dbc:1a642]. PktNum:0. TotalReceived:0. PktSize:4,096.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.DBComms.receive(Unknown Source)
at com.microsoft.sqlserver.jdbc.IOBuffer.sendCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.changeSettings(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:83)
... 44 more

Web Server:

CPU 2*1.66G, 4GB ram, 146GB

Windows 2003 Server

JDK 1.4.2

Tomcat 5.0

Driver Name: Microsoft SQL Server 2005 JDBC Driver

JDBC Driver Version 1.0

Use struts connection pool in application.

Database Server:

CPU 2*1.66G, 4GB ram, 4 x 146GB

Windows 2003 Server

SQL Server 2005, Product Version: 9.00.1399

Hello,

Do you get similar failures with the newest JDBC driver?

The latest driver can be downloaded at the link below. I would try the v1.1 or the V1.2 CTP drivers.

http://msdn2.microsoft.com/en-us/data/aa937724.aspx

Thanks,

Jaaved

|||

Use JDBC 1.2 now, but the error is same:

DBCP borrowObject failed: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
org.apache.commons.dbcp.DbcpException: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:85)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:184)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(Unknown Source)
at org.apache.commons.dbcp.AbandonedObjectPool.borrowObject(AbandonedObjectPool.java:117)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:110)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:312)
at org.apache.struts.util.GenericDataSource.getConnection(GenericDataSource.java:276)
at com.y.util.DbAccess.getConnection(DbAccess.java:29)
at com.y.biz.AccessRightMgr.getAccessRight(AccessRightMgr.java:135)
at org.apache.jsp.web.customer_005flist_jsp._jspService(customer_005flist_jsp.java:148)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:696)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:474)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:409)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:312)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1014)
at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:417)
at org.apache.struts.action.RequestProcessor.processActionForward(RequestProcessor.java:390)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:271)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1292)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:510)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:534)

All is same, just remove "An exception occurred during the DBComms.receive method."

|||

Is the exception "Connection Reset" or "Connection Reset by Peer"?

This class of exception means that SQL Server is terminating the connection prematurely. It can have many causes so I'd urge you to look at both the SQL Server Profiler Traces and the JDBC Driver Diagnostic Logs and try to determine what was the operation immediately before the connection was terminated.

Here is how to enabled Logging in the JDBC driver:

http://msdn2.microsoft.com/en-us/library/ms378517.aspx

Thanks,

Jaaved

An exception occurred during the DBComms.receive method.

I am getting SQLException when I connect SQL Server 2005. I would like to know how to correct this problem.

I get this error randomly. Never seenit before. Sometimes I get this error one day later from application begins, sometimes two days later, sometimes 3 day later.

Web Server:

CPU 2*1.66G, 4GB ram, 146GB

Windows 2003 Server

JDK 1.4.2

Tomcat 5.0

Driver Name: Microsoft SQL Server 2005 JDBC Driver

JDBC Driver Version 1.0

Use struts connection pool in application.

Database Server:

CPU 2*1.66G, 4GB ram, 4 x 146GB

Windows 2003 Server

SQL Server 2005, Product Version: 9.00.1399

Hello,

Do you get similar failures with the newest JDBC driver?

The latest driver can be downloaded at the link below. I would try the v1.1 or the V1.2 CTP drivers.

http://msdn2.microsoft.com/en-us/data/aa937724.aspx

Thanks,

Jaaved

|||

Use JDBC 1.2 now, but the error is same:

All is same, just remove "An exception occurred during the DBComms.receive method."

|||

Is the exception "Connection Reset" or "Connection Reset by Peer"?

Here is how to enabled Logging in the JDBC driver:

http://msdn2.microsoft.com/en-us/library/ms378517.aspx

Thanks,

Jaaved

An exception occurred during the DBComms.receive method.

I am getting SQLException when I connect SQL Server 2005. I would like to know how to correct this problem.

I get this error randomly. Never seenit before. Sometimes I get this error one day later from application begins, sometimes two days later, sometimes 3 day later.

Web Server:

CPU 2*1.66G, 4GB ram, 146GB

Windows 2003 Server

JDK 1.4.2

Tomcat 5.0

Driver Name: Microsoft SQL Server 2005 JDBC Driver

JDBC Driver Version 1.0

Use struts connection pool in application.

Database Server:

CPU 2*1.66G, 4GB ram, 4 x 146GB

Windows 2003 Server

SQL Server 2005, Product Version: 9.00.1399

Hello,

Do you get similar failures with the newest JDBC driver?

The latest driver can be downloaded at the link below. I would try the v1.1 or the V1.2 CTP drivers.

http://msdn2.microsoft.com/en-us/data/aa937724.aspx

Thanks,

Jaaved

|||

Use JDBC 1.2 now, but the error is same:

All is same, just remove "An exception occurred during the DBComms.receive method."

|||

Is the exception "Connection Reset" or "Connection Reset by Peer"?

Here is how to enabled Logging in the JDBC driver:

http://msdn2.microsoft.com/en-us/library/ms378517.aspx

Thanks,

Jaaved

Thursday, March 8, 2012

An error about & quot;[dbnmpntw]ConnectionOpen(CreateFile())".

Hi:
When I tried to connect SQL Server Databse which was on another machine,
using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
returned, and the error message was
"& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".Hi,
Use the SQL Client Configuration utility (from the machine u are connecting)
to create alias server name for the sql server using the TCP/IP protocol
specifying IP and port number.
And use this Alias name to connect to SQL server using TCP/IP
Thanks
Hari
MCDBA
"arxing" <cjx@.nbdx.cn> wrote in message
news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Hi:
> When I tried to connect SQL Server Databse which was on another
machine,
> using Microsoft OLEDB Provider for SQL Server, error 0x80040005 was
> returned, and the error message was
> "& #91;dbnmpntw]ConnectionOpen(CreateFile()
)".
>|||But if I don't installed SQL Client on the machine I am connecting, what can
I do?
thanks.
"Hari" <hari_prasad_k@.hotmail.com> д?
news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Use the SQL Client Configuration utility (from the machine u are
connecting)
> to create alias server name for the sql server using the TCP/IP protocol
> specifying IP and port number.
> And use this Alias name to connect to SQL server using TCP/IP
> --
> Thanks
> Hari
> MCDBA
> "arxing" <cjx@.nbdx.cn> wrote in message
> news:eAfe$8PWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> machine,
>|||You can also do this using the wizard to set up an ODBC=20
data source. Use the Client Configuration button.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||You can also do this when you set up the ODBC data source.=20
Use the Client Configuration button in the wizard.

>--Original Message--
>But if I don't installed SQL Client on the machine I am=20
connecting, what can
>I do?
>thanks.
>
>"Hari" <hari_prasad_k@.hotmail.com> =D0=B4=C8=EB=D3=CA=BC=FE
>news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
machine u are[vbcol=seagreen]
>connecting)
the TCP/IP protocol[vbcol=seagreen]
TCP/IP[vbcol=seagreen]
was on another[vbcol=seagreen]
0x80040005 was[vbcol=seagreen]
>
>.
>|||This utility is available even if you didn't install the SQL Client tools -
start -> run -> Cliconfg.exe.
Richard Waymire, MCSE, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
"arxing" <cjx@.nbdx.cn> wrote in message
news:O3sk4WSWEHA.4048@.TK2MSFTNGP12.phx.gbl...
> But if I don't installed SQL Client on the machine I am connecting, what
> can
> I do?
> thanks.
>
> "Hari" <hari_prasad_k@.hotmail.com> д?
> news:elatIOQWEHA.1128@.TK2MSFTNGP10.phx.gbl...
> connecting)
>

an Error 1058

Having problems connecting to database Enterprise manager
will let me connect but won't let me see any databases
just hangs. Have rebooted P.C. stopped the services etc.
When I Stop Sql server and re-start it says and instance
already running. Need help quickly.
Hi,
Go to Control Panel -- Admin tools - Services -- In the services list see
how many MSSQL Server instances are there in your macine.
I feel that you are trying to look into a diffrent server. To test this
login to Query anayzer and execute the below comamnd:
select name from master..sysdatabases
Thanks
Hari
MCDBA
"John Carlin" <anonymous@.discussions.microsoft.com> wrote in message
news:1e6101c4a2e5$81887230$a301280a@.phx.gbl...
> Having problems connecting to database Enterprise manager
> will let me connect but won't let me see any databases
> just hangs. Have rebooted P.C. stopped the services etc.
> When I Stop Sql server and re-start it says and instance
> already running. Need help quickly.

an Error 1058

Having problems connecting to database Enterprise manager
will let me connect but won't let me see any databases
just hangs. Have rebooted P.C. stopped the services etc.
When I Stop Sql server and re-start it says and instance
already running. Need help quickly.Hi,
Go to Control Panel -- Admin tools - Services -- In the services list see
how many MSSQL Server instances are there in your macine.
I feel that you are trying to look into a diffrent server. To test this
login to Query anayzer and execute the below comamnd:
select name from master..sysdatabases
Thanks
Hari
MCDBA
"John Carlin" <anonymous@.discussions.microsoft.com> wrote in message
news:1e6101c4a2e5$81887230$a301280a@.phx.gbl...
> Having problems connecting to database Enterprise manager
> will let me connect but won't let me see any databases
> just hangs. Have rebooted P.C. stopped the services etc.
> When I Stop Sql server and re-start it says and instance
> already running. Need help quickly.

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

Sunday, February 19, 2012

AMO <-> XMLA serialization?

I'm in the process of developing additional tooling to help auto-partition my cube, and I've developed some AMO code to connect to my AS database to do this.

What I'm worried about is the fact that there's no good way to keep my online instance in sync with the persisted source code. IE, if I make a change in dev mode and re-deploy, all my auto-created partitions will be destroyed.

What's the best way to deal w/ this? I suppose I could constantly re-generate a BIDS project from the server every time I wanted to make a change. Or, if there was some way to deserialize the BIDS project files (since they're all XMLA anyway), I could apply my AMO code to the updated the XMLA object definitions.

Have you looked at the Deployment Wizard. I am pretty sure it has the option of deploying a solution without overwritting the existing partitions.

Thursday, February 16, 2012

Am I physically connected to the server on the computer I am using

Hi All:

Is there a way to tell if I am connected to the server on the computer I am using to connect with?

I want to determine whether the connection is to the local server or a remote server.

Thanks.

Doug.

Doug,

The name of the server should appear in your 'Object Explorer' window. This will tell you whether you are connected to your local instance or a remote server.

Good Luck...

'Avarus animus nullo satiatur lucro - A greedy mind is satisfied with no (amount of) gain

|||

My fault, should have been more specific.

I am connecting to the server using ADO; is there any command, TSQL, etc that will let me know if the connection is to the local server?

|||

Execute the query (CommandText):

SELECT @.@.SERVERNAME

The return value will be the name of the Server you are connect with when the query is executed.

|||

Hi Arnie:

Perhaps I'm missing the point here... but would not that only give me the name of the local server, not the fact that I am actually sitting at the same workstation?

I did find another TSQL function called HOST_NAME() -- but I believe that returns the workstation name where the server resides, not the workstation I am sitting at?

So, I can get the host name and servername, but what I need is to know if there is a way to determine the I am physically at the workstation that hosts the server?

|||

I did some more testing.

I connected to a remote machine and the host_name() returned the workstation I was physically at, and the @.@.servername returned the name of the local server on the host machine (if there is no local server then it would return null, right?).

So it looks to me that those functions alone will not work, as I need to know if I was connected remotely (which was the case) and they did not seem to help.

Unless... what if I compared the DataSource of the connection string to the servername?

If the hostname = servername, and the datasource = servername, then I am connected locally?

Actually, now that I think about it... I don't even need hostname, but the servername.

If the datasource = servername, then I am connected locally, right?

|||

You are on the right track.

HOST_NAME() returns the client computer name.

@.@.SERVERNAME returns the SQL Server computer name/instance.

If the computer names don't match, the computers are different.

HOWEVER, the HOST_NAME() could be [MyComputer] and the @.@.SERVERNAME could be [MyComputer\SQLExpress] -a Named INSTANCE of SQL Server running on the computer [MyComputer]. So you would need to check for a backslash [\], and if present, use the portion of the @.@.SERVERNAME to the left of the backslash to compare with HOST_NAME().

DataSource = @.@.SERVERNAME 'should' always match. DataSource is the part of your connection string that directs the connection to a Server.

|||

Got it, thanks!

|||

Doug,

If you have Alerts on, then you will get this message.

I was half asleep. You can also use SERVERPROPERTY('MachineName') on the SQL Server. It will return the computer name without the Instance name -so you will NOT have to parse @.@.ServerName.

Just check

Code Snippet

IF host_name() <> serverproperty('machinename')
BEGIN
PRINT 'Remote Connection'
END
ELSE
BEGIN
PRINT 'Local Connection'
END

Am I physically connected to the server on the computer I am using

Hi All:

Is there a way to tell if I am connected to the server on the computer I am using to connect with?

I want to determine whether the connection is to the local server or a remote server.

Thanks.

Doug.

Doug,

The name of the server should appear in your 'Object Explorer' window. This will tell you whether you are connected to your local instance or a remote server.

Good Luck...

'Avarus animus nullo satiatur lucro - A greedy mind is satisfied with no (amount of) gain

|||

My fault, should have been more specific.

I am connecting to the server using ADO; is there any command, TSQL, etc that will let me know if the connection is to the local server?

|||

Execute the query (CommandText):

SELECT @.@.SERVERNAME

The return value will be the name of the Server you are connect with when the query is executed.

|||

Hi Arnie:

Perhaps I'm missing the point here... but would not that only give me the name of the local server, not the fact that I am actually sitting at the same workstation?

I did find another TSQL function called HOST_NAME() -- but I believe that returns the workstation name where the server resides, not the workstation I am sitting at?

So, I can get the host name and servername, but what I need is to know if there is a way to determine the I am physically at the workstation that hosts the server?

|||

I did some more testing.

So it looks to me that those functions alone will not work, as I need to know if I was connected remotely (which was the case) and they did not seem to help.

Unless... what if I compared the DataSource of the connection string to the servername?

If the hostname = servername, and the datasource = servername, then I am connected locally?

Actually, now that I think about it... I don't even need hostname, but the servername.

If the datasource = servername, then I am connected locally, right?

|||

You are on the right track.

HOST_NAME() returns the client computer name.

@.@.SERVERNAME returns the SQL Server computer name/instance.

If the computer names don't match, the computers are different.

DataSource = @.@.SERVERNAME 'should' always match. DataSource is the part of your connection string that directs the connection to a Server.

|||

Got it, thanks!

|||

Doug,

If you have Alerts on, then you will get this message.

I was half asleep. You can also use SERVERPROPERTY('MachineName') on the SQL Server. It will return the computer name without the Instance name -so you will NOT have to parse @.@.ServerName.

Just check

Code Snippet

IF host_name() <> serverproperty('machinename')
BEGIN
PRINT 'Remote Connection'
END
ELSE
BEGIN
PRINT 'Local Connection'
END

Am I missing something when trying to connect via ASP.NET 2.0?

I am at my wit's end trying to set up a simple test to retrieve some records from with ASP.NET and C#. I'm using the Express Edition on my development laptop. Whenever I try to run my application, I get the following error:

ERROR: 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)

I have researched this problem, and done everything I can find online to fix it but no avail. I have gone to SQL Server Configuration Manager and enabled Named Pipes and TCP/IP. I have stopped and restarted the server. Local and Remote connections (Both TCP/IP and Named Pipes) are enabled in the Surface Area Configuration. I added it to the Exceptions list of the Windows firewall. And yet nothing works. I can connect to it fine with Management Studio Express, but I am totally unable to connect to the database from within my code. I've spent probably about two weeks wracking my brain trying to figure this out; does anybody know what might be causing the problem and what could fix it?what does your connection string look like.|||"Server=ORPHEUS;Database=TestDB;User ID=sa;Password=mypass;Trusted_connection=False"

I've also tried specifyinig the instance of SQL Server (e.g. Server=ORPHEUS\SQLExpress) but that does not work either.
|||

If you're trying to connect to an instance name, then i'm pretty sure you have to specify it in your connection string.

Have you tried using the examples in the docs, like this one? http://msdn2.microsoft.com/en-us/library/ms247257.aspx

|||Well what do you know... turns out I wasn't specifying it in the right format.. I should have had it was "Database=ORPHEUS\\SQLEXPRESS".

Thanks a ton! Sometimes its the most obvious things that you end up missing...

Thursday, February 9, 2012

Alternative interfaces ?

Dear ALL,
I know if I want to connect to a remote MS SQL database I can use Enterprise
Manager directly (not much secure) or establish a vpn connection before
activating Enterprise Manager.
I'd like to know if there are Microsoft or Thirdy Party applications
(stand alone applications or via http) in order to get a connection to a
remote database without using Enterprise Manager.
Regards
Alberto Brivio
tel. 011-5813734Alberto
there are quite a lot of alternatives to EM. Although most of them are
not for free. You can try EMS SQL Manager http://www.sqlmanager.net/
which also has a free Lite version, or MS Web data Adminstrator at
http://www.microsoft.com/downloads/...&DisplayLang=en
Markus|||My experience has been that using EM/QA is MUCH faster if it is running on
the remote machine and I connect to the remote machine through the VPN
tunnel -rather than marshalling EM/QA through the VPN tunnel.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:%23dk92NLBHHA.4472@.TK2MSFTNGP03.phx.gbl...
> Dear ALL,
>
> I know if I want to connect to a remote MS SQL database I can use
> Enterprise Manager directly (not much secure) or establish a vpn
> connection before activating Enterprise Manager.
> I'd like to know if there are Microsoft or Thirdy Party applications
> (stand alone applications or via http) in order to get a connection to a
> remote database without using Enterprise Manager.
>
>
> Regards
>
> Alberto Brivio
>
> --
> tel. 011-5813734
>

Sunday, March 25, 2012

Analysis Server database stop responding...

Thursday, March 22, 2012

analysis server

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

Analysis Manager: Cannot connect to repository. Analysis Server: <server name>.

Analysis Manager Error

Tuesday, March 20, 2012

An Unknown error has occured in WMI provider

An Unknown error has occured in WMI provider

Sunday, March 11, 2012

An exception occurred during the DBComms.receive method.

An exception occurred during the DBComms.receive method.

An exception occurred during the DBComms.receive method.

Thursday, March 8, 2012

An error about & quot;[dbnmpntw]ConnectionOpen(CreateFile())".

an Error 1058

an Error 1058

an easy question....

Sunday, February 19, 2012

AMO <-> XMLA serialization?

Thursday, February 16, 2012

Am I physically connected to the server on the computer I am using

Am I physically connected to the server on the computer I am using

Am I missing something when trying to connect via ASP.NET 2.0?

Thursday, February 9, 2012

Alternative interfaces ?

SQL Alternative to cursor

Blog Archive

About Me