Microsoft SQL Server 2005 Setup Problem

i keep getting this message whenever i double click the setup for sql server 2005. i previously installed the sql server 2005 beta 2 and have since deleted it. i've followed the readme on uninstalling some of the beta components and tried running some program i got from microsoft.com which would uninstal the pre release- the program doesn't detect any pre-release component. i however continue to get this message and need help resolving it.

TITLE: Microsoft SQL Server 2005 Setup

SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40PerformSCCAction2%40sqls%3a%3aPerformSCCAction%3a%3aperform%400x11190

BUTTONS:

OK

Here are several references. Check the ones you haven't previously explored.

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

|||

Try the Windows Installer clean up tool first.

http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

THE INSTALLER WORKED FOR ME - -THANKS

Microsoft SQL Server 2005 Setup

i keep getting this message whenever i double click the setup for sql server 2005. i previously installed the sql server 2005 beta 2 and have since deleted it. i've followed the readme on uninstalling some of the beta components and tried running some program i got from microsoft.com which would uninstal the pre release- the program doesn't detect any pre-release component. i however continue to get this message and need help resolving it.

TITLE: Microsoft SQL Server 2005 Setup

SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=50000&EvtType=setup%5csqlsetupactions.cpp%40PerformSCCAction2%40sqls%3a%3aPerformSCCAction%3a%3aperform%400x11190

BUTTONS:

OK

Here are several references. Check the ones you haven't previously explored.

Remove -Error message when you install SQL Server 2005: "Beta components detected"
http://support.microsoft.com/?kbid=919394

Remove -How do I remove previous versions of SQL Server 2005 / Whidbey?
http://www.aspfaq.com/sql2005/show.asp?id=15

Remove -How to uninstall an instance of SQL Server 2005 manually
http://support.microsoft.com/?kbid=909967

Remove -How to Uninstall MSDE
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q290991

Remove -How to Uninstall SQL Server 2005 Beta
http://go.microsoft.com/?linkid=1396133

Remove -How to uninstall SQL Server Management Studio
http://support.microsoft.com/default.aspx?scid=kb;EN-US;909953

Remove -How to use the Add or Remove Programs item in Control Panel to add
or remove components for stand-alone installations and clustered
installations of SQL Server 2005 (KB: 922670)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;922670

Remove -How to: Uninstall SQL Server Express
http://msdn2.microsoft.com/en-us/library/ms143505.aspx

Remove -The error is: Fatal error during installation"
http://support.microsoft.com/?kbid=919945

Remove -Uninstall Applications NOT in Install/Remove Programs List
http://blogs.msdn.com/astebner/archive/2005/10/30/487096.aspx

|||

Try the Windows Installer clean up tool first.

http://download.microsoft.com/download/E/9/D/E9D80355-7AB4-45B8-80E8-983A48D5E1BD/msicuu2.exe

THE INSTALLER WORKED FOR ME - -THANKS

Microsoft SQL Server 2005 Express Edition Service Pack 2 Error Code: 0x2B22

Hi i tried to install the Microsoft SQL Server 2005 Express Edition Service Pack 2 but was unable to do so. I got an error message saying: Error Code: 0x2B22

I went through what the message said, but i was unable to solve the problem. Below is the summary of the problem. Please help me solve it.

Time: 05/19/2007 12:32:24.781
KB Number: KB921896
Machine: DET-NB0631262
OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU SP2 x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason
Express Database Services (SQLEXPRESS) Unable to start service

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 11042
Error Description : Unable to start service
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Not Applied
Log File :
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
Unable to start service
Exit Code Returned: 11042

For me, several attempts to install "Microsoft SQL Server 2005 Express Edition Service Pack 2" via MS-update get stuck. The progress bar doesn't budge after a long lunch.

Microsoft SQL Express 2005 Installation Failure

I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.

Please Help ME!!!

---

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

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

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft SQL Express 2005 Installation Failure

I can get SQL SERVER 2005 to install it goes through the extracting files then gives me an error message that says "SQL Server Setup unexpectedly failed. for more information, review the setup summery log file " . I don't think i have any beta versons of Visual Studio or SQL I do have Accouting Express with has something with SQL I don't know if that will stop my installation. I really need SQL to work for my business.

Please Help ME!!!

---

Heres a copy of my log file:[SQLSetup0017_DSTRETCH_Core]

Microsoft SQL Server 2005 Setup beginning at Wed Apr 18 19:28:35 2007
Process ID : 5244
c:\84d9dbbedcbb7eee6c8eeabf58\setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/3/18 19:28:35
Complete: LoadResourcesAction at: 2007/3/18 19:28:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35
Loaded DLL:c:\84d9dbbedcbb7eee6c8eeabf58\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/3/18 19:28:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
-
writeEncryptedString() failed
Source File Name: utillib\persisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
-
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: cryptohelper\cryptsameusersamemachine.cpp
Compiler Timestamp: Wed Jun 14 16:28:04 2006
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50

2
Could not skip Component update due to datastore exception.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/3/18 19:28:35
Complete: ValidateWinNTAction at: 2007/3/18 19:28:35, returned true
Running: ValidateMinOSAction at: 2007/3/18 19:28:35
Complete: ValidateMinOSAction at: 2007/3/18 19:28:35, returned true
Running: PerformSCCAction at: 2007/3/18 19:28:35
Complete: PerformSCCAction at: 2007/3/18 19:28:35, returned true
Running: ActivateLoggingAction at: 2007/3/18 19:28:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
-
No collector registered for scope: "SetupStateScope"
02E7CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.

Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44

Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastore\cachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
-
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5244"} in cache
Source File Name: datastore\propertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
-
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2

Can you search through your SQL install log directory for the text string "value 3" and post the 10 or so lines above that? It may give a more descriptive error message.

Thanks,
Sam Lester (MSFT)

|||

Ah, I think it may be this issue. Can you read through this post and see if it applies to your situation.

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

Thanks,
Sam

|||I can't find "value 3" and the artical that you linked to did not apply to my problem.

Microsoft SQL 2000 Login Problem

Hi,

I'm trying to slove this problem from last few hours. I cannot slove this problem. Getting following error message if i try to login in Microsoft SQL Server 2000. Programming in Visual Studio NET -> MFC...

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.



CDBVariant value;
CDatabase db;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
db.OpenEx(_T("DSN=MQIS"),CDatabase::noOdbcDialog);
.
.
.
.

can someone please help me out, is something wrong with the code ??does your DSN include a username and a password ?|||well,

i didn't created one. I had a computer crash... and i had to reinstall everything. but know my sourcecode isnt working anymore. even with username dbo it isn't working

weird. must be wrong with the sql server 2000|||"db.OpenEx(_T("DSN=MQIS"),CDatabase::noOdbcDialog)"

you have to create a new DSN named MQSI
with a integrated user and a password
or specify them after after the DSN

"db.OpenEx(_T("DSN=MQIS;UID=sa;PWD=password")...|||how can i create a new dsn name ??

when installed last time before this time the sql server 2000 i used the beauty and could login with it as a dsn name. like "DSN=beauty" the name of my server is now "motherindia" but i cant login now anymore. i didnt did anything different then before.|||In your

> Config Pannel
> Administration Tools
> ODBC Data Sources

Add a new System Data Source
named "MQIS"|||i dont have these options in Microsofts sql server|||This is not done in SQL Server
but on your Computer ...|||lol

thx.. i had to choose the same name

works pefectsql

Microsoft OLE DB Provider for SQL Server"

I receive a "Cannot generate SSPI context" error message when you try to
connect to a SQL Server 2000 SP3 server computer.
According microsoft's article ID 843248 there is a hot fix. I do not want to
install SP2 just the hot fix.
Does anybody know the actual ID name of the hotfix. I am trying to connect
from XP SP1 Thank you
According to the article you referenced you could either download XP SP2 or
contact Product Support to get the fix.
In that article you can also find a workaround if you can not install either
SP2 or the fix.
I would recommend that you consider to install XP SP2 since it contains a
lot of security enhancements.
Simon
This posting is provided "as is" with no warranties and confers no rights.
"Yianni" <Yianni@.discussions.microsoft.com> wrote in message
news:B89BD7C7-E80B-48EE-943A-6832804665B5@.microsoft.com...
>I receive a "Cannot generate SSPI context" error message when you try to
> connect to a SQL Server 2000 SP3 server computer.
> According microsoft's article ID 843248 there is a hot fix. I do not want
> to
> install SP2 just the hot fix.
> Does anybody know the actual ID name of the hotfix. I am trying to connect
> from XP SP1 Thank you
>

Microsoft OLE DB Provider for Analysis Services error 80004005

Hello

I get the following error message in one of my ASP applications:
--------------------------
Microsoft OLE DB Provider for Analysis Services error '80004005'
Cannot connect to the server '172.16.103.14'. The server is either not started or too busy.
--------------------------
The IIS server is on a different machine to the MSOLAP server.

When I change the ASP code to point the 'localhost' it runs fine so Im fairly confident the necessary db conn libraries are installed on the IIS server.

There does not appear to be any traffic between the IIS/MSOLAP servers. Although all TCP ports are open. Interestingly, there are other pages on the same site that access a SQL Server resident on the MSOLAP servers & there are no issues.

Any assistance on this matter would be greatly appreciated. (I am a relative novice re: ASP/MSOLAP/IIS etc)Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG|||You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.|||Originally posted by sqlguy7777
Howdy

Talk to your networking guys & check the Default Gateway setting for TCPIP on the server. Sounds like it cant find the server.

Can you ping the IP address from a dos window on the server?

Cheers

SG

Everything seems to be in order on this front. You will note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK.|||Originally posted by beyond cool
You should check client-library/server-library settings. You prolly have named pipes only and no TCP-IP connection set-up.

Everything seems to be in order on this front. Note that connectivity to a SQL Server database on the application/database server from the ASP pages on the web server function OK...unless im missing something here....|||Howdy kalaa,

Can you confirm you can do these things :

(1) Ping the SQL box by name from the web server from a dos window on the web server e.g. ping <SQL_Server_name>. This will test if you have connectivity to the SQL box from the web server and more importantly confirm the SQL box is recognised in DNS.

(2) you have a valid SQL user ID set up on the SQL box, and that user ID has at least read access in the required database on the SQL box.
This is the user ID that the web application will use to talk to the SQL box.

Cheers,

SG

Microsoft ODBC Sql server driver Communication Link Failure

I get the message Microsoft [ODBC Sql server driver]communication link failure error message in my VB 6 application with MSDE engine. This error does not happen often.
My connection string is as below.

"Provider=MSDASQL;Driver={SQL Server};Server=" & mSvrName & ";DATABASE=cnsClient;uid=uid;pwd=pwd"

Please help.Were you able to figure out a solution? It seems like a ODBC specific error more than a MSSQL one. I get the same error when trying execute queries against a DB2 database.

Microsoft JET Databse Engine Error Message

Hi,
When I try to import DBF files into the SQL Server,
I got the following error messages for some files.

Error Source: Microsoft JET Databse Engine
Error Destination: External table is not in the expected
format
Context: Error calling OpenRowset on the provider.

Does anyone know about this error?

I found that only files that have *.FPT (memo) files didn't work
and other files were imported successfully/

I installed sql server service pack and I checked that
the machine has the latest JET Database engine (4.0).

I'm using Microsoft SQL Server 2000 Standard Edition
w/ Service Pack 2 & Microsoft FoxPro 2.6.

Thank you in advance.

- Hyung -Did anyone ever answer this?sql

Messge to specified Client

I know that SQL has many ways to send message to Current Connection, but I wonder is there any way to Send Message to an Other, specified Connection.

Let suppose ther is an application that makes an inserts in a table (for example cash transfers) and I need a tool to pring all new row via other application that should receive a message that a new row is added (fired by trigger, for example) but problem is that entry and printing applications arenn't same applications and they have separate connections to the SQLI'm not certain that this is what you are looking for, but you might be able to use xp_cmdshell to NET SEND a message to the users machine name. That raises some security issues since to invoke xp_cmdshell you need sysadmin role (or you need to config the sql agent proxy account, which in itself can be problematic).

Aren't there some other options? Perhaps having the process that invokes the print job write a record to a table (with the necessary user info) and then reading that info from the process that actually prints the job?

Dunno, I think we'd need to see a bit more info about what you are trying to do to help you...

Regards,

hmscott|||xp_cmdshell is the way that I've thought about, but problem is that by design the printing app should be runing on client's computer and don't shared via network, also I don't want to run exe app each time a row is added, it may slow down the server. better way is to have a bit field in the supposed table , that is reset by dedault and design printing app to check unset rows by timer , print them and set to 1.
But this isn't the best way out too for me, If i could make SQL to send messages to other connection, I wouldn't have needed to check flag fileds to print them time by time.|||Sorry; outside of xp_cmdshell, I'm not certain of other alternatives. I'm not sure I see what's wrong with setting a flag in the table to be checked by the printing process; it should not be a huge performance hit and if properly indexed and used with an SP, it should execute pretty cleanly.

Regards,

hmscott|||seems flagging is the only way (maybe not bad) for me
thanks anyway.

Messages in the sys.transmission_queue for a disable queue

I may have a misunderstanding of how SB works, but this seems like a problem.

If a queue is disable (i.e. status = off) and a message is sent to the queue the message is placed on the sys.transmission_queue. Once the queue is enabled I thought the messages were sent to the queue in the order they were placed on the sys.tranmission_queue? I have been troubleshooting a problem and this is not the case. Do I have a misunderstanding of how the sys.transmission_queue works?

The queue has retention turned off.

Messages are delivered in order within each conversation (RECEIVE cannot return msg 2 before msg 1 for any conversation). But the order of messages in the xmit queue does not determine in any way the order of which messages are actually being delivered.

HTH,
~ Remus

|||

If you have a scenario where you want to send a message to a service broker queue that updates a row in a table and then later you would like to send another message to do another update to the row in the same table and the queue is disabled before the first send there is no way to guarantee these messages will be processed in order they were sent? It sounds like unless you actually end up on the queue itself there is no gurantee in what order the xmit queue will deliver them to the queue. Am I correct?

Thanks for the help

|||

If the order matters, you must deliver them using the same conversation. Otherwise you are never quaranteed anything about the order and you can hit the xmit queue for other reasons that target queue disabled (low memory, a lock bounce etc)

Message: SQL Server does not exist or access denied.

Receiving the following error:
Message: SQL Server does not exist or access denied.
Source: .Net SqlClient Data Provider
at System.Data.SqlClient.ConnectionPool.GetConnection
(Boolean& isInTransaction)
at
System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon
nection(SqlConnectionString options, Boolean&
isInTransaction)
any clues please?
Check the Datasource property of the connection string to make sure the
server name /instance name is correct - you can check by creating a new text
document, renaming it to test.udl, opeing and setting the connection
properties, then closing it and open in notepad.
Make sure you can ping the server.
Make sure the DBA's or network dudes haven't closed port 1433
"Belinda" <anonymous@.discussions.microsoft.com> wrote in message
news:37a001c4a06d$7b5405c0$a501280a@.phx.gbl...
> Receiving the following error:
> Message: SQL Server does not exist or access denied.
> Source: .Net SqlClient Data Provider
> at System.Data.SqlClient.ConnectionPool.GetConnection
> (Boolean& isInTransaction)
> at
> System.Data.SqlClient.SqlConnectionPoolManager.Get PooledCon
> nection(SqlConnectionString options, Boolean&
> isInTransaction)
> any clues please?

Message: Missing end comment mark '*/'.

Hi,

I created a web syncronization merge replication ,both servers and clients are sql server 2005 and everything is fine with the settings , but while synchronization and after i received some sch files i got the following message at the subscribers on the initial snapshot operation:

2006-06-27 07:50:14.471 The schema script 'myfile_311.sch' could not be propagated to the subscriber.
2006-06-27 07:50:14.471 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The schema script 'myfile_311.sch' could not be propagated to the subscriber.
2006-06-27 07:50:14.471 Category:NULL
Source: Microsoft SQL Native Client
Number: 113
Message: Missing end comment mark '*/'.

Any idea ?

Tarek Ghazali

SQL Server MVP

My guess is that myfile_311.sch contains a stored procedure|view|function with something like

/*

...

go

*/

There is a longstanding limitation in our batch parsing logic that will erroroneously recognize 'go's embedded in comments to be batch delimiters. The only workaround for this is to edit the script generated by the snapshot agent to remove the offending comment. We really hope that we can address this issue in the near future.

-Raymond

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi Im getting the following error when trying to connect to a php page...any ideas

message: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. (severity 14)

Hi,

seems that you tried to impersonate the WebUser at the SQL Server database. The question would be what you want to use, wheter Windows Authentication or SQL Authentication ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
Igor
Did you give the service account for the SQL Server service "Lock Pages in memory" user rights.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>
|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>
|||Slava Oks has several articles on memory management on his blog. As I recall, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit operating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
IgorDid you give the service account for the SQL Server service "Lock Pages in m
emory" user rights.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot u
se Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Pass
ive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>|||Slava Oks has several articles on memory management on his blog. As I recall
, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit o
perating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>

Message: Cannot use Large Page Extensions

Hello!
I have noticed following messaeg in SQL Server 2005 error log:'Cannot
use Large Page Extensions: lock memory privilege was not granted.' Server
is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
Can anyone explaing what this messaeg means?
Thanks,
IgorDid you give the service account for the SQL Server service "Lock Pages in memory" user rights.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
> Hello!
> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
> cluster with 28GB or RAM.
> Can anyone explaing what this messaeg means?
> Thanks,
> Igor
>|||Tibor,
Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL
says: 'Though not required, Microsoft recommends locking pages in memory
when using 64-bit operating systems'. Will my SQL Server benefit from having
this option configured?
Thanks,
Igor
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
> Did you give the service account for the SQL Server service "Lock Pages in
> memory" user rights.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>> Hello!
>> I have noticed following messaeg in SQL Server 2005 error log:'Cannot
>> use Large Page Extensions: lock memory privilege was not granted.'
>> Server is Active/Passive 64-bit SQL Server cluster with 28GB or RAM.
>> Can anyone explaing what this messaeg means?
>> Thanks,
>> Igor
>|||Slava Oks has several articles on memory management on his blog. As I recall, he recommends locking
pages on 64 bit as well. Check it out at http://blogs.msdn.com/slavao/
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:O0LuocIRGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Tibor,
> Is this a good idea to do this on 64-bit vesion of SQL Server 2005? BOL says: 'Though not
> required, Microsoft recommends locking pages in memory when using 64-bit operating systems'. Will
> my SQL Server benefit from having this option configured?
>
> Thanks,
> Igor
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:eBUVHQIRGHA.4300@.TK2MSFTNGP14.phx.gbl...
>> Did you give the service account for the SQL Server service "Lock Pages in memory" user rights.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
>> news:umi2vLIRGHA.4952@.TK2MSFTNGP09.phx.gbl...
>> Hello!
>> I have noticed following messaeg in SQL Server 2005 error log:'Cannot use Large Page
>> Extensions: lock memory privilege was not granted.' Server is Active/Passive 64-bit SQL Server
>> cluster with 28GB or RAM.
>> Can anyone explaing what this messaeg means?
>> Thanks,
>> Igor
>>
>

message with xml validation

Hi

I created a XML SCHEMA and MESSAGE TYPE with VALIDATION = VALID_XML WITH SCHEMA COLLECTION.

I thought this would validate the message send with the schema. but when I try to send the message with a different xml, the message is send. there were no errors. Is there something I did not set?

thanks

P

Does the target database (if different from the initiator database) define the message type with the same schema?

|||its the same, but it should not been able to send if the xml is not according to the valid schema?|||Can you post your CREATE MESSAGE TYPE, CREATE CONTRACT, CREATE (target) SERVICE, BEGIN DIALOG and SEND statements?

Message when performing end user sort

Hi,

I have added interactive sort to report. When i perform the sort in the preview of the report, i see a message 'Report is being generated'. But when i do the sorting from Report viewer control, the screen goes blank before the sorted data comes up.

Is there any way I can display a message telling sorting is in progress?

Any help in this regard is appreciated.

Thanks.

Possibly you could do this by handling the Sort event.

Maybe put a Label above the report viewer and make invisible on report viewer sort? I haven't tried it, but it's an idea.

Code Snippet

Private Sub ReportViewer1_Sort(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.SortEventArgs) Handles ReportViewer1.Sort

End Sub

|||

Thanks for your reply. But I am not able to find a sort event for the report. The only events I get are the ReportSnapshotUpdated and ReportHistorySnaphot.

Also from my application, I am just calling the Report server URL for the report viewer.

Can you please tell me how I can proceed in thi scnario.

|||This event can only be handled on the report viewer in Visual Studio 2005.