I'm trying to migrate our applications working with SQL Server 2005 Express from Windows XP to Windows 7, and have following problem. Desktop applications connect to SQL Server fine, but windows service app returns following error when trying to connect:
[DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error
I tried installing service under localsystem account and under desktop user account with no success.
My connection string looks like Provider=SQLOLEDB.1;Password=password;Persist Security Info=True;User ID=user;Initial Catalog=data;Data Source=servername
I've searched a bit about this error and one recommendation was to try to use SQL Native client, so I tried to change my connection string to
Provider=SQLNCLI;Pwd=password;UID=user;Database=data;Server=servername, this also works when running from desktop but when running from windows service I get another error
SQL Network Interfaces: The requested security package does not exist
This seems to be purely client problem because when I use wrong server name I still get the same errors.
I guess something changed with permissions of services in Windows 7
Any ideas what could be wrong and how to fix it?
View Complete Post