Solved

SQL Server jobs not running after a password change on the running windows account

Posted on 2008-10-03
3
1,093 Views
Last Modified: 2012-05-05
The sql server services (agent, db, browser, full text and analisys)  were running on a windows acount, recently we change the password on that acount( previously stopping the services) and changing it on the services as well, but with that change the sql server jobs stop running and the error message on the application event log is:
"The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENTE: <local machine>]

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp."

Any help on this issue would be really appreciated!
0
Comment
Question by:valdivie
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Expert Comment

by:gdemaderios
ID: 22642851
Could you please provide your sql server logs?  They're usually located here:

C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\LOG
0
 

Author Comment

by:valdivie
ID: 22662338
Here is the error shown in the error log:
2008-10-07 13:34:19.48             Error: 17828, gravedad: 20, estado: 3.
2008-10-07 13:34:19.48             The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENTE: <local machine>]
2008-10-07 13:38:30.65             Error: 17828, gravedad: 20, estado: 3.
2008-10-07 13:38:30.65             The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENTE: <local machine>]
0
 

Accepted Solution

by:
gdemaderios earned 125 total points
ID: 22665757
Are you seeing any other errors in that log?  I don't think that that is what is causing your problem.  Perhaps this line:  Error: 18456, Severity: 14, State: 16.

More than likely the user doesn't have read/write permissions to the mdf file.  Can you verify that the permissions are okay and that error 18456 is or is not showing up in the log file?
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
DESKTOP MONITORING 41 86
sql server query 9 27
Group ordersum by orderdate 3 22
Error converting data type varchar to numeric. 4 14
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question