How do I set the path to the working database for other users?
Currently it's on a mapped folder as Z:\
I know I can change the WORKINGDIRECTORY value but was wondering if there
was a way to do this when adding a user
Thanks to a post by MVP Hari Prasad for the following info:
osql -S Name -Usa -Ppassword
sp_addlogin 'SKY','password'
go
Use engdb
go
sp_adduser 'SKY'
go
When I first tested MSDE, it looked for a database in the DATA folder on the
local computer's drive. We've got the database mapped to a Server's drive.
When adding this user (I've got several that will have to be added), is
there a SP for the path. I'm either overlooking or there isn't one or I'm
looking in the total wrong place.
Also,Hari had posted that
sp_addrolemember 'db_datareader','hari'
go <enter>
was used and if so, is it required to give the member a specific role.
AFAIK, all users will have read/write access and I'm hoping that read/write
access is set by default.
Thanks,
David Guess
Well, I found sp_attach, one out of two so far.
"DGuess" <majik@.mindspring.oops> wrote in message
news:%2363j2rX5FHA.3136@.TK2MSFTNGP09.phx.gbl...
> How do I set the path to the working database for other users?
> Currently it's on a mapped folder as Z:\
> I know I can change the WORKINGDIRECTORY value but was wondering if there
> was a way to do this when adding a user
> Thanks to a post by MVP Hari Prasad for the following info:
> osql -S Name -Usa -Ppassword
> sp_addlogin 'SKY','password'
> go
> Use engdb
> go
> sp_adduser 'SKY'
> go
>
> When I first tested MSDE, it looked for a database in the DATA folder on
> the local computer's drive. We've got the database mapped to a Server's
> drive. When adding this user (I've got several that will have to be
> added), is there a SP for the path. I'm either overlooking or there isn't
> one or I'm looking in the total wrong place.
> Also,Hari had posted that
> sp_addrolemember 'db_datareader','hari'
> go <enter>
> was used and if so, is it required to give the member a specific role.
> AFAIK, all users will have read/write access and I'm hoping that
> read/write access is set by default.
>
> Thanks,
> David Guess
>
>
|||For SQL Server/MSDE, users DO NOT need to know file path to database(s)
running by the SQL Server/MSDE. Users (or more accurate, apps that access to
SQL Server/MSDE) only need to know server name, database name, and
login/password (if the SQL Server/MSDE database uses SQL Server security).
"DGuess" <majik@.mindspring.oops> wrote in message
news:%2363j2rX5FHA.3136@.TK2MSFTNGP09.phx.gbl...
> How do I set the path to the working database for other users?
> Currently it's on a mapped folder as Z:\
> I know I can change the WORKINGDIRECTORY value but was wondering if there
> was a way to do this when adding a user
> Thanks to a post by MVP Hari Prasad for the following info:
> osql -S Name -Usa -Ppassword
> sp_addlogin 'SKY','password'
> go
> Use engdb
> go
> sp_adduser 'SKY'
> go
>
> When I first tested MSDE, it looked for a database in the DATA folder on
> the local computer's drive. We've got the database mapped to a Server's
> drive. When adding this user (I've got several that will have to be
> added), is there a SP for the path. I'm either overlooking or there isn't
> one or I'm looking in the total wrong place.
> Also,Hari had posted that
> sp_addrolemember 'db_datareader','hari'
> go <enter>
> was used and if so, is it required to give the member a specific role.
> AFAIK, all users will have read/write access and I'm hoping that
> read/write access is set by default.
>
> Thanks,
> David Guess
>
>
|||"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:O9%233rxY5FHA.884@.TK2MSFTNGP14.phx.gbl...
> For SQL Server/MSDE, users DO NOT need to know file path to database(s)
> running by the SQL Server/MSDE. Users (or more accurate, apps that access
> to SQL Server/MSDE) only need to know server name, database name, and
> login/password (if the SQL Server/MSDE database uses SQL Server security).
>
Correct me if I'm wrong, but woudn't it point to the server's Data folder?
The server is on one machine, the data on another.
When we first set it up and upsized the Access database to SQL (via
BillQuick 2005 Pro), it put it on the server machine where MSDE was
installed.
When I did a second test, I changed the WORKINGDIRECTORY value in the
registry to point to the mapped folder and whenIwent to upsize it, it put
the data on the other machine where they want it.
They want the db to be on another computer that gets backed up daily and
also won't cause such a slow down on the server computer. MSDE is set up on
the one machine which they can access while the data is downstairs way off
to itself and there are other security reasons the don't want to allow
access for something such as Remote Desktop where they could easily make the
changes/additions as needed.
If I don't have to set the path, that'll make it easier on me but I have
this funny feeling I'll have to do that with the way they have their setup.
Anyway, I'll know how close I am to getting them access to the db.... I
think I'm close anyway. If the other users can connect to it I'll be fine
till one leaves to work elsewhere or whatever.
Appreciate the reply,
dg
|||"Norman Yuan" <NotReal@.NotReal.not> wrote in message
news:O9%233rxY5FHA.884@.TK2MSFTNGP14.phx.gbl...
> For SQL Server/MSDE, users DO NOT need to know file path to database(s)
> running by the SQL Server/MSDE. Users (or more accurate, apps that access
> to SQL Server/MSDE) only need to know server name, database name, and
> login/password (if the SQL Server/MSDE database uses SQL Server security).
>
I think you may be right on not having to add the path. I was so happy to
get the thing running and all users (20) added and running, I forgot to look
where it went. <G>
Things atarted out okay until we opened BillQuick on the one computer then
went to open it on the second and were prompted that the one user license
was already logged in. They have a 20 user license and we had to hunt up
what was going on there. Found out, that during the upsizing of the database
from Access to MSDE in BillQuick 2005 Pro, it does not include the
additional licenses. Entered that to get it to show 20 users and still,
could only log in one at a time. Looked thru everything and finally gave up
and called tech support and they too were stumped. Thgey asked for some
screenshots so when I went to log on the second user's computer, instead of
the prompt that one user was already logged in on one user license, it
logged it just fine. Haven't a clue as to why it did it that way.
Anyway, since I managed to get all the user logins, users added, and each
logged into the proper database I went home..
I'll check tomorrow to see where it landed, I do hope it is on the drive it
upsized the Access database from.
Appreciate the info and for someone who three days ago had never looked at
anything SQL/MSDE, I've learned a lot and feel the comfort level with it as
I do with VB6. I was reading on some of the scripting to help automate some
of this and will experiment with them. I, personally, won't be the
administrator on this so anything I can do to help them will help me in the
long run.
Thanks,
David Guess
Microsoft MVP Outlook Express.
