By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,985 Members | 1,712 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,985 IT Pros & Developers. It's quick & easy.

Windows Service Acessing SQL Server

P: n/a
Hi

I have Windows Service which does particular, depending on which i want to
update the SQL Sever table.

Can access Sql Server from Windows services, if so then how to do it?

thanks in advance
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi
A simple strait forward answer would be . Give the user account that your
service run Under access to your SQL server database.
What you need to do is to check what credential that your service run
under . And you can make it run with the credentials of a specific user
(from Administrative tools ' services ' rightclick your service '
properties ' logon tab ' this account ) then enter the user name and
password of this windows account .
In SQL server , what you need to do is to select your database ' users
Then add that user ( of the service ) to the users of your databases and
give him the relative permissions
Hope that helps
Mohamed Mahfouz
MEA Developer Support Center
ITworx on behalf of Microsoft EMEA GTSC

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.