SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL SERVER Login Problems
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

crazycat503
Starting Member

Eritria
16 Posts

Posted - 01/08/2013 :  03:39:02  Show Profile  Reply with Quote
Hi,

CUrrently, we developed a db that uses windows mode with integrated security. Now, the application [.net] will be deployed to many clients who run their own usernames that are not registered in the sql server. What's more is that they can have their own passwords. Hence, user's cant be connected to the database server at all.

AN idea that came into mind was to create a windows service that would then be used to connect to sql server 2008. THe idea is it wouldn't matter who is currently logged in as long as the service auto-starts. I know how to create the service but not how to connect to sql server thru it.

Is the idea good and credible? ANy one have experience wit it? HOw about connecting from dot.net thru it? NOte that the sql server 2008 got one instance only.

Please share your insight and advice on it. Thank you all.

All guys!

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 Posts

Posted - 01/08/2013 :  04:04:24  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
You can use a single user in the app to connect to the server/database then it doesn't matter who the users are.
You might want to add something to the app so you can tell who the user is though.

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 01/08/2013 :  04:17:17  Show Profile  Reply with Quote
why not create an application role and just map required users from app to it? app always connectes to sql server using the application role

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000