failed to open rowset

i've been received this error while i want to preview my report.

Failed to open rowset.
[Microsoft][ODBC SQLServer Driver] Communication link failure.

why is this happen? and what should i do? when i check with query analyzer, all the data do appear.

thanks.

regards.Open the Report and Do Verify database|||Open the Report and Do Verify database

thank u so much madhi :)|||Did you solve the problem?|||Did you solve the problem?

i did.. and after make some correction on sql command, my program now successfully running :D

thank u..

have a nice day;)

Failed to get the call stack! error

I'm working with a team on a migration of a database from Sybase to SQL
Server 2000.
Currently I'm in the process of debugging a sequence of stored procedure
calls wich are relatively long and nested.
In the process of returning from the stored procedures, after the job done
in the lowest level of calls (within transactions) , I get the message:
Server: Msg 3701, Level 11, State 5, Procedure PCRMQDD00vInt, Line 771
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table
'#TRMCQDL0', because it does not exist in the system catalog.
Failed to get the call stack!
the temporary table was created at that stored procedure before some
subsequent calls. I just want to make sure I got the message right. Does thi
s
message mean the processe run out of memory? Is there a way to parametrize
the use of more memory or we need more RAM ?
thanks in advance
Jo?o CostaHi
You may be seeing this sort of issue (although this KB talks about 6.5!)
http://support.microsoft.com/defaul...kb;en-us;157570
http://support.microsoft.com/defaul...kb;en-us;827448
You may want to look at blocking [url]http://support.microsoft.com/kb/271509/EN-US/[/ur
l]
and possibly reducing the number of temporary tables you are using (possibly
using derived tables!)
John
"Jo?o Costa" wrote:

> I'm working with a team on a migration of a database from Sybase to SQL
> Server 2000.
> Currently I'm in the process of debugging a sequence of stored procedure
> calls wich are relatively long and nested.
> In the process of returning from the stored procedures, after the job done
> in the lowest level of calls (within transactions) , I get the message:
> Server: Msg 3701, Level 11, State 5, Procedure PCRMQDD00vInt, Line 771
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the table
> '#TRMCQDL0', because it does not exist in the system catalog.
> Failed to get the call stack!
>
> the temporary table was created at that stored procedure before some
> subsequent calls. I just want to make sure I got the message right. Does t
his
> message mean the processe run out of memory? Is there a way to parametrize
> the use of more memory or we need more RAM ?
> thanks in advance
> Jo?o Costa

failed to connect to sqlserver 2005

Hi
im trying to connect to sqlserver 2005 using windows authentication and gives me this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection."
any help

thanks in advance.
Are you connecting from the same domain. Is the computer on the same server as the conneciton application ? What is your connection string ? Which application are you using for conencting to the server ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||got it thanks
just remove the provider form the ConnectionString and enable the sa logins in sqlserver

failed to connect to sqlserver 2005

Hi
im trying to connect to sqlserver 2005 using windows authentication and gives me this error "Login failed for user ''. The user is not associated with a trusted SQL Server connection."
any help

thanks in advance.
Are you connecting from the same domain. Is the computer on the same server as the conneciton application ? What is your connection string ? Which application are you using for conencting to the server ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||got it thanks
just remove the provider form the ConnectionString and enable the sa logins in sqlserversql

Failed to connect to sql server problem - a strange one!

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

Hi,

are you using connection pooling ? Seems that your application does not release the connection after using them. You should consider your code regarding this. If you are not sure who is connected to your computer you should consider querying the procedure sp_who.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||It's a windows application that is connecting to this database and I'm not using connection pooling. Although I can get into the database and look around, I cannot query it. So, I can't run sp_who. Any other suggestions? Thanks for the reponse|||Lots similar issues are posted on the blog (http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx). Can you take a look at sql trace files and monitor SQL Server error logs? They might also help you to find the clues.|||

SSMS usually open two connection to the db. You can query your db using SSMS to see the connection state, by "select * from sys.dm_exec_connections".

|||I'll give her a try....|||When I searched with Google, I found the blog to which you refer. I wasn't able to figure anything out, but I may give it another shot. Thanks for the info.|||

i had same trouble, in my case this link gave solution. it is about certificates.

http://support.microsoft.com/default.aspx/kb/309398/

i hope this answer for you.

Failed to connect to sql server problem - a strange one!

Full Error message is:

Failed to connect to server DDI-DP9IM5A5F5W. (Microsoft.SqlServer.ConnectionInfo)

ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

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

When I consult the error log I see:

Could not connect because the maximum number of '4' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed. [CLIENT: <local machine>]
2007-01-30 04:53:14.93 Logon Error: 17809, Severity: 20, State: 3.

_

The log error message doesn't make any sense because there aren't 4 user connections.

After I received the error message, mgmt studio still lets me access the database make changes, but I cannot connect via my application. Any ideas? Thanks!

Hi,

are you using connection pooling ? Seems that your application does not release the connection after using them. You should consider your code regarding this. If you are not sure who is connected to your computer you should consider querying the procedure sp_who.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||It's a windows application that is connecting to this database and I'm not using connection pooling. Although I can get into the database and look around, I cannot query it. So, I can't run sp_who. Any other suggestions? Thanks for the reponse
|||Lots similar issues are posted on the blog (http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx). Can you take a look at sql trace files and monitor SQL Server error logs? They might also help you to find the clues.|||

SSMS usually open two connection to the db. You can query your db using SSMS to see the connection state, by "select * from sys.dm_exec_connections".

|||I'll give her a try....
|||When I searched with Google, I found the blog to which you refer. I wasn't able to figure anything out, but I may give it another shot. Thanks for the info.
|||

i had same trouble, in my case this link gave solution. it is about certificates.

http://support.microsoft.com/default.aspx/kb/309398/

i hope this answer for you.

sql

Failed of install Microsoft SQL Server 2005 Express Edition Kb 921

Hi, do anyone know how to solve this failed install problem of microsoft SQL
server 2005.
Hi
"tazhy7" wrote:

> Hi, do anyone know how to solve this failed install problem of microsoft SQL
> server 2005.
Check the log files in the installation log directory (usually ...\90\Setup
Bootstrap\LOG ) start with the summary and find out what the error message
and information output.
John

Failed of install Microsoft SQL Server 2005 Express Edition Kb 921

Hi, do anyone know how to solve this failed install problem of microsoft SQL
server 2005.Hi
"tazhy7" wrote:

> Hi, do anyone know how to solve this failed install problem of microsoft S
QL
> server 2005.
Check the log files in the installation log directory (usually ...\90\Setup
Bootstrap\LOG ) start with the summary and find out what the error message
and information output.
John

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

--

Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = EMILIO, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = Processor, Result = 0 (0x0)
Machine = EMILIO, Article = PhysicalMemory, Result = 0 (0x0)
Machine = EMILIO, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = EMILIO, Article = OSVersion, Result = 0 (0x0)
Machine = EMILIO, Article = OSServicePack, Result = 0 (0x0)
Machine = EMILIO, Article = OSType, Result = 0 (0x0)
Machine = EMILIO, Article = AdminShare, Result = 0 (0x0)
Machine = EMILIO, Article = PendingReboot, Result = 0 (0x0)
Machine = EMILIO, Article = IEVersion, Result = 0 (0x0)
Machine = EMILIO, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = EMILIO, Article = COMPlus, Result = 0 (0x0)
Machine = EMILIO, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = EMILIO, Article = MDAC25Version, Result = 0 (0x0)
Machine = EMILIO, Article = SKUUpgrade, Result = 0 (0x0)

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

--

Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = EMILIO, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = Processor, Result = 0 (0x0)
Machine = EMILIO, Article = PhysicalMemory, Result = 0 (0x0)
Machine = EMILIO, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = EMILIO, Article = OSVersion, Result = 0 (0x0)
Machine = EMILIO, Article = OSServicePack, Result = 0 (0x0)
Machine = EMILIO, Article = OSType, Result = 0 (0x0)
Machine = EMILIO, Article = AdminShare, Result = 0 (0x0)
Machine = EMILIO, Article = PendingReboot, Result = 0 (0x0)
Machine = EMILIO, Article = IEVersion, Result = 0 (0x0)
Machine = EMILIO, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = EMILIO, Article = COMPlus, Result = 0 (0x0)
Machine = EMILIO, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = EMILIO, Article = MDAC25Version, Result = 0 (0x0)
Machine = EMILIO, Article = SKUUpgrade, Result = 0 (0x0)

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

--

Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = EMILIO, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = Processor, Result = 0 (0x0)
Machine = EMILIO, Article = PhysicalMemory, Result = 0 (0x0)
Machine = EMILIO, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = EMILIO, Article = OSVersion, Result = 0 (0x0)
Machine = EMILIO, Article = OSServicePack, Result = 0 (0x0)
Machine = EMILIO, Article = OSType, Result = 0 (0x0)
Machine = EMILIO, Article = AdminShare, Result = 0 (0x0)
Machine = EMILIO, Article = PendingReboot, Result = 0 (0x0)
Machine = EMILIO, Article = IEVersion, Result = 0 (0x0)
Machine = EMILIO, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = EMILIO, Article = COMPlus, Result = 0 (0x0)
Machine = EMILIO, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = EMILIO, Article = MDAC25Version, Result = 0 (0x0)
Machine = EMILIO, Article = SKUUpgrade, Result = 0 (0x0)

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

Fail to uninstall SQLServer 2005

I can't uninstall a default instance of SQLServer 2005.

i have instaled a MSDE2000 then i uninstall it and when a try to uninstall the default instance of SQLServer2005 a have a error the log following:

--

Instance Name = MSSQLSERVER
Trying to find install through Instance Name
Install Type = 1
If possible, determine action
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = WMIServiceWin32OSWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceReadRegWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0)
Machine = EMILIO, Article = WMIServiceCIMDataWorking, Result = 0 (0x0)
Machine = EMILIO, Article = XMLDomDocument, Result = 0 (0x0)
Failed to determine installSkuId due to property load failure.SKU is set to SKU_EXPRESS.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:20 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallSku" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Oct 26 16:37:21 2005
Function Name: SetupStateScope.InstallSku
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
Machine = EMILIO, Article = Processor, Result = 0 (0x0)
Machine = EMILIO, Article = PhysicalMemory, Result = 0 (0x0)
Machine = EMILIO, Article = DiskFreeSpace, Result = 0 (0x0)
Machine = EMILIO, Article = OSVersion, Result = 0 (0x0)
Machine = EMILIO, Article = OSServicePack, Result = 0 (0x0)
Machine = EMILIO, Article = OSType, Result = 0 (0x0)
Machine = EMILIO, Article = AdminShare, Result = 0 (0x0)
Machine = EMILIO, Article = PendingReboot, Result = 0 (0x0)
Machine = EMILIO, Article = IEVersion, Result = 0 (0x0)
Machine = EMILIO, Article = DriveWriteAccess, Result = 0 (0x0)
Machine = EMILIO, Article = COMPlus, Result = 0 (0x0)
Machine = EMILIO, Article = ASPNETVersionRegistration, Result = 0 (0x0)
Machine = EMILIO, Article = MDAC25Version, Result = 0 (0x0)
Machine = EMILIO, Article = SKUUpgrade, Result = 0 (0x0)

HOW I CAN RESOLVED THE PROBLEM THKS,

Emilio Ferreira

How are you trying to uninstall? Through Add/Remove Programs or through command line? If it is command line, can you share out your cmd line call?

Thanks,
Samuel Lester (MSFT)

|||

i try Through Add/Remove Programs.

Thks,

Emilio Ferreira

(MCAD.NET)

|||

I have the same problem when using Add/Remove programs on a customer computer. Any idea on how to get it to unisntall?

Eric Renken

|||Hi,

Did anyone find a fix for this as we are experiencing the same error here?

"Failed to determine installSkuId due to property load failure."

Any help is much appreciated

Iain

|||

You can try to manually uninstall SQL Server 2005. Detail steps please refer to "How to uninstall an instance of SQL Server 2005 manually http://support.microsoft.com/kb/909967".

fail to installation of MDAC on SQL Server install

this log message occour when installation of microsoft
SqlServer 2k:
11:25:20 Setup is installing Microsoft Data Access
Components (MDAC) ...
11:25:20 E:\SQL Server 2000\x86
\Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
11:27:23 ExitCode: -1
11:27:37 Installation of the Microsoft Data Access
Components package failed. (-1)
11:27:37 ConnectivityLocked returned: 0
what can i do to repair this problem?If you update MDAC to the most recent version manually, SQL Server can skip
that step. MDAC 2.8 can be retrieved from:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Renato Cabelino" <renatocabelino@.yahoo.com> wrote in message
news:1bdf201c42165$2d0803d0$a301280a@.phx.gbl...
> this log message occour when installation of microsoft
> SqlServer 2k:
> 11:25:20 Setup is installing Microsoft Data Access
> Components (MDAC) ...
> 11:25:20 E:\SQL Server 2000\x86
> \Other\sqlredis.exe /q:a /C:"setupre.exe WARN=1 -s -SMS"
> 11:27:23 ExitCode: -1
> 11:27:37 Installation of the Microsoft Data Access
> Components package failed. (-1)
> 11:27:37 ConnectivityLocked returned: 0
> what can i do to repair this problem?

fail connect to intergrate services

Message:

Cannot connect to server
additional information
- failed to retrieve data for this request.(microsoft.sqlserver.smoenum)
- connect to SSIS service on machine "server" failed:
error loading type library/dll
- connect to SSIS service on machine 'server' failed :
error loading type library/dll

any idea?

soonyu

Have you started the SSIS Service?

-Jamie

|||

if you talking about services->SQL Server Integration Services
then confirm service already start.

an still the same Problem
-soonyu

|||using sql2005 64bit
solve with install service pack 1

--soonyu

facing problem in increasing connection string pool size sqlserver

Hi to all,

I am using a connection string like

data source=RemoteHostName;initial catalog=myDb;password=sa;user id=sa;
Max pool size = 200;

And now strange thing is happening ,, I am receiving error :

Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached

The SqlServer Activity Manager is telling that only 100 connections are pooled, and I guess that the Max pool size is 100, It is not being changed by my Connection string. As I am trying to change the default 100 pool size value to 200.

Huh , So stucked up , how to increase the Max pool size.. Is there any way .

I am getting worrried.

Any help ??

Thx and RegardsBill Vaughn is a well-regarded SQL Server expert. This article of his should help you out:The .NET Connection Pool Lifeguard -- Prevent pool overflows that can drown your applications.

Terri

Extremly bad performance Stored Procedures

The last few days my sqlserver executes stored procedures badly.
When I run the Query Analyzer to execute a certain stored procedure it takes more than 2 minutes to execute the procedure. When I copy the contents of de SP to Query analyser to run it as an sql statement it find's the results within a second.
This behavior dissapear's after a while and comes back randomly.
I had the problem Friday afternoon then tuesday and now again.
Between these day's my sqlserver works fine.
Can anybody please help me with this problem.Have you tried using the "with recompile" option ? Your query plan is probably based on an outdated data distribution or schema. Running the "with recompile" option will regenerate the query plan. Also, are you parameters to the stored procedure vary enough that the execution plans change ? Do a comparison in query analyzer - using show execution plan.|||I was able to elimante the problem by altering de SP.
In the SP there where more than 4 joins to the same table.
When I made a user defined function and replaced those joins with this function, it all works fine.

But one question remains. How is it possible that the query analyser didn't have problems with the joins but de SP did have?|||Did you try the recompile ? Sometimes, if your table(s) involved in the query change enough - the query plan needs to change as well. When you run it in query analyzer, the query plan is generated dynamically. For the sp, it could still be using the original query plan when you created it. That is why I suggested to run the 2 in query analyzer with the "show execution plan".

extracting the specified record no of records from database table

hi all,

I need to select the no of records on the basis of specified range of records.

In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records..

I have used temporary table,map the table primary key to the next table with identity

but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ...

Is there some other best way to extract the specified data

here is the type of query.

select * from customers where rownum between 1000 and 10000

this is in oracle

i am in need to do this in the sql server

waiting for the response...............................

There is no such thing like row number in MS SQL. You will need to create an identity column in your table, or maintain the number column manually.|||

If you are using SQL Server 2005 then you can use the ROW_NUMBER() function instead:

select *

from (select *, row_number() over(order by CustomerId) as rownum

from customers

) as c

where c.rownum between 1000 and 10000;

If you are using SQL Server 2000 then the identity column approach using temporary table is the best way to go (I guess you are doing this now based on the information in your post).

Also, it seems like you are trying to batch some DML operation. If so you can use SET ROWCOUNT or TOP clause in DML (SQL Server 2005). See below for example:

declare @.n int

set @.n = 1000 -- set number of rows you want to insert at a time

set rowcount @.n

while(1=1)

begin

insert into MasterCustomers

select ...

from Customers as c1

where not exists(

select * from MasterCustomers as c2

where c2.CustomerName = c1.CustomerName)

if @.@.rowcount = 0 break

end

set rowcount 0

-- using TOP

declare @.n int

set @.n = 1000 -- set number of rows you want to insert at a time

while(1=1)

begin

insert top(@.n) into MasterCustomers

select ...

from Customers as c1

where not exists(

select * from MasterCustomers as c2

where c2.CustomerName = c1.CustomerName)

if @.@.rowcount = 0 break

end

|||SQL 2000 does not have the limit keyord. You can use double TOP instead of, but you must have a primary key on that table
select * from
(select top 1000 * from (
select top 11000 *
from customers
order by customer_id asc
) as tmp1
order by cutomer_id desc
) as tmp2
order by ...

for extract customers betweeen 10000 and 11000 based on customer_id
|||

if you use sql2005

you also can use the function ROW_NUMBER() to

select rownum between 1000 and 10000 like oracle

example:

with customers _temp as

(SELECT ROW_NUMBER() OVER (order by customer) as RowNumber,*
from customers)
select *
from customers _temp
where RowNumber between 1000 and 10000

extracting the specified record no of records from database table

hi all,

I need to select the no of records on the basis of specified range of records.

In oracle i found rownum, i could not find it in sqlserver. how the data are extracted from the huge records..

I have used temporary table,map the table primary key to the next table with identity

but i dont find it good. I need to ignore the insert the data in next table or craeting new table having the rowid ...

Is there some other best way to extract the specified data

here is the type of query.

select * from customers where rownum between 1000 and 10000

this is in oracle

i am in need to do this in the sql server

waiting for the response...............................

There is no such thing like row number in MS SQL. You will need to create an identity column in your table, or maintain the number column manually.|||

If you are using SQL Server 2005 then you can use the ROW_NUMBER() function instead:

select *

from (select *, row_number() over(order by CustomerId) as rownum

from customers

) as c

where c.rownum between 1000 and 10000;

If you are using SQL Server 2000 then the identity column approach using temporary table is the best way to go (I guess you are doing this now based on the information in your post).

Also, it seems like you are trying to batch some DML operation. If so you can use SET ROWCOUNT or TOP clause in DML (SQL Server 2005). See below for example:

declare @.n int

set @.n = 1000 -- set number of rows you want to insert at a time

set rowcount @.n

while(1=1)

begin

insert into MasterCustomers

select ...

from Customers as c1

where not exists(

select * from MasterCustomers as c2

where c2.CustomerName = c1.CustomerName)

if @.@.rowcount = 0 break

end

set rowcount 0

-- using TOP

declare @.n int

set @.n = 1000 -- set number of rows you want to insert at a time

while(1=1)

begin

insert top(@.n) into MasterCustomers

select ...

from Customers as c1

where not exists(

select * from MasterCustomers as c2

where c2.CustomerName = c1.CustomerName)

if @.@.rowcount = 0 break

end

|||SQL 2000 does not have the limit keyord. You can use double TOP instead of, but you must have a primary key on that table
select * from
(select top 1000 * from (
select top 11000 *
from customers
order by customer_id asc
) as tmp1
order by cutomer_id desc
) as tmp2
order by ...

for extract customers betweeen 10000 and 11000 based on customer_id|||

if you use sql2005

you also can use the function ROW_NUMBER() to

select rownum between 1000 and 10000 like oracle

example:

with customers _temp as

(SELECT ROW_NUMBER() OVER (order by customer) as RowNumber,*
from customers)
select *
from customers _temp
where RowNumber between 1000 and 10000