Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







SQL Server Service Startup Error


Hi,

We get the following message when we try to start up SQL 65 thru. the control panel / services.

Error Message

Runtme Error:Program d:devstudioshareddeinmsdev.exe abnormal program termination. MS visual c++ runtime library.

Any help will be appreciated.

Regards
Vedanth


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
SQL Executive - Service Startup Account Error
Hello all,

I just inherited a SQL Server that was set up by a non-DBA. It`s running NT 4.0 and SQL Server 6.50 - 6.50.201 (the vendor hasn`t certified the product on SP4). I am trying to change the SQL Executive Service to use a non-system logon account. The account that I want to use is running SQL Executive on 9 other servers.

I went into Usrmgr and added the account to the administrators group. Made sure that it has rights to:
log on as a service, log on as a batch job, increase quotas, act as part of the operating system, replace a process level token.

When I try to change to that id in services, I get the following error:

"cannot set the startup parameters for SQL Executive service. Error 1057 occurred. The account name is invalid or does not exist."

Looking in Technet, I found that if "log on as a service" isn`t set you could get this message but I`ve check/re-checked, had someone else check and it`s set.

Any help would be appreciated!

View Replies !   View Related
Service Startup Failed On SQL Logon, Error: 18456, Severity: 14, State: 16
Hi, I have a service using SQL 2005 Express database, the service is started automatically on system startup, most of the times it can logon to the database successfully, however, sometimes, I got the following error:

"Error: 18456, Severity: 14, State: 16"

Any suggestions?

Thanks in advance!

Yuxi

2006-11-22 11:09:49.90 Server      Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
 Apr 14 2006 01:12:25
 Copyright (c) 1988-2005 Microsoft Corporation
 Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

2006-11-22 11:09:49.92 Server      (c) 2005 Microsoft Corporation.
2006-11-22 11:09:49.92 Server      All rights reserved.
2006-11-22 11:09:49.93 Server      Server process ID is 1956.
2006-11-22 11:09:49.93 Server      Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2006-11-22 11:09:49.93 Server      This instance of SQL Server last reported using a process ID of 1952 at 11/22/2006 11:08:07 AM (local) 11/22/2006 7:08:07 PM (UTC). This is an informational message only; no user action is required.
2006-11-22 11:09:49.95 Server      Registry startup parameters:
2006-11-22 11:09:49.95 Server        -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2006-11-22 11:09:49.95 Server        -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2006-11-22 11:09:49.95 Server        -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2006-11-22 11:09:49.98 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-11-22 11:09:50.00 Server      Detected 4 CPUs. This is an informational message; no user action is required.
2006-11-22 11:09:50.95 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2006-11-22 11:09:50.96 Server      Database mirroring has been enabled on this instance of SQL Server.
2006-11-22 11:09:50.96 spid4s      Starting up database 'master'.
2006-11-22 11:09:51.06 spid4s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-11-22 11:09:51.18 spid4s      SQL Trace ID 1 was started by login "sa".
2006-11-22 11:09:51.23 spid4s      Starting up database 'mssqlsystemresource'.
2006-11-22 11:09:51.25 spid4s      The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2006-11-22 11:09:51.59 spid8s      Starting up database 'model'.
2006-11-22 11:09:51.60 spid4s      Server name is 'TestMachineTestSQLServer'. This is an informational message only. No user action is required.
2006-11-22 11:09:51.60 spid4s      Starting up database 'msdb'.
2006-11-22 11:09:51.93 Server      A self-generated certificate was successfully loaded for encryption.
2006-11-22 11:09:51.93 Server      Server local connection provider is ready to accept connection on [ \.pipeSQLLocalTestSQLServer ].
2006-11-22 11:09:51.93 Server      Server local connection provider is ready to accept connection on [ \.pipeMSSQL$TestSQLServersqlquery ].
2006-11-22 11:09:51.93 Server      Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2006-11-22 11:09:51.95 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-11-22 11:09:52.12 spid8s      Clearing tempdb database.
2006-11-22 11:09:53.12 spid8s      Starting up database 'tempdb'.
2006-11-22 11:09:53.21 Logon       Error: 18456, Severity: 14, State: 16.
2006-11-22 11:09:53.21 Logon       Login failed for user 'sa'. [CLIENT: <local machine>]
2006-11-22 11:09:53.70 spid4s      Recovery is complete. This is an informational message only. No user action is required.
2006-11-22 11:09:53.70 spid11s     The Service Broker protocol transport is disabled or not configured.
2006-11-22 11:09:53.70 spid11s     The Database Mirroring protocol transport is disabled or not configured.
2006-11-22 11:09:54.09 spid11s     Service Broker manager has started.
2006-11-22 11:10:19.26 spid51      Starting up database 'TestDatabase'.
2006-11-22 11:10:19.42 spid51      Recovery is writing a checkpoint in database 'TestDatabase' (5). This is an informational message only. No user action is required.
2006-11-22 11:18:08.92 spid51      Starting up database 'TestDatabase'.

View Replies !   View Related
As The System Required, Is There Any Method To Enable Service Broker When SQL Server Startup?
 As the system required, Is there any method to enable service broker when SQL Server Startup?

View Replies !   View Related
Server Startup / 100 % Cpu Utilization While Recovering Database @ Startup
database : MS SQL server ver 6.50.201
problem: server startup / server time out
details
SQL server shows usage of 100 % CPU utilization, if started automatically / manually. and does not proceed / hangs up(server time out), but win nt operates extremely slow.

The background of the situation in brief is as stated below.
The errorlog was found to have the messages
warning : OPEN OBJECTS parameter may be too low.
Attempt was made to free up descriptors in localdes()
Run sp_configure to increase parameter value.

Error : 644, severity : 21, state; state 1
the non clustered leaf row entry for page 2 row 1 was not found in index page 40 indexid 2 database 'tempdb'

Error : 2620 severity 21 state 3
the offset of the row number at offset 32 does not match the entry in the offset table of the follwoing page : page pointer = 0x1395800, page no= 40, status = 0x2, objectid = 1, indexid = 2

Action taken
I used the sp_option to increase the open objects from default 500 to 1000, and the LE threshold maximum value to 400 from the default 200.
after which I used reconfigure go and restarted the computer to take the effect. The following did work fine and server was working ok. But then from yesterday I am having the problem that the MS SQL sever is utilizing the cpu to 98 - 99 % and I am not able to connect to the server.
I tried to start the server with the minimal configuration by specifying the -f option in the service manager start up options, it showed the following message
00/12/07 10:40:49.73 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.
00/12/07 10:40:50.02 ods Unable to connect. The maximum number of '5' configured user connections are already connected. System Administrator can configure to a higher value with sp_configure.

afterwhich I tried with the option of starting the sql server with the option -c -f
which in the event detail of the win nt shows
"mesg 18109: Recovery dbid 6 ckpt(55813,8) oldest tras= (55813,0)"

The open procedure for service "MSSQLServer" in DLL "SQLCTR60.DLL" has taken longer than the established wait time to complete. The wait time in milliseconds is shown in the data.
DB-LIBRARY error - SQL Server connection timed out.

and in the errorlog present in MSSQLLOG directory

00/12/07 15:06:43.24 spid1 Recovering Database 'master'
00/12/07 15:06:43.31 spid1 Recovery dbid 1 ckpt (7944,28) oldest tran=(7944,0)
00/12/07 15:06:43.41 spid1 1 transactions rolled forward
00/12/07 15:06:43.49 spid1 Activating disk 'AM'
00/12/07 15:06:43.49 kernel initializing virtual device 1, D:MSSQLDATAAM.DAT
00/12/07 15:06:43.50 spid1 Activating disk 'AMLOG'
00/12/07 15:06:43.50 kernel initializing virtual device 2, D:MSSQLDATAAMLOG.DAT



The dbid is / was 6 for both the instances, the database which is having this dbid is database name "AM" and is having above 1300 tables (approx)
what could be the problem and solution for it?
kindly help me out of this situation.

If any more information is needed please contact me on devendrakulkarni@yahoo.com / devendra@me.iitb.ernet.in

Regards
Devendra

View Replies !   View Related
SQL Server 2005 Startup Error - TDSSNIClient... Error 0x5... Code 0x51
Hi,My SQL Server 2005 won't start - can anyone provide some help? Thisseems to be the most significant error:- TDSSNIClient initialization failed with error 0x5, status code 0x51.There was some info here, but the reg key described looks okay:- http://blogs.msdn.com/sql_protocols/I am running SQL Server 2005 64-bit Standard Edition. The server inquestion is the first node of an Active/Active Cluster. This firststarted happening while I was trying to add a share as a clusteredresource of the other node (not to this node's resources).I have not yet reinstalled SQL Server 2005 because I am hoping for moreexplanation of the problem and a possible fix.Thanks,Tom

View Replies !   View Related
Alert On Service Startup
Hi,

I am trying to set up a `dbcc check` function that will run when the service for sql sever startup (ie. after the machine is rebooted). I am trying to set up an alert to do this, however, I couldn`t found a way that can trigger this alert. (Normally, I use `error message` to trigger an alert.)

I am using SQL 6.5. Do you have any idea or suggest how can I do this?

Thanks in advance

Wallace

View Replies !   View Related
SQL Service Startup Failed
 

Hi
 
I think my question will be dificult to resolv but i must try.
 
We have a Windows SBS server 2003 with sql 2005 installed on it.
For many reason we had to install SQL 2005 before terminate the SBS2003 setup.
When i terminated the SBS2003 setup, the system asked me to restart and my problems began.
 
These SQL services refuse to start at startup and also after:
 
SQL server
SQL server Agent
SQL server Reporting
 
I have some error messages in the event viewer:
i couldn't write the exact message because it is in french
 
Error: 1004
Source: Application error
Description: faulty application Sqlservr.exe version 2005.90.1399.0 faulty module kernel32.dll version 5.2.3790.4062
fault 0x0000bee7
 
I have also the same message with the SqlWb.exe file
 
Could you help me please?
Thanks in advance
 
Jonathan
 
 
 
 

View Replies !   View Related
Error Message At SQL Server Startup
Hi

The following error is appearing in my SQL Server 7 (sp2) errorlog,

Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b

I can't find any information on this error, has anybody any ideas as to the cause/fix for this error.

thanks in advance

Gary

View Replies !   View Related
SQL Service Manager Startup Problem
Hi,

The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:

C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER

When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says that

"Unknown - \ - MSSQLServer"

Can someone please help me out.

View Replies !   View Related
SQL Service Manager Startup Problem
Hi,

The SQL Service Manager is not running automatically despite that fact the the STartup type for the following service IS set to Automatic:


C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER

When I start my PC and look at the taskbar (or is it better called the status bar), the service Manager appears with a big WHITE circle and when I get the tooltip it says:

"Unknown - \ - MSSQLServer"

Can someone please help me out.

View Replies !   View Related
Startup Service Account Greyed Out - Why
I would like to enter info into the startup service account so that the MS
SQL Server Agent will run under this account. Then I can run jobs.

However, I don't know why the "startup service account" info is
greyed out, which prevents me from entering this information.

Any help would be appreciated!!

View Replies !   View Related
Validation Of SSIS Service Upon Startup
In the SP1 update of SSIS there was a call from the SSIS service that would attempt to validate itself against the http://crl.microsoft.com web site.  If the SSIS service didn't have access to the internet then it would timeout and not start the service.  In our company we have our development systems behind a firewall which only allows for limited internet access due to it being a development system.

Does the installation of SP2 remove this authentication restriction?

...cordell...

 

Problem Description Reference Documents:

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

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124887.

View Replies !   View Related
Sql Server 6.5 Fails On Startup, Error 909 Too Many Fragments
SQL Server databases are limited to 32 device segments. SQL Server should
prevent the database from expanding beyond 32 device segments. However, in some
cases, an entry is added to the sysusages system table before an error is
returned.

If this happens, when SQL Server is restarted, the database will fail recovery
with the following error:

Error: 909, Severity: 21, State: 1 More than 32 entries required to
build the logical-virtual translation table for database 'xxx'. The
database is too fragmented.

However, in some cases, this procedure will not consolidate segments. For
example, if you have 32 segments on 32 individual data devices, then
sp_coalesce_fragments cannot consolidate any sysusages mappings.

Any other fixes?

View Replies !   View Related
What Will Happen If I Change Startup Service Account?
Hello, everyone:

I want to change Startup Service Account of an instance on SQL Server 2000 from System Account to a Domain Account from Enterprise Manager. What impact maybe bring up on database and frond end?

Thanks

ZYT

View Replies !   View Related
Service Startup User Accounts On A Cluster
i have a sql cluster setup, and need to change the user account that sqlserver starts with....any ideas? i screwed up and left it using localsystem account and now i can`t get sqlmail to work. i`m trying to avoid having to create the cluster again. any info appreciated.......jim jones

View Replies !   View Related
SQL Server Management Studio Express Startup Error
When launching Microsfot SQL Server Management Studio Express, I get a Popup Error box (!) without any text. After pressing the OK button, everything seems to work fine.  Any ideas as to what it's trying to tell me?
 
 
 

View Replies !   View Related
Database 4 Cannot Be Autostarted During Server Shutdown Or Startup. (Microsoft SQL Server, Error: 904)
Hi,

I'm from Argentina, I'm running SQL Server 2005 Express. I can connect to SQL Server via Management Studio and see all my db but I don't have acces to them !!

The system gives me the following error when trying to expand all folders:

Database 4 cannot be autostarted during server shutdown or startup. (Microsoft SQL Server, Error: 904)

Any ideas??

Thanks from Argentina

View Replies !   View Related
Active Directory Helper Service Aborting Upon Startup
 

On a fairly new install of SQL 2005 64-bit, upon bootup the Active Directory Helper Serivice is aborting with the error 3221225572 (0XC0000064).  When an attempt is made to start the service manually the following error appears: "Windows could not start teh SQL Server Active Directory Helper on Local Computer.  For more infromation, review the System Event Log.  If this is a non-Microsoft service, contact the service vendor, and refer to the service-specific error code - 1073741724."
 
The service is strating up under the network services account, which I am suspicous may be a problem.  Currently the SQL server is running under SQL 2005 SP2 with no post service pack hotfixes.  Do you have any advice on how to get the service to launch without errors?

View Replies !   View Related
SQL Service Management Studio Express (x64) Crashing On Startup
hopefully, the subject addresses my problem.  the server is running like a charm.

Service pack 2 has been installed.  The only connection I remember creating after the initial installation is a remote connection.

I've checked to make sure I am allowing multiple protocols.

I am not able to get a response from the following:


C:Usersamfrizzell>SQLCmd -S .aaron-toshiba -E -Q "SELECT @@Version"
HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
 allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.

The instance is running as I can connect to it through Visual Studio 2005.

What did I do wrong?  I could really use this application in order for me to develop websites.  It's sort of a pain to go to another computer to use the more powerful features of SQL Server 2005 Server management Studio (standard edition).

Help me...  somebody please help me.

Thanks.

Aaron

View Replies !   View Related
The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.
I have an almost virgin install of SQLExpres running on a WIN2K Pro system.

Have been able to create and connect db to Access 2000 without problem.

 

Now I wish to extend to remote connections.  Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote.

Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors:

 

System Log:

 

The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013.

 

Application Log:

 

Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use.

 

TDSSNIClient initialization failed with error 0x271d, status code 0xa.

 

TDSSNIClient initialization failed with error 0x271d, status code 0x1.

 

Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

 

SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

 

 

If I change back to Local Connections Only   or  Local and Remote using named pipes only,  the service starts up again without a problem.

 

After five days of investigating, researching, reinstalling and waiting I have to ask for help. 

 

Any suggestions or leads?

 

Thank You in advance.

View Replies !   View Related
I Had Set My Windows Service's Startup Type As Automatic But It Is Not Starting Up Automatically When The System Is Starting.
Hello,

 

I had created a windows service using C#. I set its Startup Type as Automatic but it is not getting started automatically when my System Starts.

View Replies !   View Related
DTS Fails As A Job With Service Startup Account As &#34;System Account&#34;
I have several DTS jobs that runs well as a job with my nt login account for the SQL agent service startup account, but if I use the System account
they fail with this error.
" Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider"

The data has change access to the System account under the NT security.

Thank you in advanced.

Jorge

View Replies !   View Related
Enterprise Manager Error At Startup! Help!
Hey guys,
everytime I try to launch enterprise manager I keep getting this message prompt. How do I fix this? Everything else seems to open fine..query analyzer..etc..
Runtime Error!

Program:C:winntsystem32mmc.exe

R6025
-pure virtual function call

View Replies !   View Related
SQL Startup Produces Resource Manager Error
We have two instances of SQL Server 2005 - SP1 installed on one server. The default instance starts very slowly. When looking at the log I can see the delay is due to Resource Manager based upon the following error.

Message
Resource Manager Creation Failed: 0x8004d102(XACT_E_DUPLICATE_GUID)

What does this mean?

What would cause this to happen?

How do I resolve the problem?

Thanks, Dave

View Replies !   View Related
SQL Express Errors: Diagram Component, Startup Error
Problem 1: Upon starting SQL Server Express I get the following error:

"An unhandled exception has occurred in a component in your application....Cannot create a stable subkey under a volatile parent." Clicking OK lets the Server continue and I can use it quasi-normally.

Problem 2: Also, when I try to generate a diagram, I get a message that states

"Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."

But, the database HAS an owner, and resetting the owner (using the Files...) to other users has no effect.

Problem 3: I tried to change the name of a database, and it refused to do so. Except that now all objects under the database name (it is the same old name) have disappeared. Is there a magic folder somewhere that contains all of the tables, etc. that were 'banished' from the server?

Is there a way to detach the databases from Express and reattach them to the SQL Server 2000 I am also running? Last time I tried the 'detach' worked but all the objects were wiped out by the 'attach'. Handy feature.

Thanks

Glen

View Replies !   View Related
SQL Server Startup Procedures
Hello,

I've 10 Production Servers, which is rebooted every month by NT guys, The MS SQL Server Services & MS SQL Agent starts automatically when the Windows 2000 Advanced Server starts, I would like to create that when the MS SQL Server starts it pages me that Services started successfully, or the other way is to see the Windows Event viewer error logs to see if there is any SQL Server errors at NT server startup so that it would page me Problem starting MS SQL Server.

Would anyone please help me with this
Is there any startup procedure I could generate every time MS SQL Server is started.
How could I scan NT error logs to see the error logs for MS SQL Server and send the page.

Thanks

Roma

View Replies !   View Related
SQL Server Startup Procedures
Hello,

I've 10 Production Servers, which is rebooted every month by NT guys, The MS SQL Server Services & MS SQL Agent starts automatically when the Windows 2000 Advanced Server starts, I would like to create that when the MS SQL Server starts it pages me that Services started successfully, or the other way is to see the Windows Event viewer error logs to see if there is any SQL Server errors at NT server startup so that it would page me Problem starting MS SQL Server.

Would anyone please help me with this
Is there any startup procedure I could generate every time MS SQL Server is started.
How could I scan NT error logs to see the error logs for MS SQL Server and send the page.

Thanks

Roma

View Replies !   View Related
SQL Server Startup Issue
Hi,
 
I am getting issue while Starting SQL Service.
Error started since I rebooted the server without stopping SQL Services.
 
Below Errors Observed.
 

1.  Server named pipe provider failed to listen on [ sqlquery ]. Error: 0x57

 
2.  TDSSNIClient initialization failed with error 0x57, status code 0x50.

 
3.  TDSSNIClient initialization failed with error 0x57, status code 0x1.

 
4.  Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.

 
5.  SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

 
 
Kindly Suggest.

View Replies !   View Related
Sql Server Takes Too Long To Startup
My sql freezes my machine every now and then as if its processing something in the background. From task manager it starts from 3864K on Mem usage and goes up to 363 632K. How can l fix that? And when l switch on my machine the sql server takes o long time to start whats the problem l'm running sql2000 on xp professional. l've got an Intel Pentium III processor,846MGz and 512mb.

View Replies !   View Related
Sql Server Timeout During System Startup
the system i'm running is a windows 2003 sp2 r2 dc with sql server 2005 sp2 installed

i get the follow error in the event id logs regarding a few of the sql server nt services

Timeout (30000 milliseconds) waiting for the SQL Server (MSSQLSERVER) service to connect

i already tried to set the registry values for ServicesPipeTimeout to 60000 thinking this should solve the problem...

however the event id errors still persist and say that 30000 is the timeout value...

how can i make it so that the start time is either delayed or the timeout value is increased?

currently my only workaround is to manually restart the services

View Replies !   View Related
SQL Server Takes So Much Time To Startup
Hi,

I have SQL Server 2005 Standard edition with SP1. Whenever I start the Management Studio, it takes for ever to come up. It will take atleast 30 Sec to 1 min every time I start SQL Server. Is this some thing we have to live with in SQL Server 2005 or do I need to tweak any thing? Pls let me know.

One more thing, in the SQL Server logs I see the following message every day -> Source - spid36s, Message - Starting up database 'dbname'. Why do I get this message?

Thanks

View Replies !   View Related
SQL Server 2005 - Change Startup Parameters
Hi,
 
I installed SQL Server 2005 Enterprise Edition and then executed SP2. So, when I try to move master database to another place, I don't obtain to change the Startup Parameters, because the instance SQL Server (MSSQLSERVER) in SQL Server 2005 Services in the SQL Server Configuration Manager isn't shown. I observed that if not execute the SP2 the instance SQL Server (MSSQLSERVER) is shown.
What it can is happening ?
Somebody knows some thing on this?
 
Please, somebody could help me ?
 

Thanks,
 
Antonio

View Replies !   View Related
An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...
Hi All,
 
We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two.
 
Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password.
 
We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong.
 
Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks!
 
Error:

An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service.
 
 
Regards,
Joseph

View Replies !   View Related
How To Customize View Of SQL Server Enterprise Manager On Startup?
Hi,I've managed to get a couple of shortcuts on my desktop that log meright into SQL Query Analyzer for whichever particular database I want(using the isql.exe command line options). Now, I want to do a similarcustomization for the SQL Server Enterprise Manager. I want to be ableto open SQL Server Enterprise Manager and have it pop me all the waydown into my particular database/tables view -> e.g. "Microsoft SQLServersSQL Server Group(LOCAL) (WindowsNT)DatabasesmyDatabaseName". I'm hitting a local db server...I've tried saving new consoles (.msc files), but that just doesn't seemto do anything. I've tried using bookmarks, also, and they just don'tdo anything at all when I select them.Any ideas??

View Replies !   View Related
Slow Startup Of SSIS Package If Started Using A SQL Server Job
Hello all,
 
We have noticed in our environment slowness when starting SSIS packages from SQL Server jobs. I did a quite detailed study on when the slowness actually occurs and what are the consequences. Here are the results.
 
The SSIS package execution is slow if all the following is true:

The package is started from a job. If started directly as a SSIS package, the execution is fast.
The job is running on a 64 bit Windows Server (SQL Server 2005 SP2). The SSIS package and the job are either on the same server or on different servers (the second server is SQL Server 2005 SP1). If the job is run on a 32-bit workstation (Windows XP SP2) the execution is fast (the SSIS package still being on the server).
The package contains tasks.
§         If there are no tasks, just an empty sequence container, the execution is fast.
§         If a package that has no tasks has logging into the database configured, the execution is fast.
§         Slowness has been verified with A) a package having a single Execute SQL statement and B) a package having a Send Mail task.

It doesn't seem to matter which user account is used on when running the job.
 
The slowness happens in several locations, e.g. (there are also others, at least the following have been verified)

There is exactly 30 seconds lag between starting the job (as seen from job history) and when PreValidate (as seen in the sysdtslog90 table) of the package appears in the log.
The validation of the package takes 15 seconds (the time difference in the log betwen PreValidate and PackageStart)
The problem is really affecting our production environment. Currently the only solution we have come up is to put all the jobs on a workstation and use the workstation as a production server for the jobs.
 
I haven't heard anyone else having the same problem.

View Replies !   View Related
Detect That SQL Server 2005 Is Checking A Specific Database On Its Startup
Hello,
 
is there a way to find out that SQL Server 2005 (Express) engine is performing startup checked of a selected database?
 
The problem we are faced to is that our users shutdown brutally their laptops running their database. When they start laptops again, they impatiently start the application that tries to connect to the database. However, they get an error message:
 
Cannot open database XXXXX requested by the login. The login failed. 
 
When they try after a minute or two, it works.
 
What we would like to do is provide an information message that the SQL server is checking the database and that they must wait for a while. Is there is a specific error code for this, can anyone help? We are using .NET 2.0.
 
Thank you,
Jan

View Replies !   View Related
Error Code 3417. Cannot Start Sql Server Service
Hi Guys

I have my Sql server 2005 running perfectly (until yesterday) on vista. But today when I tried to connect to the server I get error 3417 meaning my master database needs rebuilt or repaired.

I tried all sort of techniques I found on internet like checking if my data files in data dir are not compressed and for the SQL Server Servies it logs on local account with interact with desktop checkbox checked. But no luck.

I tried to use setup.exe in my installer CD to rebuild master database but it seems the cmd doing nothing. To rebuild, I use the following command “start /wait setup.exe /qn INSTANCENAME=<instance> REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=<New SA Password>�. This cmd runs but due to some reason my master db is not being repaired. Ideally, I should see recent date change for this file.

Please advice how can I connect back to my server again making sure my databases are not lost.

View Replies !   View Related
Server Error(Login Failed For User 'NT AUTHORITYLOCAL SERVICE'.)
Hi,
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'NT AUTHORITYLOCAL SERVICE'.
my applicaton working on other machine perfect with the same code but when i upload on web server showing me above error.

Thanks with best regards,

View Replies !   View Related
Error: SQL Server Failed To Communicate With Full-Text Service
Hello,
I've enabled full-text indexing on one of my tables, and the following query used to work:
SELECT *
FROM TempAttachment
WHERE CONTAINS(attachment, 'text')


However, now I get the following error:
Msg 9955, Level 16, State 1, Line 1
SQL server failed to communicate with Full-Text Service (msftesql). The system administrator must make sure that same service account is used for both services and the service account has the permission to auto start the full-text service.


I've checked the configuration and verified that both accounts are the same. I've restarted the services, and tried rebooting, and still no luck. I did a search on this error, and found this page from MSDN, which doesn't help me much: http://msdn2.microsoft.com/en-us/library/aa337365.aspx.

Has anybody come across this before? Any help would be greatly appreciated!

View Replies !   View Related
SQL Server Service Manger Fails To Start With Error Message
We have changed the Network Domain name of a SQL server and restarted before changing any of the settings in SQL server. When we now try to start the SQL server service manager we get the following error

Your SQL server is either corrupt or has been tampered with. Unknown package id please rerun setup

Any suggestions on how to get the SQL server back on line without having to take the server down and changing the Netowrk Domain Name back ??

Cheers

SR

View Replies !   View Related
Error 1053: Could Not Start The SQL Server Integration Services Service
 

We encountered an error the other day that was causing us major head-aches trying to resolve.

 

Error: 1053 -- Could not start the SQL Server Integration Services service

 

In addition to SSIS not starting up, we had errors trying to launch Management Studio.

 

The above errors started happening after we deployed a small release that included editing the machine.config file.

 

 

To make a long story short, make sure the machine.config file is well formatted and is not missing any double quotes (") or < /> .

 

 

Hopefully this information can help someone out.

 

 

 

 

 

 

 

 
 

View Replies !   View Related
Error Number : 29503 The SQL Server Service Failed To Start.
Is there a trick to getting this installed correctly?  Everything works great until it gets up to starting the service.  Here is the complete section of my setup log file.

SQL 2005 Standard.

Machine         : KINGSERVER550
Product         : SQL Server Database Services
Error           : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--------------------------------------------------------------------------------
Machine         : KINGSERVER550
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0003_KINGSERVER550_SQL.log
Last Action     : InstallFinalize
Error String    : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is  (1067) The process terminated unexpectedly.
Error Number    : 29503

 

I searched a previous thread dealing with this error, but seems like nobody has found a solution.

--Tony

View Replies !   View Related
SQL Server 9 - Vista 64 - Error Message In Event Viewer - Interactive Service
"(MSSQLSERVER) service is marked as an interactive service. However,the system is configured to not allow interactive services"This problems may solve a recurring failure in my automatic updates ifI can figure out what to do with it.Any Suggestions welcome -CheersRay

View Replies !   View Related
SQL Server 2005 Integration Service Script Task Debug Error
While trying to debug a SSIS script task in SSIS package its giving me error "SQL Server Integration Services Script Task has encountered a problem and needs to close.  We are sorry for the inconvenience."

Any idea about this.

Thanks

View Replies !   View Related
Getting Foolowing Error While Installing Sql Server 2000 Reporting Service Setup
Dear All,
I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End  upgraded with service pack 3 and analysis service.
Now I am trying to install sql server 2000 report services. But I run SQL2KRSSP1-ENG.EXE setup
Then following error occurs
The upgrade patch can not be installed by window installer because the program to be upgraded may be missing , or the upgrade patch may update a different version of the program Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.
I redownload the same exe to other location. And again run but getting same error
Please Guide me or atleast give some help full link.
thanks 

View Replies !   View Related
Error Updating HTTPFilter Service Security During SQL Server Express Install
Hello, I'm installing MOSS 2007 as stand alone which includes SQL Server 2005 Express edition.  My install is failing during the DB install.  The server is Windows Server 2003, Enterprise Edition SP 2.

The error I'm receiving states "Setup has encountered an unexpected error while updating security settings on HTTP Services". 

Here are snippets including the "return value 3" found in the log "SQLSetup0001_COHNTFS15_SQL.log". 

Snippet 1:
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008
MSI (s) (D8:EC) [08:36:14:535]: Executing op: ActionStart(Name=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting SQL Server Authentication Mode,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:535]: Executing op: CustomActionSchedule(Action=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_PropSetLoginModeNT,CustomActionData=010Setting SQL Server Authentication Mode50000MSSQL.1)
MSI (s) (D8:40) [08:36:14:535]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI538.tmp, Entrypoint: Do_PropSetLoginModeNT
<Func Name='LaunchFunction'>
Function=Do_PropSetLoginModeNT
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_PropSetLoginModeNT
PerfTime Start: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008
<Func Name='Do_PropSetLoginModeNT'>
Switching server to NT integrated security
<EndFunc Name='Do_PropSetLoginModeNT' Return='0' GetLastError='0'>
PerfTime Stop: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008
MSI (s) (D8:EC) [08:36:14:566]: Executing op: ActionStart(Name=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating security settings on HTTP services,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:566]: Executing op: CustomActionSchedule(Action=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_HttpServiceSecurity,CustomActionData=100Updating security settings on HTTP services100000)
MSI (s) (D84) [08:36:14:566]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI539.tmp, Entrypoint: Do_HttpServiceSecurity
<Func Name='LaunchFunction'>
Function=Do_HttpServiceSecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_HttpServiceSecurity
PerfTime Start: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008
<Func Name='Do_HttpServiceSecurity'>
Error updating HTTPFilter service security (5)


<EndFunc Name='Do_HttpServiceSecurity' Return='1603' GetLastError='0'>
PerfTime Stop: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008
Gathering darwin properties for failure handling.
Error Code: 1603
MSI (s) (D8!20) [08:36:14:785]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.


Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.

<Failure Type='Fatal' Error='1603'>
<EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'>
MSI (s) (D8:EC) [08:36:14:800]: User policy value 'DisableRollback' is 0
MSI (s) (D8:EC) [08:36:14:800]: Machine policy value 'DisableRollback' is 0
Action ended 8:36:14: InstallFinalize. Return value 3.


Snippet 2:
<Func Name='LaunchFunction'>
Function=Set_CommitFlag
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='F' GetLastError='0'>
Doing Action: Set_CommitFlag
PerfTime Start: Set_CommitFlag : Thu May 01 08:36:22 2008
<Func Name='Set_CommitFlag'>
Set_CommitFlag called successfully.Rollbacked
<EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'>
PerfTime Stop: Set_CommitFlag : Thu May 01 08:36:22 2008
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (D8:EC) [08:36:22:988]: Executing op: ActionStart(Name=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing temporary files,)
MSI (s) (D8:EC) [08:36:22:988]: Executing op: CustomActionRollback(Action=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=RollbackSupportFiles,)
MSI (s) (D8:7C) [08:36:22:988]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI54B.tmp, Entrypoint: RollbackSupportFiles
MSI (s) (D8:EC) [08:36:23:004]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0)
MSI (s) (D8:EC) [08:36:23:004]: Error in rollback skipped.    Return: 5
MSI (s) (D8:EC) [08:36:23:004]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.AdomdClient,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:004]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlTDiagM,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:035]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:035]: Entering MsiProvideAssembly. AssemblyName: MSClusterLib,Version="1.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="1.0.0.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:035]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.MgdSqlDumper,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:066]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:066]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.DeploymentEngine,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:066]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.DataWarehouse.Interfaces,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:097]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:097]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.RegSvrEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:097]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.BatchParser,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ServiceBrokerEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:129]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:129]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.WmiEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:129]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:144]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:144]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ConnectionInfo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:144]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:160]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:160]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:160]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:222]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:222]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4
MSI (s) (D8:EC) [08:36:23:222]: Pathbuf: 0, pcchPathBuf: 0
MSI (s) (D8:EC) [08:36:23:238]: MsiProvideAssembly is returning: 1607
MSI (s) (D8:EC) [08:36:23:238]: No System Restore sequence number for this installation.
MSI (s) (D8:EC) [08:36:23:238]: Unlocking Server
MSI (s) (D8:EC) [08:36:23:238]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'.
Action ended 8:36:23: INSTALL. Return value 3.

last few lines of log:
Property(S): RSVirtualDirectoryManager = Reports$OFFICESERVERS
Property(S): SOURCEDIR = d:a1847ef4f3beaf9c2353Setup
Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
Property(S): InstallNgenTicks = 110000
Property(S): SQLBROWSERACCOUNT = NT AUTHORITYNETWORK SERVICE
Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService
Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B266876E-56D9-493C-9322-0C01155F1C52}
Property(S): ProductToBeRegistered = 1
MSI (s) (D8:EC) [08:36:23:441]: Note: 1: 1708
MSI (s) (D8:EC) [08:36:23:441]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.

MSI (s) (D8:EC) [08:36:23:457]: Cleaning up uninstalled install packages, if any exist
MSI (s) (D8:EC) [08:36:23:457]: MainEngineThread is returning 1603
MSI (s) (D84) [08:36:23:566]: Destroying RemoteAPI object.
MSI (s) (D8:E0) [08:36:23:566]: Custom Action Manager thread ending.
=== Logging stopped: 5/1/2008  8:36:23 ===
MSI (c) (104) [08:36:23:597]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (104) [08:36:23:597]: MainEngineThread is returning 1603
=== Verbose logging stopped: 5/1/2008  8:36:23 ===

I'm suspecting it's a permission error, but I can't verify this.  Any thoughts?  Thanks in advance.

View Replies !   View Related
SQL Server 2005 Express - Error During Installation On Windows XP Service Pack 3
 

Hello!
 
We deploy an application that uses SQL Server Express 2005. One of our test engineers tried to use our setup on Windows XP SP 3. But the SQL server installer gave an error - unable to update msxml6r.dll. Is this a bug of the SQL Server installer or do we need to make use of a more recent version of msxml6?

View Replies !   View Related
Cannot Connect To SQL Report Server Through Web As Well As Management Studio (Http:503 Error Service Unavailable.)
hi all,
i have SQL 2205 with SP1 installed on my machine.
and i m not bale to connect to Report Server using SQL management studio as well as from web.

i have installed reporting server and database on same machine. i tried using

 "http://localhost/reportserver"
"http://localhost/reports"
"http://localhost/reportmanager"

but i am not bale to connect i am getting "Service Unavailable" page.

and when i try to connect using SQL Management Studio with "servername/instance" as well as "http://localhost/reportserver" i am getting a error saying.

===================================
Cannot connect to http://localhost/reportserver.The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

===================================

but if i try and connect to other reporting server on other machine using web http://servername/reportserver i m able to connect it.
but dont know whats the problem on my machine.

do i need to start any services for this...

so anybody knows how to troubleshoot this issue.

Thanks in advance...

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved