Hi
I have SQL Server 2000 (SP4) running on an Windows 2003 SP 1 server. I have started to get the error message "Connection to application object failed - Ensure no program modules have been deleted" when I go into Enterprise Manager.
I have tried reinstalled SQL Server and applied SP4 but to no effect. Can anyone help?
Mark
When I install the SQL Server 2005 SP2 on my vista laptop, I get the following message: SQL server setup failed to compile te Managed Object Format (MOF) file c:program filesmicrosoft SQL Server90sharedsqlmgmproviderxpsp2up.mof. To proceed, see "troubleshooting an installation of SQL Server 2005" or "how to: View SQL Server 2005...
What did I wrong?
Greets,
Wouter
Hi,
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
With regards
Mahender
I have to create a query that will be returning the users and the application modules they have access for. Along with the list of users and modules the query should also return if any module is not accessible for that user.
The 'ApplicationUsers' table is like this:
CREATE TABLE #ApplicationUsers
(
userId INT,
UserName VARCHAR(50)
)
INSERT INTO #ApplicationUsers VALUES
(1, 'Daniel'), (2,'Martin'), (3, 'Brandon'), (4, 'Doug')The 'ApplicationModule' table is like this:
[Code] .....
I used pivot query but there are a couple of limitations in it(may be I am making mistakes in it). First, the pivot columns are static whereas I need dynamic column names(Application Modules). Second, I need to include all the users with all the modules with access or without access that I am unable to achieve.
Hi
First up - my apologies if this is not the right forum for this question. Please let me know if there is a more appropriate one for this question.
I have come across an issue with my SQL Server 2005 Express Edition install. It has been running fine since the install (a few months back). And I can still interact (query, update etc) the databases just fine. However, SQL Management Server Studio Express has started to produce an error message when I attempt to connect the Object Explorer.
The error message is shown below.
I have tried to access the link shown in the error message but there is no information provided there.
I can use SQL Management Server Studio Express to run queries on the databases so it would appear that the underlying services are all running OK.
The SQL Server is installed using SQL Authentication only and I have not made any changes to Service accounts or the services themselves. The protocols all appear to be in order too - Shared Memory, Named Pipes, TCP/IP are all enabled.
I have restarted the SQL services and even rebooted the machine, but to no avail.
I would really appreciate if anyone out there could give me some guidance on what may be causing this issue.
Note: The SQL Server is installed on WinXP Pro SP2 running in a VirtualPC. All apps are release versions (no beta or CTP)
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
A severe error occurred on the current command. The results, if any, should be discarded.
A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Hi ,
I installed Ms As 2005 and visual studio 2005 in the machine but i can see visual studio 2005 is working fine.but the problem is with analysis studio when i try to connecting to Analysis studio am getting error like - A connection cannot be made.Ensure that the server is running.
Please help me on this.
I have developped an ASP.NET 2.0 webb application localy on my workstation and have the MSSQL2000 database on a server.There has been no problem accessing the database during development.
Im now finnished and put the application on a web server.
No when i try to access the application i get the following problem as it tries to reach the database:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
I still use the same database so remote connections are allowed and there are lot of application against that sqlserver already running.
I have anonumouse access and use a domain service account for the application and that very same account is added as a login to the sqlserver and a domainuser in the database.
I have Forms authentication in my web.config file.
the connectionstring i use look like this:
<appSettings> <add key="app1" value="Data Source=server01;Initial Catalog=database1; Integrated Security=SSPI;"/></appSettings>
Can somebody please tell me what is wrong and how to fix it. I dont change any configuration betweeen my workstation and the server in web.config
/ in pain!!
hi... i need help.
i tried to install sql server 2000 on my laptop (WinXP os) and when i reach the form where im supposed to click "Install Database Server", the next form after clicking "Install Database Server" wont show, and there are no error messages. I tried everything i could but it didnt work. My last choice is to format my computer - but i dont want to do that.
there are two processes running on the background that has SQL in its name - SETUPSQL.EXE and SQLSTP.EXE. I think this shows that the setup is still running.
i need help asap please, and i dont want to format my computer...
thanks in advance!
hi ,
i am creating a service broker application between two different instance.when i am initiating a dialog from the source my message remain in the sys.transmission_queue.but its transmission_status column is empty.
i attached the profiler with both source and target by including all the service broker event.
in my source profiler i am getting the error like -- Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'. with event Broker:connection
and in the target profiler error is --This message could not be delivered because the security context could not be retrieved. with event Broker:Message Undelivarible.
i have checked my port also using telnet with remotely and localy both working fine. i am using port no. 4001
and i have mentioned the port no. in the address of the route.
bt still getiing the error.
please help!!!!!!!!!!!
hi all,
my problem is failure in the connection to SQLserver2000 remotly( to city a) by enterprise manager or query analyzer via windows authentication ( this error appears "login failed for (domain/user)" ),while no problems happened in the connection when i would to connect to other servers at other locations(to cities b,c) via windows authentication.
note that i can access to (city a)server via sql server authentication , but i want to access to this server(city a) via windows authenication as the other locations because this authentication mode is policy of our system, and note also that persons in city b can access to all servers (city a,c) via windows authenication .
regards,
Hi,
I wanted find the log information if anybody deleted my database or bojects in my server.
Is it possible we can able to find this details in my previous log or any sys tables ?
Thanks
have SQL Server 2005 std edition SP1 installed on Windows 2003 Std edition .Configured Transactional (single Publisher and no clustered environment.)
Replication past two months working fine, Now
1.Distrib.exe application err is coming.
Due to which my job is failing (Distributor to Subscriber).
Iam attaching thw file.
Thanks
Sandeep
Hopefully someone can at least point me in the right direction for moreresearch (e.g.: correct terminology). My only previous experience was justdumping data into a database using ODBC, and that was some years ago so nowmostly forgotten.I need to write an NT Service/Application (in C/C++) that will be gettingdata sent to it via SQL Server 2000. The data will arrive in my SQL Server(read-only access), via replication of tables from another remote SQLServer.My application needs know when new row are inserted, or updated so it can toread this data (needs to be quick/timely so hopefully no polling) to theninterface with other remote proprietary systems.T.I.A.PS: If you can recommend appropriate books on SQL Server 2000 that wouldalso be useful.
View 2 Replies View RelatedSir i am trying to connect sql from my LAN to my networked computers but whenever i tried to register it through Enterprise manager i get following "SQL Server registration failed because of the conection failure displayed below.Do you wish to Register anyway? Login failed for user 'SW17/Guest'
where SW17/ is my another computer name...
i have checked tcp and named pipes
and confirm username for sql authentication too
please help me as i being late submit my project
I added a connection (ADO.NET) object by name testCon in the connection manager - I wanted to programmatically supply the connection string. So I used the "Expressions" property of the connection object and set the connectionstring to one DTS variable. The idea is to supply the connection string value to the variable - so that the connection object uses my connection string.
Then I added a "Backup Database Task" to my package with the name BkpTask. Now whenever I try to set the connection property of BkpTask to the testCon connection object, by typing testCon, it automatically gets cleared. I am not able to set the connection value.
Then after spending several hours I found that this is because I have customized the connection string in testCon. If I don't customize the connection string, I am able to enter the "testCon" value in the connection property of the BkpTask.
Is this an intrinsic issue?
Hi, I am deploying my web through a web hosting services which provides SQL database support. I got following errors whenever I try to open my webpage,which never happen when I run my web on the local machine. I have my connection string configured in my web.config as below:
<add name="ArtHouseConnection" connectionString="Server=serveripaddress; Integrated Security=True; Database=arteh3_database;User Id=username;Password=password;" providerName="System.Data.SqlClient"/>
<add name="ASPNETDBConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
This is the source code where error was generated:
public static class ArtHouseConfiguration
{
//cache connection string
private readonly static string dbConnectionString;
//cache data provider name
private readonly static string dbProviderName;
private readonly static string siteName;
//initialize constructor properties
static ArtHouseConfiguration()
{
dbConnectionString = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ConnectionString;
dbProviderName = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ProviderName;
siteName = ConfigurationManager.AppSettings["SiteName"];
}
and finally this is the error mg I got:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Source Error:
Line 30: static ArtHouseConfiguration()
Line 31: {
Line 32: dbConnectionString = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ConnectionString;
Line 33: dbProviderName = ConfigurationManager.ConnectionStrings["ArtHouseConnection"].ProviderName;
Line 34:
Source File: d:inetpubvhostsartehouse.orghttpdocsApp_CodeArtHouseConfiguration.cs Line: 32 Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
ArtHouseConfiguration..cctor() in d:inetpubvhostsartehouse.orghttpdocsApp_CodeArtHouseConfiguration.cs:32
[TypeInitializationException: The type initializer for 'ArtHouseConfiguration' threw an exception.]
ArtHouseConfiguration.get_EnableErrorLogEmail() in d:inetpubvhostsartehouse.orghttpdocsApp_CodeArtHouseConfiguration.cs:74
Utilities.LogError(Exception ex) in d:inetpubvhostsartehouse.orghttpdocsApp_CodeUtilities.cs:100
ASP.global_asax.Application_Error(Object sender, EventArgs e) in d:inetpubvhostsartehouse.orghttpdocsGlobal.asax:20
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.HttpApplication.RaiseOnError() +182
Anyone got any ideas? thank you!
Hello,
I created a test stored procedure in MS SQL 2000. When the problem in my app was fixed, I deleted this test stored procedure. But the backup job thinks this procedure still exist and so backup job would failed. How can I fix this problem?
Thank in advance for your assistance.
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
Hi,My situation follows: I set up a database called TempDB and a test connection to it that works on my machine.In my database class I am trying to create a connection by doing the following:
connToLookUpData.ConnectionString = "Integrated Security=SSPI;Initial Catalog=dbTest;Data Source=testServer;"
but I am getting the following error: Login failed for user "Joe/ASPNET"i have windows XP OS.I based the connection string on the properties of my connection to Database 'Test'.Joe is the name of my computer. Both the application and SQL Server are now on my local machine.What am I doing wrong? any help greatly appreciated.Thanks much,Joe
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
Full message:
Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 66
Under these conditions, setting trustworthy on on the sending and receiving databases will solve this issue
1) Communicating between multiple instances
2) Using Kerberos security (NT Authentication, i.e. not certificates)
We have an application that takes an existing cube, clones it and then updates it in C#.
Database dbTarget = dbSource.Clone();
dbTarget.Name = databaseName_Target;
dbTarget.ID = databaseName_Target;
dbTarget.DataSourceImpersonationInfo = new ImpersonationInfo(ImpersonationMode.ImpersonateServiceAccount);
sSAS_CalculationServer.Databases.Add(dbTarget);
dbTarget.Update(UpdateOptions.ExpandFull);
We are receiving the following error when trying to Update the cube (the last line of code)Cannot update the 'Database' object 'DB Cube_Temp', it needs to be part of a connected Server object.
Dear members,I'am thinking about the "best" way to connect to my sql-server viaADO.Net (if there is a best way).My application uses the sql-server very intensively. At the momentevery database-operation opens a connection, executes and then closesthe connection.Another way would be to use only a single connection to the database,which is opened when the application starts.What do you think is the better way to get a high performing sqlserver: using one single application connection vs. using oneconnection for every operation?Cheers, Sebastian
View 2 Replies View RelatedPlease i have a question,
I want to use temporary tables to handle my forms child tables data.
My question is after i load the data from #temporary table to my dataset then i will close my database connection.
Does my temporary tables gets dropped off as soon as i do the connection.close.
or do i need to drop the #temporary table by code.
Which one is right.
I know #temporary tables are specific to the users(session)
Thank you very much in advance.
why we use sql exceptions ...
what the program will do if we caught that exception .. i need some suggestions ... i got this exception(String or binary data would be truncated.
The statement has been terminated.).. will it affect the functionality of the program...
hiow can i avoid this exception..
I am running the Sept CTP. I have created a SSIS package that pulls data from a text file and inserts into a database. When I run the package on the DB server it runs fine. I have moved the package the the web server (we are attempting to kick off the package from a web site) and we get connections errors. We are running the package using dtexec from the command line.
View 7 Replies View RelatedI have a vb.net desktop application that uses msde 2000 for its databasing. I am trying to create a setup file using the output of my desktop application and the msde 2000 merge modules in order to install my own build plus an instance of msde 2000.
The setup runs properly and then asks me to restart my machine. After the restart, however, there is no such instance running on my machine. I am adding the following internal properties to my msi file using ocra:
SQLMSDESelected 1
SqlInstanceName Midas
SqlSaPwd Password1
SqlSecurityMode SQL
SqlDataDir C:Program FilesMicrosoft SQL ServerMSSQL$MidasData
SqlProgramDir C:Program FilesMicrosoft SQL Server
This should create an instance of msde on my machine but when I try to connect using enterprize manager or query analizer (I connect to <<machinename>>Midas), then I get the standard can not connect error.
I am at my witt's end and would really appreciate any help.
Thanks.
Hi,
I have a table in my database with several car types, and the order I want for that table is:
Car_typeA_1
Car_typeA_2
Car_typeA_3
Car_typeA_4
Other_Cars_typeA
Car_typeB_1
Car_typeB_2
Car_typeB_3
Other_Cars_typeB
Car_typeC_1
Car_typeC_2
Car_typeC_3
Car_typeC_4
Car_typeC_5
Other_Cars_typeC
...
This table is more or less always the same, but from time to time I want to add a new car type, for instance; Car_typeA_5, but this new type must be located under the last register, in the example under ‘Other_Cars_typeC’. So, now the order is wrong, and when I want to display these car types to a web form object, the items will appear wrong ordered.
My question is: To order the values(items) correctly, Where I have to do it? In the web page (ASP.NET) code behind, or somewhere in SQL Server (for example in the Stored Procedure that passes the value to the application)? Or maybe in the same database table..?
Thank you,
Cesar
SELECT [DEFINITION]
FROM SYS.SQL_MODULES WHERE [OBJECT_ID] = OBJECT_ID(@OBJECTNAME)
I know I can use SP_HELPTEXT to get linebreaks, The reason I want to use this is I can exclude comments section from SQL_Modules, but cannot exclude the comments section from SP_HELPTEXT.
it took 1h 30 min as usual to execute. But this job failed. any ideas.
-----------------------------------------------------------------------
DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSTransferObjectsTask_1
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting objects for Transfer; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Logins; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Users; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 35 Percent Completed; PercentComplete = 35; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Enumerating objects for Transfer : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 1 Percent Completed; PercentComplete = 1; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 3 Percent Completed; PercentComplete = 3; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 7 Percent Completed; PercentComplete = 7; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Destination drops : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 50 Percent Completed; PercentComplete = 50; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting dependent object drops : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Rules; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Rules : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Defaults; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Defaults : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User defined datatypes; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 27 Percent Completed; PercentComplete = 27; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 31 Percent Completed; PercentComplete = 31; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 33 Percent Completed; PercentComplete = 33; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 37 Percent Completed; PercentComplete = 37; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 39 Percent Completed; PercentComplete = 39; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 41 Percent Completed; PercentComplete = 41; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 45 Percent Completed; PercentComplete = 45; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 47 Percent Completed; PercentComplete = 47; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 50 Percent Completed; PercentComplete = 50; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 38 Percent Completed; PercentComplete = 38; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 40 Percent Completed; PercentComplete = 40; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 56 Percent Completed; PercentComplete = 56; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 58 Percent Completed; PercentComplete = 58; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 46 Percent Completed; PercentComplete = 46; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 62 Percent Completed; PercentComplete = 62; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 64 Percent Completed; PercentComplete = 64; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 57 Percent Completed; PercentComplete = 57; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 68 Percent Completed; PercentComplete = 68; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 70 Percent Completed; PercentComplete = 70; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 63 Percent Completed; PercentComplete = 63; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 72 Percent Completed; PercentComplete = 72; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 69 Percent Completed; PercentComplete = 69; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 76 Percent Completed; PercentComplete = 76; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 71 Percent Completed; PercentComplete = 71; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 78 Percent Completed; PercentComplete = 78; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 77 Percent Completed; PercentComplete = 77; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 82 Percent Completed; PercentComplete = 82; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 84 Percent Completed; PercentComplete = 84; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 86 Percent Completed; PercentComplete = 86; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 83 Percent Completed; PercentComplete = 83; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 85 Percent Completed; PercentComplete = 85; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 90 Percent Completed; PercentComplete = 90; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 92 Percent Completed; PercentComplete = 92; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 91 Percent Completed; PercentComplete = 91; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 96 Percent Completed; PercentComplete = 96; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 97 Percent Completed; PercentComplete = 97; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 98 Percent Completed; PercentComplete = 98; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Tables : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Views; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Views : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Stored Procedures; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Stored Procedures : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User Defined Functions; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting User Defined Functions : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting Triggers : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Scripting completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Beginning Transfer of Data; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Beginning Transfer of Data : 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLWORK]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLWORK]') : 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 0 Percent Completed; PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLYRPD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CLYRPD]') : 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 1 Percent Completed; PercentComplete = 1; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CMPANY]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CMPANY]') : 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CURCNV]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CURCNV]') : 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 2 Percent Completed; PercentComplete = 2; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSADS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSADS]') : 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 3 Percent Completed; PercentComplete = 3; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCLS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCLS]') : 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCNT]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSCNT]') : 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 4 Percent Completed; PercentComplete = 4; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[CUSMST]') : 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 5 Percent Completed; PercentComplete = 5; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0101]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0101]') : 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0311]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[F0311]') : 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 6 Percent Completed; PercentComplete = 6; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP05]') : 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 7 Percent Completed; PercentComplete = 7; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP50]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDP50]') : 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDS35]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FDS35]') : 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 8 Percent Completed; PercentComplete = 8; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOBCOD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOBCOD]') : 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 9 Percent Completed; PercentComplete = 9; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR02]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR02]') : 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR08]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR08]') : 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 10 Percent Completed; PercentComplete = 10; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR09]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR09]') : 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 11 Percent Completed; PercentComplete = 11; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR10]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FOR10]') : 36 Percent Completed; PercentComplete = 36; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR05]') : 38 Percent Completed; PercentComplete = 38; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 12 Percent Completed; PercentComplete = 12; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR106]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR106]') : 40 Percent Completed; PercentComplete = 40; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 13 Percent Completed; PercentComplete = 13; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR46]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR46]') : 42 Percent Completed; PercentComplete = 42; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR56]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR56]') : 44 Percent Completed; PercentComplete = 44; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 14 Percent Completed; PercentComplete = 14; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR57]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR57]') : 46 Percent Completed; PercentComplete = 46; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 15 Percent Completed; PercentComplete = 15; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR63]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FPR63]') : 48 Percent Completed; PercentComplete = 48; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 16 Percent Completed; PercentComplete = 16; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRA01]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRA01]') : 51 Percent Completed; PercentComplete = 51; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 17 Percent Completed; PercentComplete = 17; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRM10]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FRM10]') : 53 Percent Completed; PercentComplete = 53; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA05]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA05]') : 55 Percent Completed; PercentComplete = 55; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 18 Percent Completed; PercentComplete = 18; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA06]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA06]') : 57 Percent Completed; PercentComplete = 57; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 19 Percent Completed; PercentComplete = 19; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA32]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[FSA32]') : 59 Percent Completed; PercentComplete = 59; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVDET]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVDET]') : 61 Percent Completed; PercentComplete = 61; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 20 Percent Completed; PercentComplete = 20; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVHDR]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVHDR]') : 63 Percent Completed; PercentComplete = 63; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 21 Percent Completed; PercentComplete = 21; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[INVMST]') : 65 Percent Completed; PercentComplete = 65; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[LSTKEYV99]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[LSTKEYV99]') : 67 Percent Completed; PercentComplete = 67; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 22 Percent Completed; PercentComplete = 22; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[MRKPRD]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[MRKPRD]') : 69 Percent Completed; PercentComplete = 69; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 23 Percent Completed; PercentComplete = 23; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[NOTES]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[NOTES]') : 71 Percent Completed; PercentComplete = 71; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDDET]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDDET]') : 73 Percent Completed; PercentComplete = 73; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 24 Percent Completed; PercentComplete = 24; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[ORDMST]') : 75 Percent Completed; PercentComplete = 75; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 25 Percent Completed; PercentComplete = 25; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCDETV99]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCDETV99]') : 77 Percent Completed; PercentComplete = 77; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCSUM]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[PRCSUM]') : 79 Percent Completed; PercentComplete = 79; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 26 Percent Completed; PercentComplete = 26; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESMST]') : 81 Percent Completed; PercentComplete = 81; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 27 Percent Completed; PercentComplete = 27; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESUBC]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[RESUBC]') : 83 Percent Completed; PercentComplete = 83; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SHPHST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SHPHST]') : 85 Percent Completed; PercentComplete = 85; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 28 Percent Completed; PercentComplete = 28; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSGRP]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSGRP]') : 87 Percent Completed; PercentComplete = 87; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 29 Percent Completed; PercentComplete = 29; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSREP]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SLSREP]') : 89 Percent Completed; PercentComplete = 89; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SYSWHS]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[SYSWHS]') : 91 Percent Completed; PercentComplete = 91; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 30 Percent Completed; PercentComplete = 30; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TALFLI]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TALFLI]') : 93 Percent Completed; PercentComplete = 93; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 31 Percent Completed; PercentComplete = 31; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TERMST]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[TERMST]') : 95 Percent Completed; PercentComplete = 95; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[UMCONV]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[UMCONV]') : 97 Percent Completed; PercentComplete = 97; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 32 Percent Completed; PercentComplete = 32; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[WHREGN]'); PercentComplete = 0; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; Transferring Data: (Table '[dbo].[WHREGN]') : 100 Percent Completed; PercentComplete = 100; ProgressCount = 0
DTSRun OnProgress: DTSStep_DTSTransferObjectsTask_1; 34 Percent Completed; PercentComplete = 34; ProgressCount = 0
DTSRun OnError: DTSStep_DTSTransferObjectsTask_1, Error = -2147199225 (80045707)
Error string: [SQL-DMO]The Bulk Copy execution failed.
Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1131
Error Detail Records:
Error: 0 (0); Provider Error: 0 (0)
Error string: [SQL-DMO]The Bulk Copy execution failed.
Error source: Microsoft SQL-DMO
Help file: SQLDMO80.hlp
Help context: 1131
DTSRun OnFinish: DTSStep_DTSTransferObjectsTask_1
DTSRun: Package execution complete.
=============================
http://www.sqlserverstudy.com
Hi all,
I am having a major issue installing SQL Server 2000 through InstallShield using the three merge modules sent with it (and available on the SQL Server CD) Being:
SQLBASE
SQLSVR
SQLSVR_RES
The install builds fine and runs right upto the end of the copying, where it pauses for a few seconds and comes back with a dialog saying
Product: SQL Object Installer -- Setup failed to configure the server. Refer to the server error logs and setup error logs for more information.
SQL Object Installer being the package I created
So I do this, only to find the following error log:
2004-01-08 09:58:40.65 server Microsoft SQL Server 2000 - 8.00.534 (Intel X86)
Nov 19 2001 13:23:50
Copyright (c) 1988-2000 Microsoft Corporation
Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 2)
2004-01-08 09:58:40.67 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-08 09:58:40.67 server All rights reserved.
2004-01-08 09:58:40.67 server Server Process ID is 1588.
2004-01-08 09:58:40.67 server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQLLOGERRORLOG'.
2004-01-08 09:58:40.68 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-08 09:58:40.76 server SQL Server configured for thread mode processing.
2004-01-08 09:58:40.78 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2004-01-08 09:58:40.98 spid3 Warning ******************
2004-01-08 09:58:40.98 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-01-08 09:58:41.01 spid3 Starting up database 'master'.
2004-01-08 09:58:41.54 server Using 'SSNETLIB.DLL' version '8.0.534'.
2004-01-08 09:58:41.54 spid5 Starting up database 'model'.
2004-01-08 09:58:41.59 spid3 Server name is 'GROUPNETVISTA2'.
2004-01-08 09:58:41.59 spid3 Skipping startup of clean database id 5
2004-01-08 09:58:41.60 spid3 Skipping startup of clean database id 6
2004-01-08 09:58:41.60 spid3 Starting up database 'msdb'.
2004-01-08 09:58:41.84 spid5 Clearing tempdb database.
2004-01-08 09:58:42.10 server SQL server listening on 10.171.1.205: 1433.
2004-01-08 09:58:42.10 server SQL server listening on 127.0.0.1: 1433.
2004-01-08 09:58:42.60 spid5 Starting up database 'tempdb'.
2004-01-08 09:58:42.73 spid3 Recovery complete.
2004-01-08 09:58:42.73 spid3 SQL global counter collection task is created.
2004-01-08 09:58:42.74 spid3 Warning: override, autoexec procedures skipped.
2004-01-08 09:58:47.17 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-08 09:58:47.17 server SQL Server is ready for client connections
2004-01-08 09:58:56.67 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
I am stumped, I am not really the greatest with SQL Server so I don't really know where to start, the SCM line at the bottom of the errorlog doesn't tell me much as I can't see what would be sending the 'stop' request?
Could this be a permissions thing. I have set myself as the administrator on the machine and do have quite a few rights. The machine does not already have SQL Server on it as it is a fresh image of Windows 2000 (also tried on XP wth same result)
Any help on this would be most appreciated as all around me are stumped too.
Thanks in advance.
Mark.
I created a single step plan that does integrity checks. It fails with the error below. I created a new connection using our clusters virtual sql name.
Executed as user: ACCTCOMsqlagent. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:10:06 PM Error: 2008-02-15 13:10:49.02 Code: 0xC00291EC Source: {0CF32F3D-A8D1-492A-9C0F-AD4E0FC67D14} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-02-15 13:10:49.02 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2008-02-15 13:11:31.26 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.
The agent and db are running under domain accounts and the job is owned by sa.
Thanks for your help.
Hi,
i am getting this exception i.e."
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect" whenever i try to connect to the remote DB which is present at a different system.