Re: Help! Set up Windows Group to access application



Thank you very much, Dan!!
--
Sandy


"Dan Guzman" wrote:

Could you give me a concrete step-by-step example of what to type in Query
Analyzer to set up a new windows login and a new group and corresponding
rights?

Below is a general permission script that you can customize for your needs.
The connection string for a trusted connection is:
"Provider=SQLOLEDB.1;Server=W2KDA1SQL;Database=PartiallyDisbursedLoanCalls;Integrated
Security=SSPI"


USE PartiallyDisbursedLoanCalls

--add a new role
EXEC sp_addrole 'MyRole'

--grant all needed object permissions to role
GRANT EXEC ON dbo.usp_MyProc TO MyRole
GRANT SELECT ON dbo.MyTable TO MyRole


--add Windows login
EXEC sp_grantlogin 'MyDomain\CustomerService'

--add login as database user
EXEC sp_grantdbaccess 'MyDomain\CustomerService'

--add database user to role
EXEC sp_addrolemember 'MyRole', 'MyDomain\CustomerService'


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Sandy" <Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:14E9358A-5531-435A-A9A6-71B5F0F4B13C@xxxxxxxxxxxxxxxx
Hi -

The connection string I am using is:
.ConnectionString =
"Provider=SQLOLEDB.1;Server=W2KDA1SQL;Database=PartiallyDisbursedLoanCalls;User
Id=SqlUser;password=Password10"

The above string works to get the users into the database. They are
inserting records to their heart's content. The problem is when someone
tries to access any Crystal Report (I use stored procedures in Sql Server
and
the corresponding VB code), they get a connection error.

I wanted to use Windows security, but I couldn't get it to work; even with
trying the suggestions from the people who have replied previously.

I also ended up using Sql Server 2000 because I needed to get this out in
a
hurry and knew the SqlUser and password works with another database I have
connected to an application.

Could you give me a concrete step-by-step example of what to type in Query
Analyzer to set up a new windows login and a new group and corresponding
rights?

I am getting frantic at this point . . .

--
Sandy


"Erland Sommarskog" wrote:

Sandy (Sandy@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
Thanks again for replying, Sue!

I don't know exactly where to look for that. Could you point me in the
right direction?

Again, any help you can give me is greatly appreciated!

If you have troubles with finding your ways in Crystal Reports, you are
probably better of in a forum for Crystal Reports. While we use it in our
shop, I try to stay away from it as much as possible. (And we never
connect
directly from Crystal to the database anyway. We pass it recordssets from
VB.)

Another strange thing -- another developer was able to access the
reports via the application without a problem.

A regular user cannot and receives the error previously posted.

That certainly is a little funny, since it seems from your posts that
you are using integrated security in both Crystal and the VB app. But
that is only seems. It would really help if you posted the connection
strings that you use, both in the VB6 app and in Crystal.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx


.



Relevant Pages

  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: VERY strange database connection problem
    ... My application is in a subdirectory, actually it was in the root to begin with and moved but there was still a copy of the old web.config. ... You didn't mention whether you're using a Trusted Connection, that is, using your Windows login rather than a SQL Server account user name and password. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help! Set up Windows Group to access application
    ... problem in passing credentials to the server. ... in Crystal then look at how the connection to SQL Server is ... I was not able to set up Sql Server 2005 ... the following message when they access Crystal Reports: ...
    (microsoft.public.sqlserver.security)
  • Connection set up super slow
    ... I've noticed that the VS 2005 Crystal Reports seems to be very slow ... when setting up a connection to SQL Server. ... ReportDocument report = new MyCustomReport; ...
    (microsoft.public.vb.crystal)
  • ASP.NET to SQL Server Int Security
    ... Windows Login to carry though from the pages I access to ... In IIS I've disabled Anonymous Access and checked ... I have a valid account on the SQL Server ... which is strange becuse the entry in my IIS Logs with the ...
    (microsoft.public.dotnet.framework.aspnet.security)