ODBC and SQL Server 2000

[Sara_Corke]

I install SQL server 2000 on a computer.
I made a new database and table on it.

I wanna to use ODBC on another computer.
When I use ODBC on another computer,it can n't connect to the Computer that I install SQL server.

Please tell me what should I do?!Where is the Problem do you think?

Waiting to hear soon.

[MAK]

Do you get any error message?

Did you create login and user on the database that you created?

Did you give access to the login you created?

[MAK]

message

About ODBC
I have SQL server error number 17.
Please tell me how can I make an acount on the SQL server and give the Permision to connect to it.



If your database is 'XYZ' and your if login say 'CAUser' with password 'read' needs read and write access. do the following.

--Create user
Use master
Go
exec sp_addlogin 'CAUser','reader','XYZ'
go

use XYZ
go
sp_adduser 'CAUser'
go
exec sp_addrolemember N'db_datareader', N'CAUser'
go
exec sp_addrolemember N'db_datawriter', N'CAUser'
go