DTS - ActiveXScripting Not Working On 64bit AMD Cluster On SQL Server 2005 SP2

Apr 17, 2007

I have a problem with DTS - ActiveXScripting that it cannot initialize the script engine, I have the backward compatibility stuff installed, even tried a repair but still does not work.



Many thanks for any help you can provide on this problem.



Paul



Error Information below:



Date 17/04/2007 13:07:32
Log Job History (Test ActiveX Script)

Step ID 1
Server GBCONV1A002V03
Job Name Test ActiveX Script
Step Name Step 1: Exec TestActiveX script
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: WW004ConSrvSQLAgentA002. ...TSStep_DTSActiveScriptTask_1 DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220487 (800403F9) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 Error Detail Records: Error: -2147220487 (800403F9); Provider Error: 0 (0) Error string: ActiveX Scripting was not able to initialize the script execution engine. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80.hlp Help context: 4500 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_1 Error: -2147220440 (80040428); Provider Error: 0 (0) Error string: Package failed because Step 'DTSStep_DTSActiveScriptTask_1' failed. Error source: Microsoft Data Transformation Services (DTS) Package Help file: ... Process Exit Code 1. The step failed.

View 3 Replies


ADVERTISEMENT

SQL Server 2005 64bit SP2 Installation Issue On Cluster Servers.

Nov 23, 2007

Hi All,

We have been experiencing issues with SQL Server 2005 SP2 upgrade on cluster servers.
After running the setup, it gives failure message for Database services.

Installing SP2 on 64bit cluster server we get error regarding "passive node not patched properly or run the setup from passive node". However, select serverproperty(€˜productlevel€™) returns the output as "SP2". On more digging we found from SQL Server Error log, that the resourcedb of that server is of level 9.0.0.3199

€œThe resource database build version is 9.00.1399. This is an informational message only. No user action is required.€?

However if we do the SQL Server 2005 SP2 upgrade on standalone machines with the same software repository, it upgrades successfully and also resourcedb upgraded to 3042 version. So if we look at the errorlog of a standalone machine it gives following message.

"The resource database build version is 9.00.3042. This is an informational message only. No user action is required."

I again reiterate that, this is the issue we have faced on 64bit SQL Server 2005 SP2 upgrade only on cluster SQL Servers, however on standalone machine it works fine and 32bit SP2 installation works fine.

Please let us know the solution for this.

regards
Jay Mehta

View 2 Replies View Related

Vista 64bit, SQL 2005 64bit, But DB Service Is Only 32bit ?

Jun 6, 2007

I just installed the 64bit Vista and than wanted to install the 64bit SQL 2005 Std. Server on it.



Note: I downloaded my license from https://licensing.microsoft.com/eLicense/L1033/ProductDetail.Asp?SKU=228-05338.



Installing from SQLSTDSEL.ISO file results in the warning that for the REPORT- Server the .NET version has to be 32bit.



Stopping the installation at this point and try to install from SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57664 + SW CD SQL Svr Standard Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57665 does not give the above error but on the other hand installs no server at all since somehow the installation routine is not working at all.



Installing now - after at least analysis server and reports server are 64bit and installed - from the first mentioned ISO results in the installation of the DB- Server.... but as a 32bit installation.



Now I wonder what did not work out - so maybe someone here has an idea if and how this problem is solveable.

View 1 Replies View Related

Install 64bit SSRS On An Existing 64bit SQL Server Installation

Oct 2, 2007

We have a 64bit installation of SQL Server (SSIS, SSAS) running and working fine. There is a requirement to install 64bit SSRS on this existing setup.
The problem is: While running the SQL Server Setup wizard, the Reporting Services checkbox remains greyed out. In other words, there isnt an option to select SSRS for installation.
So the question is: Is it even possible to install 64bit SSRS on an existing 64bit SQL server installation - given that SSRS wasnt installed during the first pass.
PS: The SQL Server is SP2 on a Windows Server 2003 configured as an App Server.

View 9 Replies View Related

SQL Server 2005 32bit-vs-64bit

Apr 24, 2007

This may seem like a completely foolish question, but is there any issue in using the 32bit workstation components (on XP) to connect to the 64bit server-side components? New to SQL2K5 and never had any issues using the 2K workstation/server components together.

Thank you!

View 3 Replies View Related

Cannot Install SP1 On SQL Server 2005 (64bit)

Nov 14, 2006

Hi,

I'm having problems installing SP1 on one of our servers.

If I try to install the x64 version of SP1 setup says it can not update my server and I should use x86 version. Trying to install the x86 version results in the message I should use x64 version....

Any ideas?

Regards, Jan

View 7 Replies View Related

How To Upgrade SQL Server 2000 Cluster To SQL Server 2005 Cluster(Database)

May 8, 2007

Hi



We are planning to upgrade the SQL Server in our production environment from SQL Server 2000 to SQL Server 2005. This is a 4 Node cluster environment with 3 Databases on 3 Virtual instances. The main requirement is to achieve this with no/minimal downtime.



Could you please suggest or direct me to any documentation for the best practices used to upgrade such an environment?



Thanks

Priyanka

View 2 Replies View Related

Shifting To Server 2005 64bit Edition

Jul 11, 2007

Hi,

I have implemented a application on SQL Server 2005, this application runs huge queries and some stored procedures. Now that client is shifting on SQL Server 64bit edition, what should i need to worry about. What all changes am i expected to handle.

I would also like to know if there are any other issues to be considered.


Thank You.
STG Labs

View 6 Replies View Related

SQL Server 2005 32bit To 64bit Testing

May 20, 2008

Hi,

Recently, we have migrated our database from 32bit to 64bit. So far the application is working fine.

But I want to confirm that by any tool or automated process.

Is there any way or tool to check that the migrated data is correct and also to check if migrated database objects will work fine in 64 bit environment.

Any timely help would be greatly appreciated !!

Thanks,
Bala

View 4 Replies View Related

Would This Scenario Benefit From SQL Server 2005 64bit?

Oct 2, 2007

We have an application where part of the database is used for searching products and is very processor intensive due to the number of permutations and calculation that are required. This section of the database is scaled out by using transactional replication so that the €œsearch€? load is removed from central database€™s daily operations.

Each €œsearch€? server can handle around 15,000 search an hour with SQL taking about 3 seconds to return the result in XML (the system has be optimised to squeeze out every last bit of performance). This is in a 32bit environment. One other point, which is probably relevant, is that the Search data only totals 500MB.

With the possibility of upgrading these severs in the near future would we see any performance benefits in going 64bit. I know we won€™t take advantage of increased memory access due to the size of the search data but is there any discernable performance advantage between 32bit v€™s 64 bit processors and SQL Server 2005 64Bit. Or should I stick with SQL Workgroups and 32bit processor and save on the Standard SQL licence?

Many thanks

View 5 Replies View Related

SQL Server Compact Edition 2005 For 64bit OS

Dec 17, 2007

Hello

I'm trying to use application designed for 32bit operating system on 64bit (Longhorn beta 2). This application requires SQL Server CE 2005, I installed it (x32) but the application still says that it isn't.

What can be the problem? I suggest the application cannot retrieve information about SQL Server CE installation. But maybe the reason is I need to install something like SQL Server CE for 64bit operating system? Is it present "in native"?

View 3 Replies View Related

Migration From SQL Server 2005 32bit To SQL Server 2005 64bit

Oct 4, 2007

We recently migrated our 32bit instance of SQL Server 2005 SP2 to a 64bit instance of SQL Server 2005 SP2. The migration was performed by copying all .mdf and .ldf files (including master, tempdb, etc...).

Everything seems to have worked nearly flawlessly except for a few glitches seeming to relate to the master database. I am hoping there is a way to mitigate these issues without reinstalling and performing the migration again.

First, when attempting to view the Activity Monitork, I get the error:



TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.

Unable to execute requested command.

Unable to launch Activity Monitor. You may not have sufficient permissions. (ActivityMonitor)

View or function 'master.sys.dm_exec_sessions' has more column names specified than columns defined. (Microsoft SQL Server, Error: 4502)



Second, the procedure: master.dbo.sp_procedure_params_rowset fails because of the line: option (OPTIMIZE CORRELATED UNION ALL).


Like I said, I know this is probably an issue arising from copying the master database, but if it is at all possible to avoid another migration, I want to.


Mike Thomas
Software Developer
The Master's College

View 14 Replies View Related

How Can I Find If The SQL Server 2005 Installed Is A 64bit Or 32bit?

Feb 11, 2007



I am about to work on a SQL server 2005 migration and I have no clue what SQL server 2005 is as I have been working on 2K all along.

Fist of all I am not sure if the given box is having 64bit or 32 bit Operationg System?

Second of all I am trying to find if the SQL server 2005 installed on this box is 32bit or 64bit?

Thanks in advance,

sk

View 3 Replies View Related

Problems With Linked Server To ORACLE (on SQL 2005 64bit)

Jan 26, 2007

Hi all

I have a big problem with creating a linked server to ORACLE database!

- I have installed ORACLE Client 10g on my server (Windows Server 2003 64 bit)
- With ORACLE Tools I am able to connect to the ORACLE Server
- When I try to connect in SQL Server I get the following error:
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server
"MISPROD.WORLD".


I have tried I guess all combinations of getting data out of ORACLE ... :-(
For example:
- SELECT * FROM OPENQUERY([MISPROD.WORLD], 'SELECT * from ORACLE_TABLE')
- SELECT * FROM [MISPROD.WORLD]...ORACLE_TABLE
I allways get the same error and I dont know what to do ...

Would by very very happy for any comment.

Best regards
Frank Uray


View 1 Replies View Related

Very Slow GROUP BY With SQL 2005 On 64bit Multiprocessor Server

Apr 5, 2006

Hi

I have the following configuration:
- Server with 8 AMD Opteron Processors
- 24 GB Memory
- Windows Server 2003 64 bit
- SQL 2005 64 bit
- EMC Storage

The main instance is defined to use 7 Processors and
has about 10 databases.

The problem is:
When I run a "simple" Query (DISTINCT or GROUP BY) on a Table
with something like 1 million rows, SQL 2005 is very very slow !!!
The same query is on a SQL 2000 about 1000times faster ...

Does anybody has some ideas how to configure the system
to make it more useful ... ??

Thanks for any comment.

Best regards
Frank Uray

View 8 Replies View Related

Problems Connecting To SQL Server 2005 SP2 On Windows Server 2008 (both 64bit)

Apr 3, 2008



Hi All,
After I installed sql server 2005 64bit standard edition on Windows Server Enterprise 2008 64bit, I cannot connect to the sql instance using the sql management studio on the same machine!
I verified that:


service is running,

in surface area configuration: remote connections to local and remote are enabled, for TCP/IP and named pipes.

ran the command netstat -avn| findstr 49279 to make sure that the server is listening.

firewall is off, but this does not matter since I'm connecting locally to local instance

I'm using domain controller account to login to sql server / also tried the sa account.
what else can be wrong?


thanks.

View 4 Replies View Related

Upgrading A SQL Server 2000 Cluster To A SQL Server 2005 Cluster

Dec 28, 2007



We're upgrading a SQL Server 2000 cluster (Active/Passive) running on Windows 2000 Server to a SQL Server 2005 Cluster running on Windows Server 2003. We can't purchase new hardware and we have no spare hardware. We also need to move from Windows 2000 Server to Windows 2003 Server at the same time. We want to keep downtime to a bare minimum.

What we were thinking was the following steps... Anyone try this?

1. Break the link between the servers.

2. Install a fresh copy of windows 2003 server on one side along with SQL Server 2005. While this step is running, the active node would still be live on Windows 2000 Server and SQL Server 2000 serving our customers.

3. Restore a copy of a backup from the active production side to the node we're upgrading and at that point we would bring the active node down, switching the active node to be the newly upgraded server.

4. As a final step, the old active node would now have the link to it broken, we would install a fresh copy of windows 2003 server on it and sql server 2005. At this point we would bring it back into the cluster and the cluster would be complete again.

Thoughts?

View 2 Replies View Related

Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 14, 2008



Friends -

Need your help and guidence for doing upgrading SQL Server 2000 Cluster to SQL Server 2005 Cluster.

Let me explain my current environment.

1. Currently SQL Server 2000 Cluster environment is running on Windows 2000 Server we need to upgrade this to SQL Server 2005 on Windows 2003 Server. >>> Production environment.


My Plans:

1. On Testing Environment Install SQL Server 2000 cluster on Windows 2003 Server and do a restore of databases from the produciton environment.

2. Upgrade In-Place from SQL Server 2000 Cluster to SQL Server 2005 Cluster.

My doubts

1. Can i install SQL Server 2000 Cluster on Windows 2003 Server. Is it possible or not.

Please advise me and correct my steps.

Cheers
VSH

View 1 Replies View Related

SQL Server 2005 64bit Install - Missing Management Studio

May 27, 2007

Good Afternoon,



I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.



The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.



I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".



Here are file names that I downloaded from the MS website and installed.



SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)



SQLServer2005SP2-KB921896-x64-ENU



There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:



SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797



Any help would be greatly appriciated.



Thanks ALL!



J Kusch

View 11 Replies View Related

Getting Error When I Try To Connect Oracle 10g (32bit) From MS SQL Server 2005 (64bit)

Apr 29, 2008



We have recently migrated from SQL 2000 (32bit) to SQL 2005 on Win2003 (both are 64bit). And we have Legacy DTS packages on SQL 2005, some packages are pulling records from Oracle 10g (32bit server). When I execute the DTS package I am getting following error.


Error = -2147467259 (80004005) Error string: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed. Error source: Microsoft OLE DB Provider for Oracle


Did I need to install/update any MS OLE DB driver for Orace.
Some blogs & forums suggesting to install Oracle 10g Client. If so Which version of Oracle client(32bit/64bit) I have to install?.

Thanks.
Dhans

View 1 Replies View Related

Stupid Question... But Did I Install 64bit Or 32bit SQL Server 2005?

Mar 14, 2008



I installed what I thought was SQL Server 2005 64bit, but I'm not sure. I used my action pack Microsoft SQL Server 2005 CD, and it's on a Windows 2003 64 bit machine. When I click help -> about in the SQL Server Management Console, it says "Microsoft SQL Server 2005". There's no 64 bit in there.

Can someone tell me how I can find out if I've correctly installed the 64 bit version?

Thanks.
Chris.

View 6 Replies View Related

Can I Use SQL Server 2005 Driver For PHP On X64 2003 Server As 64bit Application?

Nov 21, 2007

I'm sorry to bother you.

Now I'm trying to run PHP web application on x64 2003 Server with Microsoft SQL Server 2005. The version of PHP is 5.2.3. and the web application should be run as 64bit applications. Since there seems no way to use php_mssql.dll on the environment, I'm trying to use SQL Server 2005 Driver for PHP but when PHP loads php_sqlsrv.dll, an error has occurd and there's a following message in an error log...

PHP Warning: PHP Startup: Unable to load dynamic library 'c:phpextphp_sqlsrv.dll' - %1 is not a valid Win32 application

From this message, I thought the distributed libraries for Windows would be for a Win32 environment but there seemed no information that says the libraries run on Win32 environment only.

I really appriciate if you help me.
Thank you.

View 4 Replies View Related

Slow SQL 2005 64bit Standard Edition Performance On Windows Server 2003

Apr 2, 2008



Greetings,

We are having major performance issues with Microsoft SQL 2005 64bit Standard Editions performance on Windows Server 2003. We have an SSIS package running very slowly (and other sql tasks) on our two quad core cpu system with 8gb of ram and running a 500gb mirrored SCSI (Raid 1) drive system. The database running on the server is about 11gb.

Does anybody have any suggestion we could try to increase the performance of the server? I've run a defrag several times which helps a little but I was hoping I could do something else to increase the performance.



Thank you.

View 7 Replies View Related

ActiveXScripting Error

Feb 25, 2008

Has anyone come across this.
I haven't found anything online as of yet.
I'm using VBScript to copy a file from one server to another.
This scripts works on all other servers but for some reason I get this error.
Anyone have any suggestions or work arounds.

I'm doing a nightly backup of a database which I copy from one server to the other as a scheduled job.

ActiveScripting specific error 257

thanks,
Jonathan

View 8 Replies View Related

Step By Step For Upgrading SQL Server 2000 Cluster To SQL Server 2005 Cluster

May 15, 2008



Friends -

Could any one of you provide steps for upgrading SQL Server 2000 cluster to SQL server 2005 cluster.

My environment is Windows 2003 server.

Appreciate your support.

Cheers
VSH

View 1 Replies View Related

Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005

Jun 5, 2006

I
am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set
the cluster up through Virtual Server 2005 with 2 virtual nodes and one
virtual domain. The nodes can connect to each other as well as the
physical machine. When I try to install a fresh copy of SQL 2005 on my
cluster, I get an error every time. The
error stops the installation while checking system configuration after
installing prerequisites. The log file entry is as follows:

*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:
IIS is not installed, therefore Report Server feature will be disabled
Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastoreclusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56

View 3 Replies View Related

Access Denied To Cluster Storage When Restoring 2005 Full Text DB To 2014 Cluster

Jun 10, 2015

I am in the process of moving databases from a SQL 2005 Standard version to a 2-node 2014 cluster.All of my 2005 databases back up successfully.They all restore without issue except for one database that has a full text catalog. I get this message

Msg 7610, Level 16, State 1, Line 2
Access is denied to "fileStoragedataMSSQLSERVERFullTextCatalog", or the path is invalid.
Msg 3156, Level 16, State 50, Line 2
File 'sysft_FTCatalog' cannot be restored to 'fileStoragedataMSSQLSERVERFullTextCatalog'. Use WITH MOVE to identify a valid location for the file.
Msg 3119, Level 16, State 1, Line 2
Problems were identified while planning for the RESTORE statement. Previous messages provide details.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

[code]....

I went as far as giving the folder full access to everyone temporarily and received the same error.

View 1 Replies View Related

SQL 2005 Ent(64bit) Error

Aug 22, 2007

Hello,

We have a sql2005 server, wich have 10 databases mirrored. Yesterday we had the following error:



Date 21-08-2007 14:13:18

Log SQL Server (Current - 22-08-2007 13:00:00)

Source Server

Message

Resource Monitor (0x2d18) Worker 0x000000008000C1C0 appears to be non-yielding on Node 0. Memory freed: 88080 KB. Approx CPU Used: kernel 234 ms, user 109 ms, Interval: 60000.

The error cause that one of our databases generated an automatic failover.

Who know what doe'st mean the error?

Could be a memory problem?



Windows 2003 Server R2, Standar x64 SP2

SQL 2005 Standar x64 SP2

4GB RAM,

DELL PowerEdge 2950,

Intel XEON CPU, 1.86 ghz,


thank

View 1 Replies View Related

Working In VB.Net 2005 Inserting NULL Into A Field In Microsoft SQL Server 2005

Feb 2, 2007

I am update/inserting records threw a web form in vb.net. I need to insert 'NULL'  into my microsoft sql server database.  I am not talking about the below line of code where website is the name of my paramater.  If i do that it will just place a blank into that field in the database.  If i dont enter anything into that textbox I want it to to say NULL in that field. So if I go into the actual table in the SQL Server Management Studio and look at the website field of the recored I just added or updated and did not type anything into the web site textbox it needs to say NULL.  I also tried the second line of code but that places a single quote in front and behind NULL. So the field will have the value 'NULL'.
website.value = txtwebsite.text.tostirng
 if txtwebsite.text ="" then
   website.value ="NULL"
end if
The reason why I need the NULL there is because I bind the website filed to a hyperlink template in a gridview.  The actual text of the hyperlink is bound to PAYER which is a name of a insurance payer but the navigateto is bound to the website field.  If i do not enter any data into the website field and it stays as NULL, then when my gridview is loaded, payers that dont have a website will not be underlined and user wont have the option to click on them since there is no value for the navigateto.  But if i use my form to update/add a payer and leave the website textbox blank in puts a blank into that field in my database and when it loads that new row into the gridview the PAYER is underlined and u can click on it but it will just take u to the web site is unavailable page.  So is there anyway to actaull have NULL placed into a filed and not just blank space

View 3 Replies View Related

SQL 2005 32bit Upgrade To 64bit Possible?

Nov 7, 2007

Just curious if it's possible, and supported, to upgrade SQL 2005 from32bit to 64bit. This is on top of Windows 2003 64bit. Trying to getthe proper supported config for OM2k7 without blowing everything away.Thanks,JDP

View 1 Replies View Related

Memory Support For Sql 2005 STD 64BIT

Jan 2, 2008



Hi,

I'm about to install Windows 2003 STD 64BIT and SQL 2005 STD 64BIT with 12GB MEM.

my question is about the switch in the BOOT.INI - do i need to enable any switch with this server configuration?

and do i need to enable the AWE on the SQL?


THX

View 7 Replies View Related

Reading Mail On SQL 2005 64bit

Jun 28, 2007

Hi all.



We have a problem with our SQL2000 32 bit to SQL2005 64 bit migration where we use
xp_readmail to check mailboxes for new messages containing incoming
data. This is no longer supported in SQL2005 64 bit edition. Are there any other
methods for checking mail in SQL2005 64 bit edition?

p.s. We're connecting to Exchange Server 2003

View 1 Replies View Related

SQL Server 2005 On A/A Cluster

Feb 14, 2007



We have SQL Server 2005 on windows 2003 server +SP1. In the application log I noticed the following errors during .

Event Type: Error
Event Source: MSSQL$SQL
Event Category: (3)
Event ID: 19019
Date: 2/13/2007
Time: 6:36:53 AM
User: N/A
Computer:xxx
Description:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure

Event Type: Error
Event Source: MSSQL$SQL
Event Category: (3)
Event ID: 19019
Date: 2/13/2007
Time: 6:36:53 AM
User: N/A
Computer: XXX
Description:
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed

...so got the below information from the cluster log:



000009fc.00000d68::2007/02/13-12:36:53.210 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.226 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.

000009fc.00000d68::2007/02/13-12:36:53.226 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] OnlineThread: QP is not online.
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
000009fc.00000d68::2007/02/13-12:36:53.242 ERR SQL Server <SQL Server (ITG)>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
0000088c.00000af8::



Looked at the system log to see if there are any errors , but could not found any during that time....The last message in the system log was



Event Type: Warning
Event Source: Print
Event Category: None
Event ID: 3
Date: 2/13/2007
Time: 5:03:04 PM
User: NT AUTHORITYSYSTEM
Computer: xxx
Description:
Printer ITGHP8N1 on rchprt01 (from R6911497-XP) in session 1 was deleted.



before that there were messages of creating and deleting the printer...and R6911497-XP is my laptop which was not really running during that time...



From some research came to know that this might be because of network issues, but let me know for what errors I need to look for network issues...does the above error in the system log suggests network errors...



Any help is appreciated...









View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved