Call Web Service From Sql Server 2000 Job

Mar 5, 2007

I would like to call a web service from a sql server 2000 s.proc/sql job, but if there is a better way please let me know. 
I'm using Captaris Workflow to create and manipulate workflow processes.  I have a sql job that will create some pdf's.  I want to call the web service that creates a new process in a step from that sql job.  I have read about doing this with extended s.procs, but I'm trying to find any possible solutions.  Essentially, the web method I want to call will insert several records into sql so I know I can at least do that.  I would still like to know if I can make a call to the web service from the sql job.

Thanks for any help.

 

View 1 Replies


ADVERTISEMENT

What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?

May 18, 2007

Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running:
Date 17.04.2007 16:42:10
Log Job History (FailureNotificationJob)

Step ID 1
Server MSK-CDBPO-01
Job Name FailureNotificationJob
Step Name MainStep
Duration 00:00:00
Sql Severity 16
Sql Message ID 6522
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: CORPmssqlserver.
A .NET Framework error occurred during execution
of user defined routine or aggregate 'StartNotification':
System.Security.SecurityException: Request for the permission of type
'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException:
at System.Security.CodeAccessSecurityEngine.Check(Object demand,
StackCrawlMark& stackMark, Boolean isPermSet)
at System.Security.CodeAccessPermission.Demand()
at System.Net. The step failed.

What is the reason of this behaviour? Unfortunately I do not have direct access to this server.
I have the following guesses:
1) CORPmssqlserver may have not enough permissions to call web service
2) Something wrong with SQL Server account's permissions
2) Something wrong with SQL Server Agent account's permissions
I will take the will for the deed. Thanks.

View 1 Replies View Related

Call .NET Web Service From SQL Server

May 3, 2004

Hi,
I have a situation where I need to call a web service from the database (by an insert trigger on a table). Please let me know how I could do this.
Thanks in advance
Raj

View 1 Replies View Related

Deploying CLR Sps Or Functions Which Call A Web Service To A Production Server

Aug 30, 2006

Dear fellow developers,

I have successfully developed a Transact-SQL stored procedure which calls a CLR function, which calls a web service. I am using a Visual Studio 2005 SQL Server Project to perform the necessary magic.

Is there a neat way to deploy this stuff to a production server?

It is bad enough deploying the sp and function, but the web server proxy also needs to be changed to refer to the production web service.

This all looks very nasty and complicated.

Am I missing something?

View 4 Replies View Related

SQL Server 2008 :: Restoring A Database / Server Using A Remote Server As The Service Call?

Jan 4, 2013

if you can restore a database to Server B using Server A as the service. Meaning we would issue the command on Server A but somehow point to Server B as where we want the restore to happen.

The backup file would be in a location independent of both servers.

View 4 Replies View Related

Amazon Web Service Call With Web Service Task

May 4, 2006

With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS?



[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

or


[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.AWSECommerceService.SellerLookup' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

View 6 Replies View Related

SQLExecDirectA Call Hangs Up On SQL Server 2000

May 7, 2007

Hi,

I am trying to execute a stored procedure on SQL server 2000 Developer edition through ODBC. I am using a VC++ client for the same. The stored procedure has 51 parameters. The issue is that the response on method SQLExecDirect is not consistent. At times it will return success or failure based on parameter values, otherwise it just hangs up. The code snippet is like -


// get database handle

// get statement handle


//call sql bind parameter


// set memory for query string and copy it


// strcpy(sqlString,"{call pi_ml_*******(?, ?, 2, 0, 0, ?, ?, 100,'2007-05-04 19:37:37.357', '2007-05-04 19:37:37.357', 1, 1, 72, ?, 72, ?, ?, ?,0, 0, ?, 0, NULL, NULL, 0, 0, 0, 0, ?, '2007-05-04 19:37:37.357', ?, ?, ?, 0, 0, ?, ?, 0, NULL, ?, ?, 0, NULL, NULL,NULL, NULL, 0, NULL,NULL, 0, 0, 0)}");



//call sqlexecDirectA( for an ANSI build)


returnVal = SQLExecDirectA(hstmt, (UCHAR*)sqlString, SQL_NTS);




It appears to be some locking issue but I am the only user for the database. This code works perfectly fine for other stored procedures. I have tested the parameters on SQL analyzer store procedure execution utility.




Thanks,

Peeyush

View 1 Replies View Related

Can I Call A Web Service From SQL??

Sep 14, 2006

I have two databases with two identical tables in seperate physical locations. I want database B tables to be updated automatically when database A tables change. Is there a way to call a web service from SQL to make this happen? Or is there a better way to do this? I would really like it to get the rows that were modified and then copy only those rows to the other database tables. If anyone knows if this can be done please let me know. Thank you.   

View 4 Replies View Related

Why Cant I Call A Sql Web Service From A Url?

Feb 16, 2008

With regular .net web services in vb.net I can expose the service and call it like this:


http://server/EnrollmentLookup/EnrollmentService.asmx/GetS3MonitorLogs?StartDate=02/02/08&EndDate=02/05/08

But when I create a SQL XML Webservice via an endpoint all I can find on the net is how to show the wsdl.

http://localhost/Contacts?wsdl

Ive created a method in the "Contacts" webservice called GetContacts. Why cant I construct a similar url to execute that method without having to write a vb.net wrapper for it?

View 6 Replies View Related

Call Web Service From The Database

May 3, 2004

Hi,
I have a situation where I need to call a web service from the database (by an insert trigger on a table). Please let me know how I could do this.
Thanks in advance
Raj

View 1 Replies View Related

Call A WCF Service From SQL CLR Sproc

May 21, 2007

It is possible to call WCF from SQL CLR, can I add a web reference or use the proxy created with svcutil ?

View 1 Replies View Related

MS Reporting Service - Call Code

Mar 19, 2008

Hello,

I have a microsoft report that uses a dll to calculate a value. If I hard code the value, my report shows it. My method in the dll is connecting to a database in order to calculate a result. However, in order to connect to the database, I am using Microsoft.Practices.EnterpriseLibrary.

The error in my report is:
Could not load file or assembly 'Microsoft.Practices.EnterpriseLibrary.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The system cannot find the file specified.

I have added a reference in the report to the EnterpriseLibrary but this has not made a difference.

Many thanks!

View 1 Replies View Related

Web Service To Call Integration Services

Oct 6, 2006

Hi,

I'm hoping someone has tried something similar before. I am trying to run an integration from a remote computer using a web service. I have set up the web service and the bog standard launch package routine works fine. What i'd like to be able to do is to launch a package and also specify any parameters associated with it. I have the following code which is identcal to the main launch sub with the exception of an extra argument (jagged array of varible name and value variablePair[4][2]). It also processes the variable array and sets them on the DTSPackage object.

[code]
[WebMethod]
public int LaunchSSISPackageWithVariables(string sourceType, string sourceLocation, string packageName, string[][] variableArray)
{
string packagePath;
Package myPackage;
Application integrationServices = new Application();

// Combine path and file name.
packagePath = Path.Combine(sourceLocation, packageName);

switch (sourceType)
{
case "file":
// Package is stored as a file.
// Add extension if not present.
if (String.IsNullOrEmpty(Path.GetExtension(packagePath)))
{
packagePath = String.Concat(packagePath, ".dtsx");
}
if (File.Exists(packagePath))
{
myPackage = integrationServices.LoadPackage(packagePath, null);
}
else
{
throw new ApplicationException("Invalid file location: " + packagePath);
}
break;
case "sql":
// Package is stored in MSDB.
// Combine logical path and package name.
//if (integrationServices.ExistsOnSqlServer(packagePath, ".", String.Empty, String.Empty))
if (integrationServices.ExistsOnSqlServer(packagePath, ".", "executeSSIS", "p4ssw0rd"))
{
//myPackage = integrationServices.LoadFromSqlServer(packageName, "(local)", String.Empty, String.Empty, null);
myPackage = integrationServices.LoadFromSqlServer(packageName, "(local)", "executeSSIS", "p4ssw0rd", null);
}
else
{
throw new ApplicationException("Invalid package name or location: " + packagePath);
}
break;
case "dts":
// Package is managed by SSIS Package Store.
// Default logical paths are File System and MSDB.
if (integrationServices.ExistsOnDtsServer(packagePath, "."))
{
myPackage = integrationServices.LoadFromDtsServer(packagePath, "localhost", null);
}
else
{
throw new ApplicationException("Invalid package name or location: " + packagePath);
}
break;
default:
throw new ApplicationException("Invalid sourceType argument: valid values are 'file', 'sql', and 'dts'.");
}

//Variables var = myPackage.Variables;
//foreach (string key in variablePairs.Keys)
//{
// var[key].Value = variablePairs[key].ToString();
//}

Variables var = myPackage.Variables;

for (int i = 0; i < variableArray.Length; i++)
{
var[variableArray[0]].Value = variableArray[1].ToString();
}

return (Int32)myPackage.Execute();
}
[/code]

For some reason the above code runs and passes back the value that it succeeded. Yet the package doesn't do what it should. Does anyone have any ideas as to why this might be the case or even a better way to pass the variables.

Many thanks,

Grant

View 5 Replies View Related

Trying To Call The Function A Web Service From Transact-SQL

Jun 2, 2006

I currently have the fllowing Stored Procedure. When I pass the the Url of the web service in the parameters, I'm having a sp_OAMethor read response failed error.

I don't know how to pass the parameter as well as the name of the function in the Web Service I'm calling. Maybe I'm all wrong here with this code too?

Thanks for any help.



ALTER PROCEDURE [dbo].[pTAPServiceWeb]

@sUrl varchar(200),

@response varchar(8000) out

AS

DECLARE @obj int

DECLARE @hr int

DECLARE @status int

DECLARE @msg varchar(255)

EXEC @hr = sp_OACreate 'MSXML2.ServerXMLHttp', @obj OUT

IF @hr < 0

BEGIN

RAISERROR('sp_OACreate MSXML2.ServerXMLHttp failed', 16, 1)

RETURN

END

EXEC @hr = sp_OAMethod @obj, 'Open', NULL, 'GET', @sUrl, false

IF @hr < 0

BEGIN

SET @msg = 'sp_OAMethod Open failed'

GOTO err

END

EXEC @hr = sp_OAMethod @obj, 'send'

IF @hr < 0

BEGIN

SET @msg = 'sp_OAMethod Send failed'

GOTO err

END

EXEC @hr = sp_OAGetProperty @obj, 'status', @status OUT

IF @hr < 0

BEGIN

SET @msg = 'sp_OAMethod read status failed'

GOTO err

END

-- IF @status <> 200

-- BEGIN

-- SET @msg = 'sp_OAMethod http status ' + str(@status)

-- GOTO err

-- END

EXEC @hr = sp_OAGetProperty @obj, 'responseText', @response OUT

IF @hr < 0

BEGIN

SET @msg = 'sp_OAMethod read response failed'

GOTO err

END

EXEC @hr = sp_OADestroy @obj

RETURN

err:

EXEC @hr = sp_OADestroy @obj

RAISERROR(@msg, 16, 1)

RETURN

GO

View 3 Replies View Related

How To Call Web Service From Within Script Component ?

Feb 9, 2007

Appreciate if anyone can show me the code to call a web service from Script Component ?

I cannot use the Web Service Task. Because parameters to the webservice are from rows of data inside Data Flow Task.

Thanks !!

View 11 Replies View Related

Call Web Service From Script Task

Jul 2, 2007

I am trying to call a web service using the web service task and passing it variables, but even when I set variables to be Strings/any other data type, they always get passed out as objects. The call is then rejected based on the fact that there is no web service that accepts those parameter types. If there is a workaround to this problem, that would be great, otherwise I think I'm going to have to call the web services in a script task. Would someone please give me an example of the steps necessary to call a web service from the script task?

Thank you,

James Mac William

View 10 Replies View Related

Using Ssis Task To Call A Web Service

Jan 11, 2007

Hi,

I m trying to use the web services task, but when i try to run it i got the following error

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object..    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser)    at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".

This is probably because i never worked with this task, even so, does anyone knows what might be wrong?

I got a connection a wsdl, i can configure the service, method and variables(i use fixed values), and i configure the output to a variable with the type object(i have tryed string and int)

I even can download the wsdl file, but the error seems to be in the connection

Thanks

 

View 7 Replies View Related

Web Service Call Parameter Greater Than 4k Char

Apr 2, 2007

We have a requirement to call a Web Service method from SSIS where the method accepts a single parameter that is derived from a database recordset and can exceed 4k characters. From the little we know about the Web Service task it is limited to only accepting direct input and variables. Does anyone have any suggestions to overcoming this issue? Any detailed information in possibly calling the Web Service from script or using an object variable would be extremely appreciated.



Thank you in advance for your help.

View 2 Replies View Related

How To Use A Dialog Retry Timer For Doing A Web Service Call

Feb 7, 2007

Hi Remus,

I just started looking into SB about a week ago, so my question is likely to be pretty lame. However, that's not going to stop me from asking it :-)

We're trying to do something similar to what you're describing here. How do you "reset" a dialog timer? Why would you need to deal with resetting timers (or with timers at all for that matter) in the event of a success? Couldn't you rewrite the logic to be as follows?


begin transaction
receive message
if message is web request
save state of request (http address, caller etc)
else if message is retry timer message
load state of request
endif
commit
do the web request (no transaction open)
if success
begin transaction
send back response
end conversation
commit
else
set a retry timer on the dialog (say 1 minute) using BEGIN DIALOG TIMER
endif

Also, when you set the retry timer you have to associate it with the saved request state, right? Otherwise, how will the service know which request to load on receipt of the timer message?

TIA.

View 6 Replies View Related

JDBC SQL Call Failure After Database Service Is Restarted

Nov 28, 2007

Hello ,

I get this error (connection closed) in web applications, whenever SQL Server database Service is restarted. When I run the application again, the error disappears. Granted that there are lots of users and Database gets restarted every night is not helping.

Is there any setting in the JDBC driver properties, where I can tell it to open a closed connection (like a retry count), rather than fail the first time and work the second time.

We use
1. SQL SERVER 2005 SP2,
2. Websphere Protal Server 5.1
3. SQL SERVER 2005 JDBC driver 1.1(com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource.)

I am wondering if connection pool driver is causing this problem. I do not care about connection pooling, but Websphere doen not seem to like any other JDBC Driver. I don't mind switching to another driver as the last option.

Error is :
[11/27/07 17:01:59:331 MST] 7202440d WSRdbManagedC W DSRA0080E: An exception was received by the Data Store Adapter. See original exception message: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.getCatalog(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.getCatalog(WSRdbManagedConnectionImpl.java:676)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.introspectSelf(WSRdbManagedConnectionImpl.java:808)
at com.ibm.ws.rsadapter.FFDCLogger.introspect(FFDCLogger.java:169)
at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.introspectSelf(WSJdbcConnection.java:1253)
at com.ibm.ws.ffdc.IntrospectionLevelMember.getNextMembers(IntrospectionLevelMember.java(Compiled Code))
at com.ibm.ws.ffdc.IntrospectionLevel.getNextLevel(IntrospectionLevel.java:181)
at com.ibm.ws.ffdc.ObjectIntrospectorImpl.dumpContents(ObjectIntrospectorImpl.java:67)
at com.ibm.ws.ffdc.ObjectIntrospectorImpl.dumpContents(ObjectIntrospectorImpl.java:51)
at com.ibm.ws.ffdc.IncidentStreamImpl.introspectAndWrite(IncidentStreamImpl.java:396)
at com.ibm.ws.ffdc.IncidentStreamImpl.introspectAndWriteLine(IncidentStreamImpl.java:632)
at com.ibm.ws.ffdc.DiagnosticEngine.dumpObjectAndStack(DiagnosticEngine.java:301)
at com.ibm.ws.ffdc.DiagnosticEngine.processIncident(DiagnosticEngine.java:147)
at com.ibm.ws.ffdc.FFDCFilter.filterEngine(FFDCFilter.java:428)
.......lots of lines


Regards
Bobba

View 3 Replies View Related

Modify The RSReportServer.config File With Web Service Call

Jan 11, 2008

Is there a way to modify the RSReportServer.config file with a Web Service call. We want to install an app and have it modify the Renders. We want to remove the Tiff export for example. We also want to add simple headers to Excel. Right now we have to open the file and then make our edits.

View 1 Replies View Related

Install Sql 2005 Instance With Reporting Service 2005 On Sql 2000 With RS 2000 Server

Aug 18, 2006

Hi

We would like to install Sql 2005 Enterprise Edition (including database engine, reporting service, integration service and analysis service) as a sepearte instance on a server which already has Sql 2000 with reporting services and analysis services. We do not want to disturb the existing sql 2000 setup.

If we do that then what will happen to my earlier sql 2000 reporting service? Will it be upgraded to sql 2005 reporting service? I heard that reporting services are instance unaware application. Where will be the default reporting service database available?

Please help us.

Regards,

Sankar N

View 1 Replies View Related

Sql Server 2000 Service Pack 3

Feb 21, 2004

Hi,
I am trying to install the service pack 3 for sql server 2000 but cannot do it. I keep getting stuck at the screen where it asks u for the windows authentication or the sa password.

I select the sa password option and enter the password but it gives me an error saying that it was unable to connect.

Can someone tell me what to do.

Kind Regards,

Yoshi

View 1 Replies View Related

Where To Get SQL Server 2000 Reporting Service For VS.NET?

May 5, 2004

Where to get SQL server 2000 reporting service for VS.NET?

View 4 Replies View Related

SQL Server 2000 Service Pack 3a

Dec 19, 2004

Hi all,

I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks

View 1 Replies View Related

SQL Server 2000 Service Pack 3a

Dec 19, 2004

Hi all,

I have msde version 8.00.534 that is sp2 I think. When I attempt to upgrade to sp3a I get: “The instance name specified is invalid� . I am working with win XP home edition that include IIS.
Have some suggestions? Thanks

View 1 Replies View Related

SQL Server 2000 Service Pack 2

Apr 22, 2002

Hi all,
I want to setup the SP2,so I like to know before if the SP2 is valid and proved and with SP2 I have any problem on administring the server.

Thanks in advance
Jalal

View 1 Replies View Related

Applying Service Packs To SQL Server 2000 Instance Attached To Sql Server 2005

Jan 8, 2008

Hi,

I have an interesting situation here. I have a SQL Server 2000 database which is attached to SQL Server 2005. The database (SQL 2000) however only has service pack 3 applied. I need to apply SP4 before I can move forward with SQL 2000->2005 upgrade. The question: can I somehow apply this support package with my current configuration or should I install full SQL 2000 front-end anew (which I don't have at the moment)? Whenever I try to run SQL 2000 SP4 it complains "SQL Server 2000 is not installed on this machine."

The server I try to install the update is Windows Server 2003 R2 Standard Edition x64. SQL Server 2000 database itself is x86 (obviously).

Thanks.

View 4 Replies View Related

Service Pack Available For Sql Server 2000 With Windows XP.

Oct 12, 2006

 How to find out the SP available for sql server 2000 with win xp 

View 8 Replies View Related

The Problem About SQL 2000 Server Agent Service..............

Aug 29, 2004

When I run sp_delete_job to delete the whole job inside,
will the job steps, job schedules and job servers of that job will be deleted automatically also?

so, do i need to run sp_delete_job only?
or need sp_delete_jobstep, sp_delete_jobschedule and sp_delete_jobserver also?

View 1 Replies View Related

Why SQL Server 2000 Service Eating So Much Memory?

Feb 9, 2007

Hi to all, i have a very important problem...pls help me

I have a server with Windows 2003 Server (3GB RAM) and SQL SERVER 2000 running on it, my problem is that sqlserv.exe eat 2GB RAM even if on this server nothing happen....if i restart the service of SQL Server everything is ok eat just 30 MB RAM but after some minutes...after i made a simple select or a simple delete....simple things he arrive to 2GB RAM...this not happen until now(2 days ago)...the problem is that when he arrive to ~2GB RAM the statio run very slow and i receive the error "Time out expire"

this problem happens and on my local station where i have Win XP PRO (1 GB RAM) SQL Server 2000....

thx a lot

View 1 Replies View Related

SQL Server 2000 Service Pack 3a Question

May 26, 2004

There are three separate downloads for this:

1) Sql2ksp3.exe. Updates for database components.
2) Sql2kasp3.exe. Updates for Analysis Services components.
3) Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).

Number 2 makes perfect sense. Analysis Services is separate from the rest of the database.

What is the difference between 1 & 3? What is the Desktop Engine, how do I know if I'm using it, and how do I know if it has already been patched?

View 2 Replies View Related

SQL Server 2000 Service Pack 4 Won't Install

Jul 20, 2007



I'm trying to install Service Pack 4 to our default instance of SQL Server 2000 with SP3a, on a Windows 2003 Server, which also has a named instance of SQL Server 2005 on it and a named instance of SQL Server 2000 with SP4.



The installation appears to be running just fine, but MUCH too quickly. The last window appears stating something along the lines of 'Updating Active X components'. I'm expecting the scripts to run to update my system stored procedures, etc., but that never occurs. The installer just quits.



No errors in the Windows logs, nor in SQL, and no C:WindowsSQLSP.log file.



I tried the installation again, but this time used a different copy of the service pack 4 installer, with the same results, and again no SQLSP.log file.



Since I was going to remove the named instance of SQL Server 2000 anyway, I verified that my SP4 installer was good by uninstalling the named instance of SQL Server (the one with SP4 already), reinstalling a named instance of SQL Server 2000, and reapplying SP4 to this named instance. Everything went flawlessly.



I then tried reapplying SP4 to the default instance of SQL Server 2000, and this time a SQLSP.log file was finally generated. In the error log, the last entries are:



19:10:03 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1SQLDBR~1.EXE sqldbreg2.exe -RegServer
19:10:04 An error occurred while setting the registry value for: SoftwareMicrosoftMSSQLServerMSSQLServer
19:10:04 Could not restore AuditLevel registry key
19:10:04 Action CleanUpInstall:
19:10:04 Installation Failed.


I confirmed that the service accounts that are running SQL Server both have local administrative access to the server (which may or may not matter), and that they are both sysadmin, so I don't think it's a permissions issue to the registry. I've also verified that the account I was using to run the SP installation also has local admin access on that box.



So, I compared my HKLMSoftwareMicrosoftMSSQLServerMSSQLServer registry entry from our production server to the one on the test server, I see that our test server's entry is completely empty. On production there are numerous subkeys, such as CurrentVersion and RPCNetLib.



I'm planning on copying the registry entries from production to test. Should this be sufficient, or are there other things I should look out for?



View 10 Replies View Related







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