Question Locked

sql connection

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I installed sql 2005. Enabled remote..enabled tcp ip connection..created db and gave login rights to a user will be extracting excel data to the new database.

how do I configure hime to access from his client machine? she will need to be able to create tables so...Do I install Management Studion on his machine?

Help! Thanks....

2 replies

by tariq.umair

Yes, you need to install the SQL Enterprise Manager (not database) on her machine so that she can remotely access the database on your machine. Do give her full rights for that particular database so that she can create tables.

This discussion is closed to new replies.