473,405 Members | 2,279 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,405 software developers and data experts.

Windows Service Database problem

1
Hi,

I am creating a windows service that will process exe file( Developed in VB and connects to database using DSN and sa/master login).
When service process exe I am getting Database (Sql Server 2005) error "login failed to user sa.."

Code I am using:

Process p;
string FilePath = @"C:\vb_file.exe "; // vb_file connects to DB Sql Server 2005
string arg = " /send";
p = Process.Start(FilePath, arg);

Error I am getting...

The VB Application identified by the event source logged this Application vb_file: Thread ID: 5748 ,Logged:
vb_file Rev. 30-Apr-03T /send /RESTART

vb_file Rev. 30-Apr-03T /send /RESTART
Error 40002 in SQL.InputConnect: 28000: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'. [Aborted]


Please help...

Thanks
Taduri
Jul 12 '07 #1
0 1054

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: epaetz | last post by:
I'm getting Not associated with a trusted SQL Server connection errors on a .Net windows service I wrote, when it's running on my application server. It's not a problem with mixed mode...
3
by: Evan Camilleri | last post by:
I have a problem for a Windows Service to login on an SQL server (different machine) - neither Windows Authentication nor SQL Authentication worked. LOGIN FAILED FOR USER sa (for example). If...
4
by: Andy Baker | last post by:
I have an Windows forms application written in VB.NET that uses a SQL Server 2000 back end database with Windows authentication. There is no problem accessing the database from my application, or...
3
by: adasilva | last post by:
I have create a Windows service that uses a timer to access a Web Service. The service is set to start Automatically and its using the local system account. The service also logs events to the...
2
by: Trevor | last post by:
Argh! This problem is driving me nuts! Can you help? In November of 2003, I installed a web service on Windows Server 2003 built in VB.NET for v1.1.4322 of the framework. It contains a timer...
1
by: james | last post by:
Hi Apologies if this is the incorrect group for this post. I have a Windows Service running that populates a database and a Web Service that accesses the same SQL 2000 database. One of my...
2
by: Jenbo | last post by:
Hi all, I have a task at the minute which involves getting data from csv files into a database and doing some nice auditing on the records in there on a web front end. The csv files are going to be...
0
by: =?Utf-8?B?c3VqaXRo?= | last post by:
i have a setup project setup1 which deploys two windows services windows service1,windows service2.i also added some custom installation actions into it using projectinstaller.cs.In windowsservice1...
0
by: =?Utf-8?B?QmlsbEI=?= | last post by:
This is a tough one... My Windows Service app periodically performs some processing on new entries to a SQL Server database table. It uses a simple System.Timer to call the Elapsed event...
3
by: Matt Lowrance | last post by:
I'm hoping someone can give me a little guidance. I have written a simple Windows Service that goes out and scrapes a few web pages and updates some data in an access database. The service works...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.