August 27, 2007 at 9:58 am
I'm trying to create a windows service that perform updates from data stored in another database. The windows form application works fine but the windows service give this error:"The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library" when it's started. Thanks in advance.
August 28, 2007 at 1:12 pm
Hi,
What is your SQL Server Service Account set to?
What is the account the service is running as?
Are you specifying ".", "(local)", or a network address in your connection string. (local service account access network resources without credentials)
Regards,
Andras
August 28, 2007 at 1:26 pm
Thank you for the reply.
My SQL Server Service Account is set to NT AUTHORITY\NetworkService
The Service is running as LocalSystem
In the connection string I use the PC name.
Thank you again
August 29, 2007 at 2:43 am
A few things to check:
In the SQL Server Configuration Manager under the SQL Native Client Configuration tool could you check that Shared Memory is enabled and it is at the top.
If this does not work, enable named pipes (in the same location as above, and try TCP/IP as well) try connecting via named pipes: prefix the connection string with "np:" .
Also, can you connect if you enable the SQL Browser Service?
Regards,
Andras
August 29, 2007 at 8:18 am
Thank you for the reply.
Shared Memory is enable and is at the top. When I use named pipe using "np:" as prefix in the conection string it give me the error:
Event Type:Error
Event Source:ServiceAsterisk
Event Category:None
Event ID:0
Date:29/08/2007
Time:10:03:34
User:N/A
Computer:SAL-TEC-DSK-06
Description:
Service cannot be started. System.ArgumentException: An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.
at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String connectionString, Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
at ServiceAsterisk.ServiceAsterisk.OnStart(String[] args) in C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\Servic...
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
The SQL Browser Service is enable too.
Any ideas??
October 13, 2008 at 1:32 am
Hi
Which service pack is installed on sql. if its RTM apply sp.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply