x

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, 2010 at 01:52 PM in Default

kavita gravatar image

kavita
41 5 5 6

What have you tried so far?
Sep 27, 2010 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, 2010 at 05:35 AM

Blackhawk-17 gravatar image

Blackhawk-17
11.9k 28 31 37

(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, 2010 at 03:17 PM

TimothyAWiseman gravatar image

TimothyAWiseman
15.6k 21 23 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, 2010 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, 2010 at 02:05 PM

Tim gravatar image

Tim
36.4k 39 41 139

this is the favourite for a new installation
Sep 27, 2010 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, 2010 at 02:00 PM

DaniSQL gravatar image

DaniSQL
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, 2010 at 01:55 PM

CirqueDeSQLeil gravatar image

CirqueDeSQLeil
4.9k 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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x742
x89
x87

asked: Sep 27, 2010 at 01:52 PM

Seen: 1255 times

Last Updated: Sep 27, 2010 at 01:52 PM