Hi Lads,
I'm having this severe problem that's wrecking my head altogether! I created
a new user on my local machine, the purpose of this was to allow this user to
access certain reports through an asp.net application (to build up the
specified reports parameters, and pass them back using the soap API)
To test this I logged in as this user, and went to the report manager - but
nothing
came up! all I get is the home page with no reports! I granted "content
manager" access for this user for the group of reports when I logged in as
administrator...any ideas would be much appreciated!Do they have access to anything in the Home folder? If not then they will
see nothing. You have to give them a path to navigate to the reports they
have permission to view.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rowan Massey" <RowanMassey@.discussions.microsoft.com> wrote in message
news:7B34FA0E-AAF9-489A-A92C-A0CCB2FC6DE9@.microsoft.com...
> Hi Lads,
> I'm having this severe problem that's wrecking my head altogether! I
> created
> a new user on my local machine, the purpose of this was to allow this user
> to
> access certain reports through an asp.net application (to build up the
> specified reports parameters, and pass them back using the soap API)
> To test this I logged in as this user, and went to the report manager -
> but
> nothing
> came up! all I get is the home page with no reports! I granted "content
> manager" access for this user for the group of reports when I logged in as
> administrator...any ideas would be much appreciated!
>
Showing posts with label authentication. Show all posts
Showing posts with label authentication. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
PLEASE HELP - Remote connection to SQL Server 2005 fall over after 100 seconds
Hi,
I am remotely accessing SQL Server 2005 using an import manager,
through a windows authentication login.
I start the loading, it connects perfectly at first but at the 100
second mark I get the error
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes
not exist or access denied" it then reconnects and continues to load
but really slowly. So it looks like a timeout is occuring at 100
seconds
I have tried to change the connection timeout, the execution timeout
and the remote login timeout, nothing stops this happening.
The version of sql I am using is a SQL Server 2005 Evaluation edition.
Can anyone help?
Thanks
ArchanaIs there some reason you're using the ODBC driver to access SQL Server
instead of a native provider?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
<archanapatelwhite@.googlemail.com> wrote in message
news:1174608028.525589.151310@.e65g2000hsc.googlegroups.com...
> Hi,
> I am remotely accessing SQL Server 2005 using an import manager,
> through a windows authentication login.
> I start the loading, it connects perfectly at first but at the 100
> second mark I get the error
> "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does
> not exist or access denied" it then reconnects and continues to load
> but really slowly. So it looks like a timeout is occuring at 100
> seconds
> I have tried to change the connection timeout, the execution timeout
> and the remote login timeout, nothing stops this happening.
> The version of sql I am using is a SQL Server 2005 Evaluation edition.
> Can anyone help?
> Thanks
> Archana
>|||Hi Bill
The loading is going through a third party import manager, they must
be setting the ODBC driver to access SQL Server.
However when the company who wrote the import manager test it in their
environment replicating what I do they have no problems and it loads
fine
Thanks
Archana
I am remotely accessing SQL Server 2005 using an import manager,
through a windows authentication login.
I start the loading, it connects perfectly at first but at the 100
second mark I get the error
"[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server d
oes
not exist or access denied" it then reconnects and continues to load
but really slowly. So it looks like a timeout is occuring at 100
seconds
I have tried to change the connection timeout, the execution timeout
and the remote login timeout, nothing stops this happening.
The version of sql I am using is a SQL Server 2005 Evaluation edition.
Can anyone help?
Thanks
ArchanaIs there some reason you're using the ODBC driver to access SQL Server
instead of a native provider?
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
<archanapatelwhite@.googlemail.com> wrote in message
news:1174608028.525589.151310@.e65g2000hsc.googlegroups.com...
> Hi,
> I am remotely accessing SQL Server 2005 using an import manager,
> through a windows authentication login.
> I start the loading, it connects perfectly at first but at the 100
> second mark I get the error
> "[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server
does
> not exist or access denied" it then reconnects and continues to load
> but really slowly. So it looks like a timeout is occuring at 100
> seconds
> I have tried to change the connection timeout, the execution timeout
> and the remote login timeout, nothing stops this happening.
> The version of sql I am using is a SQL Server 2005 Evaluation edition.
> Can anyone help?
> Thanks
> Archana
>|||Hi Bill
The loading is going through a third party import manager, they must
be setting the ODBC driver to access SQL Server.
However when the company who wrote the import manager test it in their
environment replicating what I do they have no problems and it loads
fine
Thanks
Archana
Subscribe to:
Posts (Atom)