Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
REDTAIL_CODEGUY
Starting Member
17 Posts |
 Posted - 2011-11-29 : 13:27:43
|
| I'm on the following:SQL SERVER 2008 R2 EXPRESSSQL SERVER 2008 MANAGEMENT STUDIOSBS 2003 (SMALL BUSINESS SERVER)The database was set up with "Windows Authentication" only.I've got a software program that can't access the database, due to login issues. I can run the program only when I log on as the network Admin. or if I use the "runas" method and type in the Admin. password.So, I added the non-admin user that needs to be able to run this program, to sql server via right-clicking the security folder in Management Studio/new/user. But, that still doesn't let the program access the db when logged on as that user.What do I need to do to allow this program to run under this user, using Windows Authentication for sql server? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
REDTAIL_CODEGUY
Starting Member
17 Posts |
Posted - 2011-11-30 : 08:05:35
|
| I get "Failed to connect to data source".I'm using: ConnectionString = "server=SBS2003SERVER\DATABASE_NAME;Trusted_Connection=yes;database=DATABASE_NAME"Works fine if I'm logged on to the workstation as an admin. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
REDTAIL_CODEGUY
Starting Member
17 Posts |
Posted - 2011-12-01 : 06:58:18
|
| I've never used that utility before; not sure if I have it...Perhaps we could focus on SQL/Windows Authentication. How do you tell SQL that a certain user should be granted full access? Other than the original/initial user setup? Are there specific permissions/parameters/capabilities that can be added? Where/how do I do that? |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-01 : 13:51:13
|
| You have to add the user (domain\username that the user logs into the PC with) as a login, then you create a new user in each database and map that user to the login and grant permissions.You need to look at how the network admin login is setup, as well as what databases that login has access to and the permissions for each database.Jeff |
|
|
|
REDTAIL_CODEGUY
Starting Member
17 Posts |
Posted - 2011-12-02 : 08:17:12
|
| Thanks Jeff,Do I do that in SQL SERVER 2008 MANAGEMENT STUDIO? Do you have any documentation on that?- Red. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2011-12-02 : 13:50:52
|
| This is all available in Books Online - the help for SQL Server. Yes, you can do this through SSMS or you can do this with SQL - lookup CREATE LOGIN and CREATE USER in the help system. |
|
|
|
|
|
|
Windows Authentication Security issue?