pivot information: accessing

Showing posts with label accessing. Show all posts

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

PLEASE HELP - Accessing Web Services through Windows App

I am running a vb.net application that is using the Web Service to
issue Update Snapshot. There is a Windows account we are using as a
Service account that has the proper permissions to Generate Events.
The application is running on AutoSys on a 2003 server. I have
confirmed that it will run under this users credentials manually by
logging into the server as the user and firing the app. It works
without a problem. This was using Default Credentials.

The AutoSys job is configured to run under this user's credentials.
There are three ways I have executed this application

>>Through AutoSys running as the user with the proper permissions (this is in place of a Local Service account which is default for AutoSys. This windows user has local admin permissions on the AutoSys server as well as Generate Event permission as confirmed before)
>>By logging into the server as Administrator and executing the app with "Run As..." set to the Windows ID
>>By switching to new.NetworkCredentials and passing the hardcoded username/pass/domain

For all of the above scenarios - it fails

The ONLY time it successfully issues UpdateSnapshot is when I am
logged in to the server as the user in question. In ALL other
instances detailed above it fails and the following comes out of the
event log

"Line 1: Incorrect syntax near 'MyDomainName'.

I have no idea why it is choking on the Domain Name in all three of
those scenarios.

Do I need to impersonate that user through code when passing the Web
Service credentials?

PLEASE PLEASE PLEASE help - I need to wrap this up. ANY HELP WOULD BE
GREATLY APPRECIATED

Could you show a sample of your code? Syntax error indicates compilation/parsing error. AutoSys method #2 or #3 sound like they should be workable.

Thank you.

|||

I was wrong (partially) - the error I am referring to in the original post is being caused by my attempt to trap the error and write it to a log table in SQL Server. The error is actually as follows

The permissions granted to user 'mydomain\myuser' are insufficient for performing this operation

The fact that there are single quotes in the error is causing a syntax error in my SQL statement.

So - the actual user still does not have the permissions needed to issue UpdateSnapshot. I have confirmed with the Administrators that the user is in a role on the server that contains Generate Events and is also a Browser on all reports on the server.

I did this before in a previous environment and it worked perfectly. Can anyone definitively tell me what permissions are required in order to do things like UpdateSnapshot, FireEvent, CreateSubscription? I thought Generate Events was all that was needed.

During testing I was using my ID to do it and it worked. So I thought I could just create a dummy account and give it the permissions. I am stumped

|||

For update snapshot, you need Execute permission on the report you operate on. You can get it from Manage Report or Manager History task.

You are right for FireEvent you need Generate Event task (which contains generate event permission).

For CreateSubscription, you need either CreateSubscription or CreateAnySubscription permission. It is in "Manage Individual Subscriptions" or "Manage Any subscriptions" task.

|||

Thank you - I did discover that I was looking at the wrong permissions for Updating a Snapshot. The problem I originally had raises and interesting question. How do I handle the SOAP exception with the single quotes in it if I want to write that to a SQL Table? Seems odd that an error would contain single quotes!

|||This is the way we choose to mark the name (RS item name, username, etc.). I guess you can do a string replacing before you insert into your table.sql

Wednesday, March 21, 2012

Please - OLE DB Provider for SQL Server (0x80004005) Cannot generate SSPI context

Please can anybody help me in fixing this error I am getting on ASP page while accessing ASP database page using an SQL server database.

I am using Windows 2000 Service Pack 4 with Internet Exp. 6. The system also has developing software VB6 and IIS. It is connecting well with VB application but is not accessing through IIS.

I have checked all MS Knowledge Base but could not find workaround. MS accepts it as a bug but I could not find quick and easy solution,

Thanking you in anticipation,

Zulfiqar AliSSPI points to an authentication error connecting to your SQL Server instance.

have you tried creating a SQL Server logon and passing that to your connection string? If that works, then there's an issue with your Windows authentication.....

If it doesn't, then you have a more general problem connecting to your database|||

No, but to do this, I need to re-install the SQL server. I am trying to avoid this. Is it possible to change main SQL server login without re-installing SQL Server?

Regards

|||hata error

Saturday, February 25, 2012

pivot tables & offline cube access

Is it possible to have multiple pivot tables in the same Excel workbook accessing the same offline cube file?

Currently, when the user is connected to the server it connects to a .asdatabase to populate many pivot tables. I need to allow the user to access a local cube file when they are not connected to the server.

I am using excel vba macros to connect the pivot caches to the online data source, which works perfectly. I would like to do the same to connect the pivot caches to the local cube file.