>-----Original Message-----
>i have just been informed we are running MSDE, not the
>full SQL server.
>
>i am running the OSQL service that comes with it, and
>looking through the information i have found so far.
still
>if anyone knows what i should be doing it would be
greatly
>appriciated as i have spent too long on this job already,
>and am still not complete.
>
>i only have one and a half hours left, then it has to be
>up and running so if anyone knows anything about this
>please feel free to share.
>
>I am currently flicking through this:
>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;q325003 and attempting to find how to set security /
>user profiles for the database / program.
>
>Thanks.
>
>Chris Brighton
>
>>-----Original Message-----
>>You can add both Network accounts as well as Local
Domain
>accounts
>>Which version of SQL Server are you using ?Enterprise
>Manager is a GUI Tool
>>for administring SQL Server and Databases and is
>available only with
>>licensed editions. It is not available if you are using
>the free Desktop
>>Edition.
>>
>>If you have Enterprise Edition (installed in
>programs/micrsoft sql
>>server/enterprise manager): Under (Local)/Security,
right
>click to select
>>'New Login' and specify your domain account.
>>For Desktop Edition: look up for examples on how to use
>sp_grantlogin in SQL
>>Server help or this newgroup
>>
>>HTH, Amol.
>>
>>"Chris Brighton" <anonymous@discussions.microsoft.com>
>wrote in message
>>news:4c7301c42c49$a6eef750$a301280a@phx.gbl...
>>> Hi,
>>>
>>> I havent used SQL before, and am only using it now as a
>>> 3rd party application requires it. I don't know how to
>>> access the needed options. I will look at books online,
>>> but would appriciate a reply if you can make it any
>>> simpler :)
>>>
>>> As for the enterprise manager - i have been looking for
>>> this for a while, after flicking through the MS
Knoledge
>>> Database I looked for enterprise manager, but couldn't
>>> find it. You say i can add a windows user to the SQL
>>> server (i assume that means giving them read / write
>>> access), is this only local profiles or network
profiles
>>> too?
>>>
>>> Thanks for your reply.
>>>
>>> Chris Brighton
>>> >-----Original Message-----
>>> >Hi,
>>> >
>>> >It seems you are using Windows authentication to
>connect
>>> to SQl server. In
>>> >that case add the Wndows user group or user to SQL
>server
>>> (SP_GRANTLOGIN)
>>> >and give required permissions to database
>>> (SP_GRANTDBACCESS). After this add
>>> >the necessory database wide fixed roles to this user
to
>>> access the database
>>> >objects.
>>> >Refer books online for usage of both procedures.
>>> >
>>> >Otherwise you can use Enterprise manager -- Security
>>> option to add the
>>> >Windows User to SQL Server.
>>> >
>>> >Note:
>>> >
>>> >By default BUILDIN/Administrators are already given
>>> previlages to SQl
>>> >server, that is the reason ur application works fine
in
>>> administrator
>>> >profile.
>>> >
>>> >Thanks
>>> >Hari
>>> >MCDBA
>>> >
>>> >"Chris Brighton" <anonymous@discussions.microsoft.com>
>>> wrote in message
>>> >news:4c6601c42c43$bbc494b0$a501280a@phx.gbl...
>>> >> I am running SQL on our network to use a program
>called
>>> >> BSquared: Connecting Steps. this program stores
>>> >> information on a database on the server and uses
SQL
>to
>>> >> access it.
>>> >>
>>> >> when running the program on an administrators
profile
>>> >> everything works fine, however when i attempt to
run
>the
>>> >> program on a normal profile i get the following
>error:
>>> >>
>>> >> ----------------------------------------------------
-
>---
>>> --
>>> >> Microsoft SQL Server Login
>>> |X|
>>> >> ----------------------------------------------------
-
>---
>>> --
>>> >>
>>> >> Connection failed:
>>> >> SQLState: '28000'
>>> >> SQL Server Error: 18456
>>> >> [Microsoft][ODBC SQL Server Driver][SQL Server]Login
>>> >> failed for user 'Domain\user'
>>> >>
>>> >> ------
>>> >> | OK |
>>> >> ------
>>> >>
>>> >>
>>> >> If anyone knows how i can enable all users access
to
>the
>>> >> database, without giving everyone administrative
>>> >> privelages. We cannot comprimise security by giving
>>> >> everyone access to an administrator account, but we
>do
>>> >> need all members of staff to have access to this
>>> database.
>>> >>
>>> >> Thanks in advance.
>>> >>
>>> >> Chris Brighton
>>> >
>>> >
>>> >.
>>> >
>>
>>
>>.
>>
>.