Re: Re:Application Role and access to 'other' databases
From: Bottomless Pit (pdurdin_at_nospam_hotmail.com)
Date: 05/19/03
- Previous message: Bottomless Pit: "Re: Re:Application Role and access to 'other' databases"
- In reply to: Vishal Parkar: "Re:Application Role and access to 'other' databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 19 May 2003 11:17:56 +0100
Very weird. I've created two new databases and tested this idea. Works a
treat. I need to figure out how to create a linked server.
BUT when I try it on the two databases that I want to implement this
on -----> it doesn't work. I get the message;
Server: Msg 7415, Level 16, State 1, Line 1
Ad hoc access to OLE DB provider 'SQLOLEDB' has been denied. You must access
this provider through a linked server.
Got to sort out more pressing issues - I'll have to get back to this later
today.
Thanks for your help,
regards,
Paul Durdin
"Vishal Parkar" <vgparkar@hotmail.com> wrote in message
news:023801c31da5$0e836f90$a501280a@phx.gbl...
> Since you are trying to connect to other SQL Server i do
> not think there should be any issue while setting up
> linked server. Refer to following links.
>
> Refer to this url
>
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/maintain/featusability/08ppcsq
> a.asp
>
> Also see topics "openrowset","opendatasource", "openquery"
> in BOL.
>
> --Vishal
>
> >-----Original Message-----
> >I am using an application role to access the primary
> database used by my
> >application. This works really well and has allowed me to
> use integrated
> >security and give users access to the database through
> views, but have full
> >access the my program.
> >
> >I need to read data from another database on the same
> server, which is ok
> >normally by specifying
> >
> >SELECT * FROM OtherDatabase.owner.tablename
> >
> >However if you use an application role the integrated
> login account no
> >longer has access to the 'other database'.
> >
> >I Oracle I can create a query across databases by
> specifying the account
> >details for the second database, and I would like to do
> the same in SQL
> >Server.
> >
> >The other database I can connect to as a SQL Server
> account, so something
> >like;
> >
> >SELECT * FROM
> >OtherDatabase.owner.tablename,User=UserName,Password=UserP
> assword
> >
> >I have tried both linked servers and remote databases,
> but neither seem to
> >work on the same machine. It could be that I don't really
> understand how it
> >set up a linked server ok course!
> >
> >Any ideas anyone?
> >
> >regards,
> >
> >Paul Durdin
> >
> >
> >
> >.
> >
- Previous message: Bottomless Pit: "Re: Re:Application Role and access to 'other' databases"
- In reply to: Vishal Parkar: "Re:Application Role and access to 'other' databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
