Wednesday, April 3, 2013

[SQL 2012] SQL Server 2012 - SSIS issue

[SQL 2012] SQL Server 2012 - SSIS issue

SQL Server 2012 - SSIS issue

Posted: 02 Apr 2013 12:02 PM PDT

HiWe installed SQL Server 2012 SP1 on Windows 2008R2(VM) and have setup DNS aliases for our servers.I am an admin on the Windows server with SA access to the SQL server. [u]Current Issues:[b][/b][/u]I am able to connect to both Database Engine and Integration services using the Server Name.I am able to connect to the Database Engine but not to the Integration Services using the Alias.I have tried adding user explicitly to the Microsoft SQL Server Integration Services 11.0 on DCOM Config and restarted SSIS.Added DisableLoopbackCheck, modified to 1 and have rebooted the server, still the error persists. [b]Below is the error message: [u][/u][/b]Cannot connect to <AliasName>.===================================Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)------------------------------For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&LinkId=20476------------------------------Program Location: at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()===================================Connecting to the Integration Services service on the computer "AliasName" failed with the following error: "Access is denied."By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.------------------------------For help, click: http://go.microsoft.com/fwlink/?LinkId=220763------------------------------Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion) at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData() at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.Process(Object connectionInfo, Request request)===================================Connecting to the Integration Services service on the computer "AliasName" failed with the following error: "Access is denied."By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service.------------------------------Program Location: at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String bstrMachineName, String& serverVersion) at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String server, String& serverVersion)Any insight would be helpful.

Sql server 2012 performance benchmark

Posted: 02 Oct 2012 06:36 PM PDT

Hi all,I'm looking for Sql Server 2012 new features about performance, I read this (http://www.sqlservercentral.com/blogs/discussionofsqlserver/2012/04/19/sql-server-2012-performance-test-gap-detection/) useful article and what's new whitepaper and also I found this test :http://www.tpc.org/tpce/results/tpce_perf_results.aspDoes anyone have benchmark about performance test result in Sql server 2012 vs 2008 R2 ?

Temp DB DQL server isnt seeing all data files

Posted: 02 Apr 2013 03:35 AM PDT

Our Temp DB isn't seeing all all the data files we have a total of 8. SQL server is only seeing 2 after restart last night.Any help would be appreciated.Thanks

abrupt SQL Server restarts

Posted: 26 Feb 2013 08:18 PM PST

I have recently installed a SQL Server 2012 instance and have deployed a few databases on it.However, the server is restaring abruptly and nothing is clear from SQL Server logs.I see some wierd messages in event viewer like the below ones:Product: SQL Server 2012 Database Engine Services - Update '{402234FB3-7241-4B6D-83A4-92323BCS3DC8}' could not be installed. Error code 1642. Windows Installer can create logs to help troubleshoot issues with installing software packages. Use the following link for instructions on turning on logging support: http://go.microsoft.com/fwlink/?LinkId=23127Windows detected your registry file is still in use by other applications or services. The file will be unloaded now. The applications or services that hold your registry file may not function properly afterwards. DETAIL - 2 user registry handles leaked from \Registry\User\S-1-5-80-1651743498233-604422593-37299121234-4324324703093-311232196992:Process 6056 (\Device\HarddiskVolume3\Windows\System32\conhost.exe) has opened key \REGISTRY\USER\S-1-5-80-16517234234233-12334442-3729906164-4251703093-3124596992\Control Panel\InternationalProcess 6044 (\Device\HarddiskVolume4\Program Files\Microsoft SQL Server\MSSQL11.DEV\MSSQL\Binn\fdhost.exe) has opened key \REGISTRY\USER\S-1-5-80-1651231233-6021312593-31232139906164-42556757573093-3124596992\Control Panel\InternationalWhats the reason for the SQL restart? Would a Service pack upgrade help?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog