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 |
Ebola
Starting Member
3 Posts |
Posted - 2004-07-31 : 10:05:13
|
Hello,I'm new to MSDE, and server databases in general. I'm still trying to understand how they work. I managed to get MSDE up and running locally. I used Access' upsizing tool to move my access database to MSDE. I know how to use the osql command prompt and t-SQL to issue basic SQL commands. Few questions:1. How do I create a server? 2. How must I go about configuring other computers to access that server? I think I'm using Windows Authentication mode as security. 3. Also, on another note, I've read that one can attach/detach databases. Why is it that I was able to access my database using the USE statment, without attaching it first?Thanks! |
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-08-01 : 19:27:13
|
1. You already have the server. It's MSDE2. Other computers access the server by setting up a DNS in the ODBC Connections dialog within Control Panel --> Administrative tools3. You can't. The Access upsizing tool will have created the database for you. The upsizing isn't simply a matter of 'attaching' the db to MSDE. The upsizing tool creates a new db from scratch, creates the tables then inserts the data. Attaching/detaching database can only be done with native SQL Server/MSDE databases.HTH,Tim |
|
|
Ebola
Starting Member
3 Posts |
Posted - 2004-08-01 : 22:12:17
|
ok...thanks timmy...I'll look in setting up a DNS In regards to question 1, what I meant was how do I grant a particular client permission to access the database (in the light that I'm using Windows Authenitication Mode?) What must I do from teh server end? thanks in advance |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-01 : 22:34:56
|
USE masterGOEXEC sp_grantlogin 'DOMAIN\username' --This gives them access to the SQL Server.GOUSE database --Replace database with whatever database you are giving them access to.GOEXEC sp_adduser 'DOMAIN\username','username' --This adds the user to the database specified in the USE statement above.GOMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
Ebola
Starting Member
3 Posts |
Posted - 2004-08-02 : 12:12:34
|
Awesome! Thanks! |
|
|
|
|
|