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 |
|
Halil416
Starting Member
5 Posts |
 Posted - 2006-05-09 : 11:05:42
|
| Hi, allI want some information on how to grant access to db for a network accountMSDE is installed on Local Admin account.sp_grantlogin gives access for local user accounts. But how to enable access for network accounts to local installed MSDE??thanx |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-05-09 : 11:18:59
|
| Add a new user to the local machine using Control Panel's Users applet.Ken |
 |
|
|
Halil416
Starting Member
5 Posts |
Posted - 2006-05-09 : 11:39:30
|
| is it possible to be more clear?Which Control panel? Windows control panel just adds new users which is not related with this problem. Is it SQL Server's Enterprise manager?The server I use is MSDE. So I need some console parameters like 'sp_grantlogin'Problem is MSDE is installed on a network PC in the Local Admin account. But the PC is connected to a Network via Domain controler. All the users log on to network server to use the PC. What I want to do is install th MSDE to local account (admin/user)and enable free access to all the users' network accounts to databases. |
|
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-05-10 : 12:01:29
|
quote:
Windows control panel just adds new users which is not related with this problem.
Actually, it is. If you're using Windows Authentication, you need to add a new user representing the network account (complete with machine name) to the machine running SQL Server. The user name should be in the form MACHINENAME\UserName.Ken |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-25 : 02:03:43
|
| just add your account into the local administrator group of the msde server, then you can use enterprise manager on another machine to connect to it--------------------keeping it simple... |
|
|
|
|
|
|
DB access for a Network Account