April 19, 2006 at 11:19 am
I have a C# application that users MSDE Users are added thru the application using sp_grantlogin, sp_grantdbaccess then they are added to a rold using sp_addrolememeber.
When there is a domain the user is added using domain\user when there is no domain we use machine\user. This has worked in several installations just fine.
My problem is in an installation that has three W2K Prof machines with no domain controller. At the machine with MSDE logged on as an Administrator I can add users on that machine but can not add users from the other two computers.
Any help would be great.....
April 19, 2006 at 1:46 pm
And you won't be able to. Without a domain controller, that means all computers are in a workgroup. Even if they all are in the same workgroup, there is no trust relationship between any of the machines. The workgroup functions as a container to find each other quickly, nothing else.
The workaround is to create an identical user account of the computer which has MSDE which matches the username/password which is being used from another system. You'd still add in as Machine\User, where Machine is the machine name where MSDE is installed, but that would allow you to work as you desire. The problem is, then, keeping the username/passwords in synch if they change often.
Failing that, you can go to SQL Server logins, so long as you create them in MSDE first.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply