Adding New Subscription To SQL Server 2005s Local Subscriptions Fails...

Jun 23, 2006

Hi everyone,

I am trying to add a new subscription to the local subscriptions of a SQL Server 2005.  As soon as I click on SERVER_NAME -> Replication -> Local Replications -> New Subscription, I get the following error message:


TITLE: New Subscription Wizard
------------------------------
Microsoft SQL Server Management Studio is unable to access replication components because replication is not installed on this instance of SQL Server. For information about installing replication, see the topic Installing Replication in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=Microsoft.SqlServer.Management.UI.ReplUtilitiesErrorSR&EvtID=ReplicationNotInstalled&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:

Die EXECUTE-Berechtigung wurde für das 'sp_MS_replication_installed'-Objekt, 'mssqlsystemresource'-Datenbank, 'sys'-Schema verweigert. (Microsoft SQL Server, Error: 229)

Translated from German to english:
EXECUTE-Permission for the 'sp_MS_replication_installed'-Object, 'mssqlsystemresource'-Database, 'sys'-Schema denied. (Microsoft SQL Server, Error: 229)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=229&LinkId=20476
------------------------------
BUTTONS:

OK
------------------------------

Btw, I am using the SQL Server Management Studio.

Thanks,
Olcay

View 4 Replies


ADVERTISEMENT

Subscription Problem With Local SMTP Server

Oct 17, 2007



Hello,

I am trying to create standard subscriptions using local SMTP server. When i create a subscription with no parameters, the reports and delivered via email. If I try to subscibe to a report with parameters and setting the parameter values , the subscription fails. The Data Source credentials are stored., The same report without parameters is delivered.

Here is the log.


ReportingServicesService!library!10!10/17/2007-12:10:07:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!10!10/17/2007-12:10:07:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for data set 'DS1'. ---> System.InvalidOperationException: ExecuteReader: CommandText property has not been initialized
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.DataExtensions.SqlCommandWrapperExtension.ExecuteReader(CommandBehavior behavior)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.RunDataSetQuery()


Please help !!

View 4 Replies View Related

Reporting Services :: SSRS Subscriptions Resend Reports For Each Subscription?

Sep 1, 2015

I have a Daily Invoice Report that has subscriptions for all customers and is run every night.  The report has parameters of @date & @Customer.  We had issues with invoices not being sent due to the Owner on the reports was disabled in Active Directory.  We do not know how many reports did not get sent out so I am tasked with creating a script to rerun the reports for each day in August.  I have queried the subscriptions, but need to figure out how to rerun the reports using the existing parameters set in the subscription, increment the report parameter date, and execute the emailing of the report.

Here is my query that gives me all the subscription information, but how do I rerun the job for all subscriptions for each date in August?

SELECT USR.UserName AS SubscriptionOwner
      ,SUB.ModifiedDate
      ,SUB.[Description]
      ,SUB.EventType
      ,SUB.DeliveryExtension

[Code] ....

View 2 Replies View Related

Reporting Services :: Identify Failed Subscriptions In Data Driven Subscription Batch

Apr 20, 2015

I have a single data driven subscription that is a batch of 250 subscriptions running on SQL Server 2008 R2. All the parameter values for the report are sourced from a database table. During the execution of the data driven subscription 5 of those subscriptions failed due to timeout error.

Final Status as shown on Subscription screen "Done: 250 processed of 250 total; 5 errors."

The SSRS log file has the subscription GUID which is a single record in the reporting server database tables. How can i identify the individual failed subscriptions? Is there an easy way or a work around that i should implement to identify the failed subscriptions?

View 5 Replies View Related

EnumAvailableSqlServers() Fails To Detect Local Sql Server Instance

Mar 15, 2008

I am using SMO EnumAvailableSqlServer to make a list of available SQL servers in local network. I have tested it in two different local networks. In the first all works fine, but in the second I have noticed that when disconnected from the network the call fails to even detect the locally installed sql servers.
I know that I can scan registry to get installed local servers, but I want to know what could be making problem.

View 3 Replies View Related

How To Access Or Modify Local Subscriptions Data In Merge Replication

Apr 3, 2007

Hello,



If I want to access or modify my local subscription data(not the configuration) how can I do that(from sql server 2005 or from asp.net)? Also can i update directly to the local subscriptions data or do I need another layer which will update from a table for example??



Thank you



Salah

View 3 Replies View Related

Smalldatetime Comparison Between Local Server And Linked Server Fails?

Mar 8, 2006

Hi all,

I have the following select that is designed to compare values on parallel servers.SELECT TA1.EPS, TA1.Sales, TA1.Income, TA1.EarningsReportDate,TA2.EPS, TA2.Sales, TA2.Income, TA2.EarningsReportDate
FROM TradeAnalysis.dbo.SalesIncome_Quarterly AS TA1
FULL OUTER JOIN L_TA_MIRROR.TradeAnalysis.dbo.SalesIncome_Quarterl y AS TA2
ON ((TA1.OSID = TA2.OSID) AND (TA1.QtrYear = TA2.QtrYear) AND (TA1.QuarterNo = TA2.QuarterNo))
WHERE(BINARY_CHECKSUM(TA1.EPS, TA1.Sales, TA1.Income, TA1.EarningsReportDate) <>
BINARY_CHECKSUM(TA2.EPS, TA2.Sales, TA2.Income, TA2.EarningsReportDate))Disregard the full outer join, it is necessary in the full select, I have just pared it down to show here and for testing. A standard join will also have the same result.

The trouble is that the comparison (the BINARY_CHECKSUM) is failing on the EarningsReportDate column, which is defined on BOTH servers in DUPLICATE databases as a smalldatetime.

The data is actually the same in both rows of each table (as is all the other data being compared). What I am seeing is that the select returns milliseconds on the LINKED server (the L_TA_MIRROR reference), but not on the local database?

for example,
Local server data returned in above select is 2000-01-28 00:00:00
Linked server data returned in above select is 2000-01-28 00:00:00.000

Wassup with THAT? If I remove the date from the select/comparison, it says everything matches, so I am pretty sure this is the culprit that is causing the BINARY_CHECKSUM comparison to fail.

Is there some setting that I need to put on the Linked Server reference that says "treat this as the smalldatetime data type it IS, dammit!"????

I can get by the issue if I replace the date reference in the linked server part of the select with CAST(TA2.EarningsReportDate AS smalldatetime) but why do I have to do this?

Yes, I am SURE both servers have the column in question defined as a smalldatetime, as running the same select on either server causes the same failure, but only when referencing the LINKED server column.

View 1 Replies View Related

Email Subscriptions: Changing From Address For Different Subscriptions On Same Server

Jan 18, 2007

I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?

It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).

View 1 Replies View Related

Sql Server Not In VS 2005s Server Explorer

Feb 17, 2007

hi all.

i have SQL SERVER developer edition and VS 2005 pro edition. for some strange reason- my SQL server is not visible in VSs "server explorer". i have to "add a connection" every time i want to view or edit a DB (far from optimal...).

i know this is the SQL forum (as opposed to VS forum) but i got no answare there, so i'm trying you guys.

thanks.

View 1 Replies View Related

Subscription Schedule Fails

Aug 12, 2007

Hi,

I'm trying to schedule a data-driven report subscription on our production server. The scheduled subscription works fine on my development environment, but on the server the job fails with the message "'EXECUTE AS LOGIN' failed for the requested login 'NT AUTHORITYNETWORK SERVICE'". It looks like a security issue, does anyone have any info on how to get this working? The job appears under SQL Server Agent -> Jobs and is created by the Reports Manager when I create the subscription.

Regards,

Greg McNamara

View 1 Replies View Related

Error Adding Stored Proc To Subscription

Dec 14, 2007

I am trying to add a data driven subscription to my report. When I get to the screen to enter the Delivery Query, I enter the stored procedure (GetStatusReportData) in the query box. When i try to validate, I get a "Query is not valid" error. If I replace the stored procedure name with a generic query (select * from jobs), it works fine.

Is there some sort of syntax I need to use to enter a stored procedure here? I have used "exec GetStatusReportData" and that did not work either.

Thanks,
Stuart Fox

View 1 Replies View Related

Adding Push Subscription For Snapshot Replication

Jan 7, 2008

Hi all,

I've been looking for the right stored procedure to create a push subscription for publication but i haven't had much luck so far. So I was wondering if you guys know which SP is appropriate, that'd be super great!! thanks guys!

note. the sp should run on the subscriber database.

thanks again

View 2 Replies View Related

Adding Date To Filename In Report Subscription

Apr 26, 2007

My company sends reports on a daily basis to our customers. Now I want to save all the sent reports on disc with the date in the filename. I have set up a subscription which daily saves the files where I want them. However, I haven't found a way to add the date easily. I already have a parameter when creating the report, it is called Date. Does anybody know if I can use a parameter or something else?



Thank's

View 10 Replies View Related

RS 2005: Subscription Fails With Internal Error

Dec 19, 2006

Hi all,

I have a (for me) strange problem with subscribing reports.

I've setup several reports that I want to create monthly and store to a file share.
In BIDS Preview and deployed to the report server everything works fine.

Each of my reports has an own schedule (they'll be created step by step), export format is Excel, as credentials I use a local user, all parameters are set porperly.
When the time to render the reports has gone, I just see the following behind each subscription:

Failure writing file LIS04 : An internal error occurred on the report
server. See the error log for more details.

The Log file contains the following: (I highlighted what I think to be the key error)

ReportingServicesService!library!4!12/19/2006-10:20:35:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!e!12/19/2006-10:20:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SqlStreamingBufferSize to default value of '64640' Bytes because it was not specified in Server system properties.
ReportingServicesService!library!4!12/19/2006-10:21:22:: i INFO: Initializing SnapshotCompression to 'SQL' as specified in Server system properties.
ReportingServicesService!runningjobs!f!12/19/2006-10:21:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:21:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1a!12/19/2006-10:22:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:22:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1b!12/19/2006-10:23:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:23:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!3!12/19/2006-10:24:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!17!12/19/2006-10:24:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!17!12/19/2006-10:25:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!3!12/19/2006-10:25:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!16!12/19/2006-10:26:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!19!12/19/2006-10:26:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!18!12/19/2006-10:27:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!13!12/19/2006-10:27:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!d!12/19/2006-10:28:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!1c!12/19/2006-10:28:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:29:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!14!12/19/2006-10:29:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!13!12/19/2006-10:30:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:30:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!runningjobs!1c!12/19/2006-10:31:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!8!12/19/2006-10:31:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams
ReportingServicesService!dbpolling!c!12/19/2006-10:32:10:: EventPolling processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 executed at 12/19/2006 10:32:10 AM.
ReportingServicesService!schedule!f!12/19/2006-10:32:10:: Creating Time based subscription notification for subscription: 2ae5c0ed-9eea-4ca4-8e41-be5cde9f7908
ReportingServicesService!library!f!12/19/2006-10:32:10:: Schedule 9587e9db-b005-4f96-ad18-4afc29207481 execution completed at 12/19/2006 10:32:10 AM.
ReportingServicesService!dbpolling!f!12/19/2006-10:32:10:: EventPolling finished processing item ea730ae6-d1ad-4535-b651-5bdfe4c0339f
ReportingServicesService!dbpolling!c!12/19/2006-10:32:20:: NotificationPolling processing 1 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!13!12/19/2006-10:32:20:: NotificationPolling processing item b216a965-eaa7-4003-b776-4663c19c8d54
ReportingServicesService!library!13!12/19/2006-10:32:21:: i INFO: Call to RenderFirst( '/CM Reports/LIS04' )
ReportingServicesService!library!13!12/19/2006-10:32:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.OverflowException: Arithmetic operation resulted in an overflow. at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyOrSnapshotDate, Byte[]& secDesc)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(ClientRequest session, String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
--- End of inner exception stack trace ---
ReportingServicesService!runningjobs!17!12/19/2006-10:32:37:: i INFO: Adding: 1 running jobs to the database
ReportingServicesService!library!15!12/19/2006-10:32:37:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 1 running jobs, 0 persisted streams

Does anyone have an idea what goes wrong here?

Best regards
Florian

View 1 Replies View Related

Data Driven Subscription Fails To Deliver Reports

Feb 21, 2008

Hi.

I'm using data-driven subscription to deliver reports to users via email.

However every few days or so, some of the reports will fail to get delivered to some of the subscribers. The rpts and subscribers affected are usually not the same.

The log showed the below messages....would really appreciate if anybody can shed light on this! TIA!

ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' )
ReportingServicesService!cache!16!02/21/2008-09:03:09:: i INFO: From cache live: /Daily Movement Reports/FDDlyTopRevoAgt
ReportingServicesService!library!16!02/21/2008-09:03:09:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!dbpolling!4!02/21/2008-09:03:09:: i INFO: NotificationPolling processing item 336709ba-97ce-4e6f-b9d3-09ae26e9f6fb
ReportingServicesService!library!4!02/21/2008-09:03:09:: i INFO: Call to RenderFirst( '/Daily Movement Reports/FDDlyTopRevoAgt' )
ReportingServicesService!library!4!02/21/2008-09:03:09:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.IO.IOException: The process cannot access the file 'C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesRSTempFilesRSFile_bbc8b100-f99e-438f-88bc-bd796b88bc1c' because it is being used by another process.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share)
at Microsoft.ReportingServices.Library.PartitionFileStream..ctor(String path, PartitionManager manager, Boolean deleteOnClose)
at Microsoft.ReportingServices.Library.PartitionManager.GetFileFromPartition(String path)
at Microsoft.ReportingServices.Library.MemoryThenFileStream..ctor(String filename, Int32 threshold, PartitionManager partitionManager)
at Microsoft.ReportingServices.Library.CachedData.GetNewStream()
at Microsoft.ReportingServices.Library.CachedRenderingResult.GetRenderingResult()
at Microsoft.ReportingServices.Library.RSService.RenderAsSnapshot(CatalogItemContext reportContext, Guid reportId, DateTime executionDate, DateTime expirationDate, ClientRequest session, ReportSnapshot snapshotData, String description, Boolean foundInCache, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)




View 1 Replies View Related

Reporting Services :: Adding Group Emails On Subscription On SSRS?

Aug 5, 2015

I am creating a subscription to deliver reports via email on SSRS.  One of the problems I am having is I can't add groups to the To: or Cc: fields for report distribution.  I am able to add individual user email which works fine but it will be a lot of emails to add if I have to go that route. So how do you add groups to report subscriptions?

View 2 Replies View Related

Backup Fails To Local Disk

Nov 6, 2007

Hello,
SQL 2000 backup to C dirve fails with event 17055 Operating system error = 5 access is denied. Creating and running a backup job wizards errors with SQL State 42000, Deveice error or device off line. SQL is running as LocalSystem. The backup destination has every Windows group added with Full Control.
Thanks

View 4 Replies View Related

One Or More Subscriptions Have Been Marked Inactive. Drop And Re-create All Subscriptions For This Node...

May 16, 2007

Greetings,



We periodically get the following message in our three server peer-to-peer transactional replication environment:



"One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error."



What causes a subscription to be marked inactive? What properties or settings can be adjusted to minimize or eliminate this occurrence?



Everthing seems to be running OK and then we get the message. It afflicts the higest change volume publication on our slowest overseas server.



Thanks,

BCB

View 9 Replies View Related

Local SQL Server Instances Not Showing Up On Local Servers Tab Of Management Studio Logon Screen

Oct 2, 2007

We have a 64-bit VM server running SQL Server 2005. The SQL Server on this particular VM server has 6 local instances installed. On the Management Studio logon screen I can type the full name of the local instance and connect to it, however if I press the drop down in the Server name field, choose Browse and select the Local Servers tab there is nothing listed under Database Engines.

Any idea why the 6 local instances don't show up under Database Engines? This is preventing me from installing a vendor application because their installer looks for local SQL Server instances on this server, but if SQL Server won't even show the local instances then the installer doesn't see them either.

Any help is greatly appreciated.

Thanks,
Craig

View 3 Replies View Related

Not Able To Connect To The Local Database With (local) As Server Name

Jun 7, 2006

I am facing a problem in connecting to the local database with server name as (local).

I have installed SQL Server 2005 in my machine. When I try to connect to the SQL server with the server name as SUNILKUMAR I am able to connect but when I try to connect to the same server with the server name as (local) I am not able to connect. SUNILKUMAR is my machine name and SQL server is running locally.

if anyone can help me what is the problem in this case it is highly appriciated.

View 7 Replies View Related

SQL Connection In Vista With Trusted Connection Fails Under Local System Account Until Reboot

Mar 4, 2008

Hi All,

We are using the Windows Task Scheduler as a substitute for the SQL Server Agent, which isn't available in the Express edition. The scheduled task just calls a batch file, which in turn, runs a stored procedure using osql with the -E option for a Trusted Connection.

SQL Server Express has been installed using the defaults, which means the service is running in the "NT AUTHORITYNETWORK SERVICE" account. The scheduled task we create is set to run using the "NT AUTHORITYSYSTEM" account.

Now we find that on Windows Vista (tested using Ultimate Edition) that the scheduled task fails to run the stored procedure until the machine is rebooted the first time after installing SQL Server Express. When I say "fail", I mean that the stored procedure isn't executed. The scheduled task however completes and reports no errors. On Windows XP, we do not run into this problem so I suspect it has something to do with the UAC in Vista?

We further found that after installing SQL Server Express and creating the scheduled task in the "NT AUTHORITYNETWORK SERVICE" account, the scheduled task (and stored procedure) runs fine WITHOUT requiring a reboot.

Can anyone explain why a reboot is needed to get SQL Server Express to run the scheduled task correctly under Windows Vista and the SYSTEM account?

Any help or thoughts greatly appreciated.

View 2 Replies View Related

Package Fails When I Use ODBC Connection (Fails On SQL Server Agent, OK In Visual Studio)

Jun 11, 2007

I did a small package with only one ODBC connection (Merant 3.70 32-Bit Progess). This package runs well in Visual Studio and fails when runs by SQL Server Agent.

Configuration:

SQL Server Agent on a 32Bit server.

The ODBC connection configuration in available on System DSN on this server.

The user of Server Agent have full access (Admin).

Connect Manager Provider: ".Net ProvidersOdbc Data Provider"

SQL Server version: 9.0.3042



Error Message:

Executed as user: TEKCON cadmin. ...ion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 16:50:33 Error: 2007-06-11 16:50:33.62 Code: 0xC0047062 Source: Data Flow Task DataReader Source [1] Description: System.Data.Odbc.OdbcException: ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. ERROR [HYC00] [MERANT][ODBC PROGRESS driver]Optional feature not implemented. ERROR [HY000] [MERANT][ODBC PROGRESS driver]msgOpen: unable to open message file: PROMSGS ERROR [IM006] [MERANT][ODBC PROGRESS driver]Driver's SQLSetConnectAttr failed. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcCon... The package execution fa... The step failed.


I created a .bat file with this instruction and It's run well:

dtexec /f "C:Program FilesMicrosoft SQL Server90DTSPackagesIntegration Services Project estcom.dtsx"
pause

Why it's not running with SQL Server Agent???

View 7 Replies View Related

SQL Server 2005 In Subscriptions

Jun 20, 2006

Does SQL Server 2005 come in any MSDN subscription packs? The content list isn't generally comprehensive and all the subscriptions seem to come with SQL Server 2000.

View 1 Replies View Related

Moving A SQL Server 2000 Database From A Local Drive To Another Local Drive

Jan 31, 2008

Being a very novice SQL Server administrator, I need to ask the experts a question.

How do I go about moving a database from 1 drive to another? The source drive (C is local to the server, but the target drive (E is on a Storage Area Network (SAN), although it is still a local drive for the server. I want to move the database from C: to E:. Can someone provide me with instructions?

Thanks,
Rick

View 4 Replies View Related

Adding Product Of A Subquery To A Subquery Fails?

Jul 6, 2014

I am trying to add the results of both of these queries together:

The purpose of the first query is to find the number of nulls in the TimeZone column.

Query 1:

SELECT COUNT(*) - COUNT (TimeZone)
FROM tablename

The purpose of the second query is to find results in the AAST, AST, etc timezones.

Query 2:

SELECT COUNT (TimeZone)
FROM tablename
WHERE TimeZone NOT IN ('EST', 'MST', 'PST', 'CST')

Note: both queries produce a whole number with no decimals. Ran individually both queries produce accurate results. However, what I would like is one query which produced a single INT by adding both results together. For example, if Query 1 results to 5 and query 2 results to 10, I would like to see a single result of 15 as the output.

What I came up with (from research) is:

SELECT ((SELECT COUNT(*) - COUNT (TimeZone)
FROM tablename) + (SELECT COUNT (TimeZone)
FROM tablename
WHERE TimeZone NOT IN ('EST', 'MST', 'PST', 'CST'))

I get a msq 102, level 15, state 1 error.

I also tried

SELECT ((SELECT COUNT(*) - COUNT (TimeZone)
FROM tablename) + (SELECT COUNT (TimeZone)
FROM tablename
WHERE TimeZone NOT IN ('EST', 'MST', 'PST', 'CST')) as IVR_HI_n_AK_results

but I still get an error. For the exact details see:

[URL]

NOTE: the table in query 1 and query 2 are the same table. I am using T-SQL in SQL Server Management Studio 2008.

View 6 Replies View Related

Report Server Subscriptions - Job Owner

Jul 23, 2005

Hi,I am trying to setup a subscription but I keep running into problems.I setup the subscription fine, I see that it creates a job in SQLServer. It shows a specific domain account as the owner and I can'tfigure out why. The problem is that this account is in a differentdomain and it's having problems authenticating when it runs. I did usethis account for the services and whatnot when I originally set it up,but I've changed the account that SQL Server and SQL Server Agent rununder, but it still uses this account as the owner. The only otherthing I can think of is that the database owner ofSystemCenterReporting is still this account. Is this why it's listingthis account as the owner of the job? Where else could it be?Thanks,Bill

View 2 Replies View Related

Failed To Generate A User Instance Of SQL Server Due To Failure In Retrieving The User's Local Application Data Path. Please Make Sure The User Has A Local User Profile On The Computer. The Connection Will Be Closed

Dec 7, 2006

This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee

View 3 Replies View Related

Server Hang During Drop Merge Subscriptions ....

Jul 24, 2007

does anyone has idea why the server hang when i try to drop merge subscriptions?
any suggestion would be appreciate.
thanks.

View 1 Replies View Related

How To Migrate Data-driven Subscriptions To Different Server

Nov 30, 2007

hi guys,

I have created data-driven subscriptions on top of the existing reports on my development server.
I have same reports on QA's report server but without the DD subscriptions.
Is there an easy way to migrate data-driven subscriptions to QA report server or the only way to do is create each subscription manually?

Thankskev

View 3 Replies View Related

SSRS - Resetting A Subscription After A Subscription Run Failure

Feb 11, 2008



It seems to me that if a scheduled SSRS report subscription fails ( Status Message - An error has occurred during report processing) , that I actually need to delete the subscription and reconfigure it from scratch. The scheduled job doesn't try to run again automatically (say the next Monday on a weekly Monday schedule).

Is there a way to "reset" a failed subscription without have to recreate the entire subscription?

Thank you
Devon Kyle

View 5 Replies View Related

Existing Subscription Already Contains Table Included In The New Subscription

Sep 26, 2007







28638


SSCE_M_DUPLICATETABLE


Existing subscription already contains table included in the new subscription.


What are the possible causes of this merge replication error?
Could it be caused by a SQL Server Compact Edition User trying to sync their .sdf file after their subscription has already expired on the SQL Server?

Would you expect to see a different message if a SQL Server Compact Edition user tried to sync a subscriber database (.sdf file) with merge replication if it's been longer than the subscription retention period since their last sync?

View 6 Replies View Related

Transactional Publication With Updatable Subscriptions In SQL Server 2005, SvPk 2

Jul 31, 2007


Subscription to "Transactional Publication with Updateable Subscriptions" works only one way. Changes take effect on subscriber, but the subcriber is unable to update data on publisher.

I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.' All agents are running at the Distributor (Publishing Server.)

The subscriber is unable to connect to the Distributor using the SQL Server login.

Following is the error message I get:


Creating Subscription(s)...

- Creating subscription for 'SQL3' (Warning)



Messages

Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

MSDTC on server 'SQL3' is unavailable.
Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476


Please suggest procedure to end this dilemma. The link has no info available.

View 2 Replies View Related

HOW To Pull Merge Subscriptions In SQL Server 2000 Using Stored Procedures ??? (URGENT)

Dec 15, 2005

I've successfully carried out pull subscription using Wizard in SQL server 2000.

But NOW its the time to deploy the project & I've to do it programatically........

i tried to use the default stored procedures like "sp_addmergepullsubscription ", "sp_addmergepullsubscription_agent  ", "sp_reinitmergepullsubscription ", with respective parameters.

Then using replmerge.exe i tried to execute the batch file But could not succeed......

Can anyone guide me from the Basics ??? (i knw the Replication Architecture its heirarchy....but have NO idea of performing it Programatically......!!!!!!!!)

by BASICS, i mean......how should i execute the resp. stored procedures with what parametes & the order i should follow in order to successfully pull a merge subscription in SQL server 2000.

 

if a Sample code is mentioned as example, would be better for me to understand....

 

Thanking all of you in anticipation...........

 

Mandar

 

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved