how to other users allowed to use my server?

i hav sql server 2008 installed on my computer so how i can allowed other user to access my database
more ▼

asked Sep 27 '10 at 01:52 PM in Default

kavita gravatar image

41 5 5 6

What have you tried so far?
Sep 27 '10 at 01:56 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left

5 answers: sort newest

Are your users separated from SQL Server by a firewall?

Lacking details in the question leaves us throwing ideas out and is a little bit of a waste of everyone's time; writers and readers. But, we are here to help! And if an educated guess gets more information then we'll do it. Besides... others who come looking may benefit :)

@kavita - Please try to put more details into your question so we can focus our efforts and get you a solution.
more ▼

answered Sep 28 '10 at 05:35 AM

Blackhawk-17 gravatar image

11.8k 28 30 35

(comments are locked)
10|1200 characters needed characters left

The other answers on here are all excellent, but they are all assuming that your other users are trying to connect in some fairly low-level way such as through SSMS.

If your users are not themselves database programmers then a better answer may be to create an give them access to an application that permits them to interact in a more high-level abstracted way. Sometimes, the best way to let someone access your database is indirectly such as through a web application, or a more traditional desktop application, or even through Access application under the right circumstances.
more ▼

answered Sep 27 '10 at 03:17 PM

TimothyAWiseman gravatar image

15.5k 19 22 32

@Tim great point. From the question its hard to tell what he knows/what he tried from what he doesnt know/what failed
Sep 27 '10 at 06:07 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Make sure allow remote logins is set to ON and that you are not blocking port 1433 with any desktop firewalls.
more ▼

answered Sep 27 '10 at 02:05 PM

Tim gravatar image

35.5k 32 40 138

this is the favourite for a new installation
Sep 27 '10 at 02:07 PM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

you may want to check this out: [How to: Create a SQL Server Login][1] If users are part of the domain you can add their AD account as @CirqueDeSQLeil suggested, otherwise create a sql login and they will be able to connect to the instance using the login and password.

[1]: http://msdn.microsoft.com/en-us/library/aa337562.aspx
more ▼

answered Sep 27 '10 at 02:00 PM

DaniSQL gravatar image

4.9k 33 35 39

(comments are locked)
10|1200 characters needed characters left

Add their user accounts in the security section within Management studio.

Otherwise, there might be something preventing them from attaching to it. If you have already added their accounts, then you may be receiving an error message. Post the error message and we can provide more help about that.
more ▼

answered Sep 27 '10 at 01:55 PM

CirqueDeSQLeil gravatar image

4k 10 11 15

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 27 '10 at 01:52 PM

Seen: 959 times

Last Updated: Sep 27 '10 at 01:52 PM