March 12, 2008 at 6:48 am
I have a user named A10767 that logs into a client computer that needs to connect to a database named ICP on a SQL server.
I use a connect string as follows:
Provider=sqloledb;Data Source=myServer;Initial Catalog=ICP;Integrated Security=SSPI;
A10767 is in the users group on the server.
A10767 has a SQL Server login account with properties of
General: Windows authentication, default database ICP
Server Role: none checked
User Mapping: A10767 is mapped to ICP, default schema dbo, database role membership public only
Securables: none Explicit permissions: none
Status: permission to connect granted and login enabled
The ICP database properties for permissions are:
For user A10767 grant: only Connect is checked
However this user cannot connect to database ICP. The only way I can get the user A10767 to connect to database ICP is if I check sysadmin for server role for A10767.
How do I get this user to connect to database ICP without the user being a sysadmin?
thanks
March 12, 2008 at 6:54 am
Does the db user match the sever login?
Can you grant the db user the datareader role in the database?
Gethyn Elliswww.gethynellis.com
March 12, 2008 at 7:11 am
It seems some of your terminology is mixed up. There isn't a "Users" group on the server, unless you mean the OS, in which case, specify that. However the user doesn't need to have an account in the OS.
Try experimenting. Create a login, Windows Auth, set the default database. Add a user in that database, mapping to the login. See if that user can connect.
March 12, 2008 at 7:31 am
did you configure the instance for remote connections (tcp/ip or named pipes) ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 12, 2008 at 8:51 am
Thanks for the replies.
Try experimenting. Create a login, Windows Auth, set the default database. Add a user in that database, mapping to the login. See if that user can connect.
I am going to try this but it will be later today to see if it works and I will post the results.
also I am investigating how this user A10767 is set up in our domain as it could be related to that.
March 12, 2008 at 9:37 am
Try experimenting. Create a login, Windows Auth, set the default database. Add a user in that database, mapping to the login. See if that user can connect.
I created the new user as above and the user cannot connect.
March 12, 2008 at 10:03 am
In the error log in SQL Server Agent I get Error 18456 Severity:14, State:5 and Login failed for user Mydomain\A10767 [Client: client IP address]
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply