A doubt about this: "Could not find stored Procedure"

Hi Everybody!

I have a problem in my SQL Server 2000 SP1 Database Called "Embossamento". When I run the following comand in the Query Analyzer, I have this error message :

command: exec dbcc_all_dbreindex
message: Could not find stored procedure 'dbcc_all_dbreindex'.

Otherwise, in the same server, but in another Database called "Autorizacao" I execute this dbcc_all_dbreindex with no problems.
Does anybody know why this happens?
I will be waiting for some reply, ok?
Thanks,This must be a custom stored procedure that uses the dbcc dbreindex command - check out the database, Autorizacao, and look for your stored procedures under that database.|||Ok! Thanks!
It worked! I just realized that my database did not have the procedure dbcc_all_dbreindex.
Now it's ok...

a Distinct Query

I have 2 tables as following :

tbl_Articles
3 ArticleID int
0 AuthorID int
0 ArticleTitle
0 ArticleText
0 ArticleDate

tbl_Authors
3 AuthorID
0 AuthorFullName
0 AuthorEmail
0 AuthorDescription
0 AuthorImage

I want to write a query to see the Authors and their last articles with no distinct values.
Like AuthorImage - AuthorFullName - ArticleTitle - ArticleDate

If anyone knows the solution i will be glad .
Thanks from now onselect AuthorImage, AuthorFullName, ArticleTitle, ArticleDate = aDate
from tbl_Authors a
inner join (
select AuthorID, aDate = max(ArticleDate)
from tbl_Articles) x
on a.AuthorID = x.AuthorID
inner join tbl_Articles b
on x.AuthorID = b.AuthorID
and x.aDate = b.ArticleDate|||another version:select AuthorImage
, AuthorFullName
, ArticleTitle
, ArticleDate
from tbl_Authors AUTH
inner
join tbl_Articles ART
on AUTH.AuthorID
= ART.AuthorID
where ART.ArticleDate
= ( select max(ArticleDate)
from tbl_Articles
where AuthorID
= AUTH.AuthorID )

a copy of SQLFile.sql please :: MS SQL 2005

when trying New Query in MS SQL 2005 management studio I get the following error :
cannot find the file
C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\sqlworkbe nchprojectitems\Sql\SQLFile.sql

is someone could paste me here the content of SQLFile.sql ?

thank youan emty file !
it works

A connection was successfully established with the server, but then an error occurred during the

Hi All,

When i'm trying to access a sql server from a different pc,i'm getting the following error..

Plz help me how to fix this..

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=64&LinkId=20476

Server Name: 10.11.144.145
Error Number: 64
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Regards,

Sailendra.

Hi ,

This problem generally occurs in windows 2003 server with service pack 1.

Solution is :-

Steps

<!--[if !supportLists]-->1. <!--[endif]-->regedit

<!--[if !supportLists]-->2. <!--[endif]-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\\Parameters

<!--[if !supportLists]-->3. <!--[endif]-->Add Dword value with name “SynAttackProtect” and set value “00000000 “in hexdecimal.

Regards
Rajesh

A connection was successfully established with the server, but then an error occurred during the

Hi All,

When i'm trying to access a sql server from a different pc,i'm getting the following error..

Plz help me how to fix this..

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=64&LinkId=20476

Server Name: 10.11.144.145
Error Number: 64
Severity: 20
State: 0

Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Regards,

Sailendra.

Hi ,

This problem generally occurs in windows 2003 server with service pack 1.

Solution is :-

Steps

<!--[if !supportLists]-->1. <!--[endif]-->regedit

<!--[if !supportLists]-->2. <!--[endif]-->HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\\Parameters

<!--[if !supportLists]-->3. <!--[endif]-->Add Dword value with name “SynAttackProtect” and set value “00000000 “in hexdecimal.

Regards
Rajeshsql

A connection was successfully established with the server, but then an error occurred during the

I get the following error when trying to view my page.

Can someone please help me with this error. What does it mean and what is the solution to it? Here is the complete error message. -

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

See following post:

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

HTH

Ming.

|||

Please check these two posts see whether it solves your problem

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

Otherwise, please check your errorlog file see if there is any abnormal.

A connection was successfully established with the server, but then an error occurred during

I get the following error when trying to view my page.

Can someone please help me with this error. What does it mean and what is the solution to it? Here is the complete error message. -

A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

See following post:

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

HTH

Ming.

|||

Please check these two posts see whether it solves your problem

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

Otherwise, please check your errorlog file see if there is any abnormal.

A connection remains open after calling Disconnect

Hi,

I would like to be able to connect to a SQL Server using SMO and then reconnect using a different login username and password.

In the following sample code I call svr.ConnectionContext.Disconnect. After the Disconnect call an attempt to change the timeout or any Login properties gives error:

Connection properties cannot be changed after connection has been made

Regards,

Joginder Nahil
www.starprint2000.com

Dim objServer As Server
objServer = New Server()
With objServer.ConnectionContext
.NonPooledConnection = True
.ConnectTimeout = 30
.LoginSecure = True
.Connect()

MsgBox("Connected. Database : " & objServer.Databases(0).Name)

.Disconnect()

' The following line gives error: Connection properties cannot be changed after connection has been made
.ConnectTimeout = 60
.LoginSecure = False
.Login="me"
.Password="pppp"

.Connect()
End With

Hi,

I have found a solution. You have to set the server object to nothing before the ConnectionContext is released and can be re-used as shown below:

Regards,
Joginder Nahil
www.starprint2000.com

Dim objServer As Server
objServer = New Server()

With objServer.ConnectionContext
.NonPooledConnection = True
.ConnectTimeout = 30
.LoginSecure = True
.Connect()

MsgBox("Connected. Database : " & objServer.Databases(0).Name)
.Disconnect()
End With

' Release the Server object only then the Connection is released
objServer= Nothing
objServer = New Server

With objServer.ConnectionContext
.ConnectTimeout = 60
.LoginSecure = False
.Login="me"
.Password="pppp"
.Connect()
End With

A connection could not be made with report server

I am new in SQL Server 2005. I am practicing report services and I got
following error:
"A connection could not be made with report server at
https://localhost/ReportServer "
Can anyone help?
DarrenIs SSL set up for the ReportServer virtual directory? What happens
when you connect to http://localhost/reportserver? What happens when
you navigate to http://<machinename>/ReportServer?
Andy Pottersql

A connection could not be made to the reporting server http://localhost/reportserver

Hi all,

When I build a simple project using the report wizard project.

When i deploy the report i get the following error.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>

<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span>

<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

</body>
</html>

--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

Could some one come to my rescue.

Thanx in advance.

Ronald

Is Reporting services installed on the machine you are designing on? If not, go to the project properties and change the report server url to the machine where Report Server is installed on.|||

I'm getting the exact same error, but I'm working off of the same machine. To clarify, SQL and MS Visual Studio are on the same machine -- I've created the report and tried to deploy in MSVS.

Note that this machine is part of a network governed by a file & print server.

I can get a valid web page at http://localhost that changes to http://localhost/default.aspx and displays a Home page to a Team Web Site.

But when I try http://lolcalhost/reportsserver, I get the following errors:

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'Microsoft.BusinessFramework' or one of its dependencies. The system cannot find the file specified. (c:\inetpub\wwwroot\web.config line 77)

Source Error:

Line 75: <add name="WindowsAuthentication" type="System.Web.Security.WindowsAuthenticationModule" /> Line 76: <!--<add name="Session" type="System.Web.SessionState.SessionStateModule"/>--> Line 77: <add name="EnterpriseInitializationModule" type="Microsoft.BusinessFramework.Security.EnterpriseInitializationModule,Microsoft.BusinessFramework" /> Line 78: <add name="BPAdminRedirectModule" type="Microsoft.BusinessFramework.Portal.Administration.BPAdminRedirectModule,Microsoft.BusinessFramework.Portal" /> Line 79: <add name="BPHomeRedirectModule" type="Microsoft.BusinessFramework.Portal.Shell.BPHomeRedirectModule,Microsoft.BusinessFramework.Portal" />

Source File: c:\inetpub\wwwroot\web.config Line: 77

---

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

Can you help?

A connection could not be made to the reporting server http://localhost/reportserver

Hi all,

When I build a simple project using the report wizard project.

When i deploy the report i get the following error.

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/ReportServer.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<?xml version="1.0" ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head>
<title>Server Unavailable
</title>
</head>
<body>
<h1><span style="font-family:Verdana;color: #ff3300">Server Application Unavailable
</span></h1>

<span style="font-family:Verdana;">
The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request.
</span>

<b>Administrator Note:
</b> An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

</body>
</html>

--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

Could some one come to my rescue.

Thanx in advance.

Ronald

Is Reporting services installed on the machine you are designing on? If not, go to the project properties and change the report server url to the machine where Report Server is installed on.

A connection could not be made to the report server

While attempting to deploy from within VS2005 running on 2003 server we get the following error:

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://xxxxx:90/ReportServer.

Running sql2005 sp2 integrated w Sharepoint 2007

Thanks..

Can you navigate to the Report manager surface ? on http://xxxx:90/reports ? Is Sharepoint running in the same port as the reporting server ?

Jens K. Suessmeyer.

http.77www.sqlserver2005.de

|||

Hi - no attempting to get to /reports generates the following error: The operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)

Sharepoint is port 80 - rs is 90.

admin is the service account and anon access is disabled on the web side

Hope that answers the questions - we are new to using rs and visual studio

V

|||

Anonymous,

What sku are do you have for SQL RS 2005 SP2? Share Point Integrated mode is supported only for Enterprise, Developer, Standard, and Evaluation.

Mihaela

|||

Hi - we are using SQL2005 Standard & SP Enterprise. Just to provide more detail if it helps...

We did the SQL install - installed the additional services (report, analysis etc..) - then loaded SP2.. The install for the RS was not the default - just files only.

We recreated in IIS another website RSSITE using port 90

Downloaded and installed the Report add-in for SP2007

Went into Report Config went through the options for a native install

We were able to get to http://xxxx:90/reports

We then changed the installation to SP integrated

We went into SP admin and followed the setup steps including creating a doc library

We could get to http://xxxx:90/reportserver (however there was nothing there)

We then followed these directions to get a model created: http://www.sharepointblogs.com/helloitsliam/archive/2007/03/04/20410.aspx

All went well until the deploy option -

all service accounts are the admin account and all actions were executed on the 2003 server..

Thanks - hope this is helpful info....

|||

Anonymous,

It seems that you have the right sku for Reporting Services to be able to work in Share Point Integrated mode.

When you are working in Share Point integrated mode, the Report Manager feature is disabled, so the error you see when you try to connect to ../reports after switching to Share Point mode is expectable.

I would like to ask you to take a look int he Report Server log files and to see what errors you find there and to post them here.

Thank you,

Mihaela

|||

w3wp!library!1!04/02/2007-21:45:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode.

Each time we run the deploy from the VS application we see this error in the <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__04_02_2007_21_28_51.log</Path>

No other RS logs seem to update and nothing in the event logs...

(Mon Apr 02 21:28:56 2007.205463218) : Received Event
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************
(Mon Apr 02 21:28:56 2007.205463234) : Could not get pointer to binary resource for file:
(Mon Apr 02 21:28:56 2007.205463234) : \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll[AspNetMofResource](Mon Apr 02 21:28:56 2007.205463234) :
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************

The above was in our wmiprov.log - dont know if it helps...

Thanks

|||I'm seeing the same error under the same set of circumstances. Have you been able to resolve the issue?sql

A connection could not be made to the report server

While attempting to deploy from within VS2005 running on 2003 server we get the following error:

TITLE: Microsoft Semantic Model Designer

A connection could not be made to the report server http://xxxxx:90/ReportServer.

Running sql2005 sp2 integrated w Sharepoint 2007

Thanks..

Can you navigate to the Report manager surface ? on http://xxxx:90/reports ? Is Sharepoint running in the same port as the reporting server ?

Jens K. Suessmeyer.

http.77www.sqlserver2005.de

|||

Hi - no attempting to get to /reports generates the following error: The operation is not supported on a report server that is configured to run in SharePoint integrated mode. (rsOperationNotSupportedSharePointMode)

Sharepoint is port 80 - rs is 90.

admin is the service account and anon access is disabled on the web side

Hope that answers the questions - we are new to using rs and visual studio

V

|||

Anonymous,

What sku are do you have for SQL RS 2005 SP2? Share Point Integrated mode is supported only for Enterprise, Developer, Standard, and Evaluation.

Mihaela

|||

Hi - we are using SQL2005 Standard & SP Enterprise. Just to provide more detail if it helps...

We did the SQL install - installed the additional services (report, analysis etc..) - then loaded SP2.. The install for the RS was not the default - just files only.

We recreated in IIS another website RSSITE using port 90

Downloaded and installed the Report add-in for SP2007

Went into Report Config went through the options for a native install

We were able to get to http://xxxx:90/reports

We then changed the installation to SP integrated

We went into SP admin and followed the setup steps including creating a doc library

We could get to http://xxxx:90/reportserver (however there was nothing there)

We then followed these directions to get a model created: http://www.sharepointblogs.com/helloitsliam/archive/2007/03/04/20410.aspx

All went well until the deploy option -

all service accounts are the admin account and all actions were executed on the 2003 server..

Thanks - hope this is helpful info....

|||

Anonymous,

It seems that you have the right sku for Reporting Services to be able to work in Share Point Integrated mode.

When you are working in Share Point integrated mode, the Report Manager feature is disabled, so the error you see when you try to connect to ../reports after switching to Share Point mode is expectable.

I would like to ask you to take a look int he Report Server log files and to see what errors you find there and to post them here.

Thank you,

Mihaela

|||

w3wp!library!1!04/02/2007-21:45:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedSharePointModeException: The operation is not supported on a report server that is configured to run in SharePoint integrated mode.

Each time we run the deploy from the VS application we see this error in the <Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__04_02_2007_21_28_51.log</Path>

No other RS logs seem to update and nothing in the event logs...

(Mon Apr 02 21:28:56 2007.205463218) : Received Event
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************
(Mon Apr 02 21:28:56 2007.205463234) : Could not get pointer to binary resource for file:
(Mon Apr 02 21:28:56 2007.205463234) : \\?\C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_isapi.dll[AspNetMofResource](Mon Apr 02 21:28:56 2007.205463234) :
(Mon Apr 02 21:28:56 2007.205463234) : ***************************************

The above was in our wmiprov.log - dont know if it helps...

Thanks

|||I'm seeing the same error under the same set of circumstances. Have you been able to resolve the issue?

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
The project could not be deployed to the 'localhost' server because of the following connectivity problems: A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

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

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

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

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?

A Connection cannot be made

Hello
I try to build my cube on localhost by VS2005, while the data source is on the other machine. When I deploy the cube, it gives me the following error msg:
The project could not be deployed to the 'localhost' server because of the following connectivity problems: A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server.
I tried to fix it by following the instruction, but it does not work. I think my target server should be localhost, since my cube is built on the localhost, is it right? And I check my MS SQL server 2005 has been upgraded to package 1.
I am new to VS 2005, and really appreciate any help.
Thank you so much!
Aurora

Did you install SQL Server Analysis Services?

Take a look in the SQL Server Configuration Manager and see if it is running.

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

|||I checked it already, it is running
|||

Can you connect to Analysis Server using SQL Management Studio? If yes, double check your project settings in BI Dev Studio. Try and use machine name instead of localhost as a Target server

Here is some information for you to troubleshoot connectivity problems: http://www.sqljunkies.com/WebLog/edwardm/

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

|||Thank you, I fixed it.|||Could you finger out how to fix it, please?sql

a complex query

I have the following SQL 2000 database table:
NEWS (IDNews, Country, PublishDate, Title)

I have to get a dataset containing only one record for each country, having most recent publish date.
Any suggestions? Thanks.SELECT TOP 1 IDNews, Country, PublishDate, Title From News Group By Country Order By PublishDate DESC?|||Try this:

select IDNews, Country, PublishDate, Title
from NEWS
where IDNews in
(
select
max(IDnews)
from news n
join
(select
country, max(publishdate) as publishdate
from news
group by country) md
on n.country = md.country
and n.publishdate = md.publishdate
group by n.country
)|||

select
 news.*
from
 news
 inner join
 (select
 country, max(publishdate) as publishdate
 from
 news
 group by
 country
 ) as TMP
 on news.country = TMP.country
 and news.publishdate = TMP.publishdate

sql

A challenging CUBE related question

Hi,

I have data coming in from our OLTP's view which has the following sales related information:

1) Date of Sale
2) Product Sold
3) Customer to which the Product was sold
4) QTy. sold
5) Total Sale Amount

I am bringing in this information into my "staging area" and from there I am building my Customer, Product, and Time Dimension and obviously my FACT table. The measures in my fact table were TotalSalesand Total QtySold and everything was working fine and I was able to analyze, slice, dice my cube in many ways...

Now the problem:

I also have planning related data available from another OLTP based view which contains the following information:

1) Plan Year
2) Plan Month (using Plan Year and Plan month,I "derived" a date which for any month was the 1st of that month)
3) Planned Product
4) Planned Sale (Amount)
5) Planned Qty (for sale)

You would have noticed that planning is NOT done at "Customer Level" and the planning data is only for product and time level (and that too only upto month level).

After populating my FAct table from the Sales data, I appended the planning related data into my fact table hoping that as long as I do not select any thing in the Customer dimesion and only go as low as the month level on my Time dimension, I will be able to see all of the following (measures) for any/all products:

Planned Sale, Actual Sale, Planned Qty., Actual Qty,

However I am unable to get anything displayed in the Planned Sale and Planned Qty despite applying all of the little knowledge that Ihave so far in the world of BI and making data marts
...

I really hope that my questions and requirement is clear.Can someone please help me get to

the solution.

Many many TIA.I hope I understand you correctly. If I did, I would have thought of doing the following (thinking from OLAP standpoint):

Dimensions:
- Create shared dimension for Time to support Date of Sale and Plan Month, Year
- Create shared dimension for Product

Cubes/facts:
- Create two separate cubes one for Actual and one for Planned using the shared dimensions. The Actual can have the Customer as a Private Dimension (it may help to design the customer also as a shared dimension).
- Create a virtual cube on top of the Actual and Planned.
- Create calculated measures for differentials between Actual and Planned.

Murthy

A big, big SSIS for everything?

Dear all,

I would like to hear point of views, thoughts and ideas about the following request.

As some of us would have seen from a couple a days ago I’ve been setting posts one after one in order to obtain some answers about our business basis.

We’ve got a service running all day long (to accomplish this it was wrote by Visual Basic 6.0) which is checking up a file structure system for a several requirements such a verify if exists a .nul or .txt in each folder and therefore fires a DTS package. Up to here that’s fine, that system works amazing and even is be able to run till three packages at the same time. 400 Dts are scheduled this way and 100 are scheduled by Agent.

Problem comes naturally with SQL2005 where such control is not possible (it seems so) from old tools belonging to Visual Studio 6.0 because the aforementioned version uses assemblies instead of dll, bla,bla.

Keeping in mind that .NET is not possible for reasons that going beyond of any technical matter or whatever I’ve thought do that service by SSIS. A big SSIS running forever. Its responsabilities might be:

1-Look in each folder for the criteria specified in the scheduling of that SSIS

2-Launch a specified SSIS in the case that criteria has matched.

3-Update SQL tables with LOGS, times, executions, etc,

4-Look again

The point 3 will be visible from our Intranet via ASP 3.0 pages as currently we do.

Pros and cons?

Sorry for this painful request but I don’t believe that such issue can be of that kind of odd issues that nodoby suffer in its organizations.

Who else is needed for answers?

Thanks a lot for your time,

I'm not quite sure what your question is. Are you saying you want to run a SSIS package forever that simply keeps looping whenever a file is found? I don't see a problem with that. it would be interesting to see how it goes.

-Jamie

|||

When finds a Jamie.Nul file in d:\server25k\a\ launch SSIS package B and then would delete that .NUL.

Sensible information attached in that SSIS launched as flat file for example, accounts info would be stored in a backup folder. After one execution come back to verify and so on

A basic sql query problem

Suppose we get two following tables:

Table A:
[USER_ID] [varchar] (11) NOT NULL ,
[COURSE_ID] [varchar] (11) NOT NULL ,

Table B:

[COURSE_ID] [varchar] (11) NOT NULL ,
[COURSE_NAME] [varchar] (50) NOT NULL ,
[COURSE_NO] [varchar] (15) NULL ,
[BEGIN_DATE] [datetime] NULL ,
[END_DATE] [datetime] NULL ,
[CREATER] [varchar] (11) NOT NULL ,

and during the execution of my program, I can get the current use's id (USER_ID), sayU0001.

How can I retrieve the result set containing[COURSE_NAME],[COURSE_ID],but the current user's id (U0001) have Not been assigned in Table A.

Thanks in advance.

Ricky.

if u know what the course will be taken by the userid U0001 then just query from table B and insert the data of user in the table A.say u want to assign the user U0001 to "Eng01" query with select course_id,course_name from tableB where course_name ='Eng01' and then assign this course_id and user_id to tableA...it is not clear to me that what u wants to do ?|||

Are you talking about joining between two table?

If yes, try SELECT TableA.User_ID, TableB.CourseID, TableB.Course_Name FROM TableB LEFT OUTER JOIN TableA ON TableA.CourseID = TableB.CourseID

I haven't test it yet, but try searching for "LEFT OUTER JOIN" if it doesn't work.

Hope that help.

|||

Sorry for my unclear description of my question first.

And nr2ea, you provide me helpful hint.

I have one more question: is there any difference between LEFT JOIN and LEFT OUTER JOIN?

Ricky.

A .cmd file can be run on SQL7, but not on SQL2000

Hi,
I have a command file with the following SQL statement:
bcp "SELECT * FROM [%dbname%].[dbo].[%1] WHERE DATEDIFF(hour,TimeStamp,
DATEADD(n, -DATEPART(n,getdate()), getdate())) <=24" queryout %CurDate%.tmp
-U -P -f %formatfile%
I can run this file on a machine with SQL7 installed, but have error when I
run it on a machine with SQL2000. Here is the error:
SQLState = 08001, Native Error=17
Error=[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.
SQLState = 01000, Native Error=2
Warning=[Microsoft][ODBC SQL Server Driver][Shared
Memory]ConnectionOpen(Connect()).
Does anyone know where is the problem? How can I fix it?
Thanks for the support!
On Thu, 30 Mar 2006 09:56:02 -0800, June wrote:

>Hi,
>I have a command file with the following SQL statement:
>bcp "SELECT * FROM [%dbname%].[dbo].[%1] WHERE DATEDIFF(hour,TimeStamp,
>DATEADD(n, -DATEPART(n,getdate()), getdate())) <=24" queryout %CurDate%.tmp
>-U -P -f %formatfile%
>I can run this file on a machine with SQL7 installed, but have error when I
>run it on a machine with SQL2000. Here is the error:
>SQLState = 08001, Native Error=17
>Error=[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
>exist or access denied.
>SQLState = 01000, Native Error=2
>Warning=[Microsoft][ODBC SQL Server Driver][Shared
>Memory]ConnectionOpen(Connect()).
>Does anyone know where is the problem? How can I fix it?
>Thanks for the support!
Hi June,
Some things to check:
- Are you sure the SQL Server 2000 service is running, and that the
computer that runs this script and the server where SQL Server is
installled can "see" each other?
- Try adding the "-S servername[\instance_name]" argument
- Try using a trusted connection instead of a SQL Server login (ie
replace the "-U -P" arguments with "-T").
- If you can't use a trusted connection, double-check that SQL Server is
configured to allow "Mixed Mode Authentication". The default is "Windows
Authentication", which allows only trusted connections. Also, add userid
and password to the command string (i.e. replace "-U -P" with "-U userid
-P password").
- Check the Client Network Utility on the workstation and the Server
Network Utility on the server. Are the same protocols enabled? Are the
properties the same? If there are any firewalls between the workstation
and the server, have you made sure that the prots required for SQL
Server are not blocked?
Hugo Kornelis, SQL Server MVP
|||Hi Hugo,
Thanks for your info.
1. Both the command file and SQL server are running on the same machine
(Win2000).
2. I have tried to add -S [instance_name] parameter to the command line, but
I got similar error messages:
SQLState = 08001, Native Error=17
Error=[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
SQLState = 01000, Native Error=53
Warning=[Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen(Connect()).
3. I also tired to replace -T with -U -P, still got the same error.
What else should I try?
Thanks again!
"Hugo Kornelis" wrote:

> On Thu, 30 Mar 2006 09:56:02 -0800, June wrote:
>
> Hi June,
> Some things to check:
> - Are you sure the SQL Server 2000 service is running, and that the
> computer that runs this script and the server where SQL Server is
> installled can "see" each other?
> - Try adding the "-S servername[\instance_name]" argument
> - Try using a trusted connection instead of a SQL Server login (ie
> replace the "-U -P" arguments with "-T").
> - If you can't use a trusted connection, double-check that SQL Server is
> configured to allow "Mixed Mode Authentication". The default is "Windows
> Authentication", which allows only trusted connections. Also, add userid
> and password to the command string (i.e. replace "-U -P" with "-U userid
> -P password").
> - Check the Client Network Utility on the workstation and the Server
> Network Utility on the server. Are the same protocols enabled? Are the
> properties the same? If there are any firewalls between the workstation
> and the server, have you made sure that the prots required for SQL
> Server are not blocked?
> --
> Hugo Kornelis, SQL Server MVP
>
|||On Thu, 30 Mar 2006 14:55:01 -0800, June wrote:

>2. I have tried to add -S [instance_name] parameter to the command line, but
>I got similar error messages:
Hi June,
The correct usage of -S is either
-S server_name
or
-S server_name\instance_name

>What else should I try?
If none of these option work, try posting to a different group. This
group is actually intended for support to the "Microssoft English Query"
tool. Precious few people visit here.
Since your question is about bcp, one of the tools that come with SQL
Server, microsoft.public.sqlserver.tools would be the best place to ask.
Hugo Kornelis, SQL Server MVP