Newbie - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

MSDE (2000)

Newbie

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 MSDE
2. Other computers access the server by setting up a DNS in the ODBC Connections dialog within Control Panel --> Administrative tools
3. 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 master
GO
EXEC sp_grantlogin 'DOMAIN\username' --This gives them access to the SQL Server.
GO
USE database --Replace database with whatever database you are giving them access to.
GO
EXEC sp_adduser 'DOMAIN\username','username' --This adds the user to the database specified in the USE statement above.
GO

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Ebola
Starting Member

3 Posts

Posted - 2004-08-02 : 12:12:34

Awesome! Thanks!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources