Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.








Sponsored Links:

Related Messages:
User Profile And "SQL Server Registration Properties"
Dear All,


I have created one user with low access to my database.
But when I run "SQL Enterprise Manager", with this login, I can switch to "Windows Nt authentication" as user from "Edit SQL Registration Properties".
So, from this new connection,I have all rigth.

Hence, can you help me to avoid this permission to choose "Edit SQL Registration Properties" for a user who has a low profile.

Souleymane.

View Replies !   View Related
“The Attempt To Connect To The Report Server Failed. Check Your Connection Information And That The Report Server Is A Compati
Hi,

We are trying to implement two SQL server Reporting Services instances on the same machine, so we can have a test environment and a development environment. We already have one instance of Reporting Services which was installed at the same time than the SQL server 2005 database engine instance. Everything works fine. So we went ahead and installed a second instance of reporting services on the same machine.

The following components/software are installed on the machine:
- DATABASE ENGINE INSTANCE EDITION: SQL server 2005 developer edition
- REPORTINS SERVICES INSTANCE: Developer edition
- ASP.net 2.0
- IIS 6.0

The following steps were taken in order to add a second instance of reporting services

1- Installed the second instance of reporting services with option to not configure Reporting Services checked. (successful )
2- Created extra IP address 192.168.xxx.xxx. on the server (successful)
3- Used IIS to create an additional website and selected the IP address (successful)
4- Configured the Reporting Services using Reporting Services Configuration (created virtual directory for report manager and report server).
5- Modified the RSReportServer.config file.
old value: <UrlRoot>http://<servername>/reportserver</UrlRoot>
new value: <UrlRoot>http://192.168.xxx.xxx/reportserver</UrlRoot>
6- Modified the RSWebApplication.config file
old value: <ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
new value:
<ReportServerUrl>http://192.168.xxx.xxx/reportserver</ReportServerUrl>
<ReportServerVirtualDirectory></ReportServerVirtualDirectory>

When accessing the report server at http://site.symedia.com/reportserver we get the following error message:

Error message: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.?

The following is the content of the ReportServerWebbapp log file:
<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Standard Time</TimeZone>
<Path>E:SQL2005MSSQL.2Reporting ServicesLogFilesReportServerWebApp__02_02_2007_09_48_06.log</Path>
<SystemName>CVMSERVER2</SystemName>
<OSName>Microsoft Windows NT 5.0.2195 Service Pack 4</OSName>
<OSVersion>5.0.2195.262144</OSVersion>
</Header>
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!1!2/2/2007-09:48:08:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!ui!1!2/2/2007-09:48:35:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
aspnet_wp!ui!1!2/2/2007-09:48:36:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Object Not Found.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!2/2/2007-09:48:38:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
aspnet_wp!ui!1!2/2/2007-09:53:04:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
aspnet_wp!ui!1!2/2/2007-09:53:04:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Object Not Found.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!1!2/2/2007-09:53:05:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
aspnet_wp!ui!5!2/2/2007-10:08:40:: e ERROR: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.
aspnet_wp!ui!5!2/2/2007-10:08:40:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.SqlServer.ReportingServices2005.RSConnection+MissingEndpointException: The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. ---> System.Net.WebException: The request failed with HTTP status 404: Object Not Found.

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()

at Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

--- End of inner exception stack trace ---

at Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException.ThrowIfEndpointMissing(WebException e)

at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
aspnet_wp!ui!5!2/2/2007-10:08:41:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
aspnet_wp!configmanager!5!2/2/2007-10:37:18:: i INFO: Handling File Changes
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:18:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
aspnet_wp!configmanager!5!2/2/2007-10:37:19:: i INFO: Handling File Changes
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!5!2/2/2007-10:37:19:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
--------------------------------------------------------------------------------------------------------------------------------------------------
We tried reinstalling SQL server 2005, instance of reporting services, still same issue. Please assist, any help in installing 2 instances of reporting services on the same machine is appreciated. Thank you!

Chi

View Replies !   View Related
Server Registration Failed
Hello,

I'm not sure what the Admin installed on my Windows 98 computer; and he is on vacation. I tried registering a server, but I get the following error message:
SQL Server registration failed because of the connection failure. General network error. ConnetionOpen (connect()). I checked the utilities and the default network library is TCP/IP. Any suggestions?

Thanks,
Samantha

The log file shows the following:

10:55:00 Begin Setup
10:55:00 7.00.623
10:55:00 Mode=Normal
10:55:00 ModeType=NORMAL
10:55:01 ValueFTS returned: 1
10:55:01 ValuePID returned: 1
10:55:01 ValueLic returned: 1
10:55:01 GetDefinitionEx returned: 0, Extended: 0xf000000
10:55:01 System: Windows 98
10:55:01 SQL Server ProductType: Developer Edition [0x2]
10:55:01 Begin Action: SetupInitialize
10:55:01 End Action SetupInitialize
10:55:02 Fixed install: 0
10:55:02 Begin Action: CheckRequirements
10:55:02 Platform ID: 0xf0000
10:55:02 Version: 4.10.67766446
10:55:02 DCOM95 has been detected.
10:55:02 File Version - C:WINDOWSSYSTEMshdocvw.dll: 5.0.2919.6307
10:55:02 ComputerName: Samantha
10:55:02 User Name: Samantha
10:55:02 Domain: Samantha
10:55:02 OS Language: 0x409
10:55:02 End Action CheckRequirements
10:55:02 Begin Action: Detection
10:55:02 End Action Detection
10:55:02 Begin Action: ODBCLocked
10:55:02 C:WINDOWSTEMP\_ISTMP0.DIRodbcinst.exe -IsLocked -Silent 1 -SourceDir F:X86ODBC -LogFile C:WINDOWSsqlodbci.log
10:55:03 Process Exit Code: (0)
10:55:03 End Action ODBCLocked
10:55:03 This combination of Package and Operating System allows a client install only.
10:55:20 The Developer Edition server component cannot be installed on Windows 98 using this CD. Only client components will be available for installation.

10:55:20 Reading SoftwareMicrosoftWindowsCurrentVersionCommonFilesD ir ...
10:55:20 CommonFilesDir=C:Program FilesCommon Files
10:55:20 Windows Directory=C:WINDOWS10:55:20 Begin Action: ShowDialogs
10:55:20 Begin Action: DialogShowSdWelcome
10:55:21 End Action DialogShowSdWelcome
10:55:21 Begin Action: DialogShowSdLicense
10:55:23 End Action DialogShowSdLicense
10:55:23 Begin Action: DialogShowSdRegisterUserEx
10:55:24 End Action DialogShowSdRegisterUserEx
10:55:24 Begin Action: DialogShowCdKey
10:55:24 End Action DialogShowCdKey
10:55:24 Begin Action: DialogShowPID
10:55:24 End Action DialogShowPID
10:55:24 Begin Action: DialogShowSdSetupType
10:55:29 [SetupTypeSQL]
10:55:29 szDir=C:MSSQL7
10:55:29 Result=303
10:55:29 szDataDir=C:MSSQL7
10:55:29 End Action DialogShowSdSetupType
10:55:29 Begin Action: DialogShowSdComponentMult
10:55:29 basesys=0, baseinst=0,basedata=0
10:55:48 SQL program folder: C:MSSQL7
10:55:48 SQL data folder: C:MSSQL7
10:55:48 Windows system folder: C:WINDOWSSYSTEM10:55:48 Prog req: 46703, Data req: 0, Sys req: 58434
10:55:48 Prog avail: 2147155, Data avail: 2147155, Sys avail: 2147155
10:55:48 Prog req vs. avail, 105137, 2147155
10:55:48 Data req vs. avail, 0, 2147155
10:55:48 Sys req vs. avail, 58434, 2147155
10:55:48 DisplaySystemPreReq
10:55:48 [SQLComponentMult]
10:55:48 Component=
10:55:48 Result=1
10:55:48 End Action DialogShowSdComponentMult
10:55:48 Begin Action: DialogShowSdStartCopy
10:55:49 End Action DialogShowSdStartCopy
10:55:49 Begin Action: DlgCPLLicense
10:55:49 End Action DlgCPLLicense
10:55:49 End Action ShowDialogs
10:55:49 Begin Action ProcessBeforeDataMove:
10:55:49 DeinstallStart returned (C:MSSQL7): 0
10:55:49 End Action ProcessBeforeDataMove:
10:55:49 Begin Action ProcessComponentSelection:
10:55:49 End Action ProcessComponentSelection
10:55:49 Begin Action LogSelectedComponents:
10:55:49 MgtTool
10:55:49 MgtToolSEM
10:55:49 MgtToolSEMHTML
10:55:49 MgtToolSEMMSD98
10:55:49 MgtToolSEMMSD98SYS
10:55:49 MgtToolSEMMSD98Res
10:55:49 MgtToolSEMMSD98Hlp
10:55:49 MgtToolSEMHelp
10:55:49 MgtToolSEMSEMSys
10:55:49 MgtToolSEMRes1033
10:55:49 MgtToolSEMResIntl
10:55:49 MgtToolSEMMSD98RsI
10:55:49 MgtToolProfiler
10:55:49 MgtToolProfilerHelp
10:55:49 MgtToolProfilerRes1033
10:55:49 MgtToolProfilerResIntl
10:55:49 MgtToolQryanlz
10:55:49 MgtToolQryanlzHelp
10:55:49 MgtToolQryanlzRes1033
10:55:49 MgtToolQryanlzResIntl
10:55:49 MgtToolDTCCLi
10:55:49 MgtToolWzcnflct
10:55:49 MgtToolWzcnflctWzcnsys
10:55:49 MgtToolWzcnflctWzcnHlp
10:55:49 MgtToolUtilSys
10:55:49 MgtToolUtilBinn
10:55:49 Connect
10:55:49 ConnectConnSys
10:55:49 ConnectConn9x
10:55:49 ConnectConnNT
10:55:49 Books
10:55:49 BooksBookso
10:55:49 BooksBooksCD
10:55:49 DevTools
10:55:49 DevToolsHeaders and Libraries
10:55:49 DevToolsHeaders and LibrariesInclude
10:55:49 DevToolsHeaders and LibrariesLibx86
10:55:49 DevToolsHeaders and LibrariesLibAlpha
10:55:49 DevToolsHeaders and LibrariesESQLC
10:55:49 DevToolsMDAC SDK
10:55:49 DevToolsVDI
10:55:49 DevToolsVDIInc
10:55:49 DevToolsVDISamples
10:55:49 DevToolsDbg Int
10:55:49 DevToolsDbg IntDbg Int Common
10:55:49 DevToolsDbg IntEXE
10:55:49 Samples
10:55:49 SamplesADO
10:55:49 SamplesDBLIB
10:55:49 SamplesDTS
10:55:49 SamplesESQLC
10:55:49 SamplesMSDTC
10:55:49 SamplesODBC
10:55:49 SamplesODS
10:55:49 SamplesOLEAut
10:55:49 SamplesRepl
10:55:49 SamplesSQLDMO
10:55:49 SamplesSQLNS
10:55:49 Core
10:55:49 CoreSys
10:55:49 ODBC
10:55:49 OLEDB
10:55:49 Repostry
10:55:49 RepstSys
10:55:49 CoreMisc
10:55:49 Monarch
10:55:49 Jet
10:55:49 NetCore
10:55:49 NetExt
10:55:49 SFExt
10:55:49 ReplExt
10:55:49 Core1033
10:55:49 CoreIntl
10:55:49 CrMi1033
10:55:49 CrMiIntl
10:55:49 Monr1033
10:55:49 MonrIntl
10:55:49 SFEx1033
10:55:49 SFExIntl
10:55:49 RpEx1033
10:55:49 RpExIntl
10:55:49 SysCore
10:55:49 VOLEDB
10:55:49 VODBC
10:55:49 MiscCore
10:55:49 MCHlp
10:55:49 MC1033
10:55:49 MCIntl
10:55:49 CnctBinn
10:55:49 CrRepCom
10:55:49 {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
10:55:49 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:55:49 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:55:49 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:55:49 End Action LogSelectedComponents
10:55:49 Begin Action MoveFileData:
10:56:31 End Action MoveFileData
10:56:31 Begin Action ProcessAfterDataMove:
10:56:31 DeinstallSetReference (C:MSSQL7sqlservr.exe) returned: 0
10:56:31 End Action ProcessAfterDataMove
10:56:31 Begin Action InstallPkgs:
10:56:31 Setup is installing Microsoft Data Access Components (MDAC) ...
10:56:31 F:x86Othermdac_typ.exe /q:a /c:"setup.exe /qtn"
10:56:59 Process Exit Code: (3010)
10:56:59 Setup is installing Microsoft Management Console (MMC) ...
10:56:59 F:x86Otherinstmmc.exe /Q
10:57:20 Process Exit Code: (0)
10:57:20 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
10:57:20 F:x86Otherdtcsetup.exe /q:a /r:n
10:57:22 Process Exit Code: (0)
10:57:22 Setup is installing HTML Help ...
10:57:24 HTML Help installer exit code: 0
10:57:24 End Action InstallPkgs
10:57:24 SetNewPath returned: 3010
10:57:24 Path successfully updated.
10:57:24 Begin Action SelfRegister
10:57:30 Return code: 0
10:57:30 End Action SelfRegister
10:57:30 Begin Action SetupRegistry:
10:57:30 End Action SetupRegistry
10:57:30 Begin Action PostSetupRegistry:
10:57:30 C:MSSQL7BINNdcomscm.exe /RegServer
10:57:30 Process Exit Code: (0)
10:57:30 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1sqldbreg.exe -RegServer
10:57:30 Process Exit Code: (-2147312566) Error loading type library/DLL.

10:57:30 C:PROGRA~1COMMON~1MICROS~1DATABA~1WZCNFLCT.EXE /RegServer
10:57:30 Process Exit Code: (0)
10:57:30 End Action PostSetupRegistry
10:57:30 Begin Action SetupFolders:
10:57:31 Microsoft SQL Server 7.0 Folder refreshed.
10:57:31 End Action SetupFolders
10:57:31 Action CleanUpInstall:
10:57:31 Uninstall command: C:WINDOWSIsUninst.exe -fC:MSSQL7Uninst.isu -c"C:MSSQL7sqlsun.dll" -msql70.mif
10:57:31 SetTracking: {E07FDDA8-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDA9-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAA-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAB-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAC-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAD-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAF-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDAE-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB0-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB1-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB2-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB3-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB4-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB5-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB6-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB7-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB8-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDB9-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBA-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBB-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBD-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDC8-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
10:57:31 SetTracking: {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
10:57:31 Installation Succeeded

View Replies !   View Related
Facing Error Of Connection Failed , Check Sqlservr
Hi i have installed sql server 2000 on xp window and facing error of connection failed, check sql server registration what it mean pleas guide me.


webmaster http://www.GlobalGuideLine.com

View Replies !   View Related
Maitenace Plan Check Database Integrity Task Fails With Failed:(0) Alter Failed For Server 'xyz'


Hi,



I am administering several SQL Servers running SQL Server 2005 SP2 Build 3042.
I have a common maintenance plan that runs on each of the servers. The maintenance plan runs
fine on all the servers except for one. On the one server the Database Integrity check fails with the following error:


Check Database integrity on Local server connection
Databases: <list of databases>
Include indexes
Task start: 2008-02-21T00:05:42.
Task end: 2008-02-21T00:05:46.
Failed0) Alter failed for Server XYZ

I created a test maintenance plan to just do the integrity check and selected one database only and this also failed with the same error message. I ran this test maintenance plan and configured it for each of the databases in question and it failed each time.
If I run the DBCC manually against the databases they all report fine.


I read some of the post that talked about the Allow Updates? being set incorrectly but that does not apply to my problem since my configured and run values are set to 0.

Does anyone know what the problem could be?



View Replies !   View Related
How Check Database Properties?
Hello, Everyone:

There are some databases in a SQL Server. How to check,
1. User database numbers
2. Backup plan
3. Configuration
4. User database size
5. Nightly process

Thanks a lot

ZYT

View Replies !   View Related
Sql Connection Failed Because Of Connection Failure Login Failed For User 'SW8/Guest
Sir i am trying to connect sql from my LAN to my networked computers but whenever i tried to register it through Enterprise manager i get following "SQL Server registration failed because of the conection failure displayed below.Do you wish to Register anyway? Login failed for user 'SW17/Guest'

where SW17/ is my another computer name...
i have checked tcp and named pipes
and confirm username for sql authentication too
please help me as i being late submit my project

View Replies !   View Related
Check Connection From C# Application To SQL Server.
Hey anyone,
I got a problem to check a connection whether it is established or not from my C# Application to SQL Server.
I am developing my application which can run in 2 modes:
1. Online: There must be a connection to SQL Server to get new data updates.
2. Offline: I dont need a connection to SQL Server. I set a timer to tick every 5 seconds and it will check the connection with SQL Server and my problem here: (this is my code)1 public static bool checkConnection()
2 {
3 SqlConnection conn = new SqlConnection("mydatasource");
4 try
5 {
6 conn.Open();
7 return true;
8 }
9 catch (Exception ex) { return false; }
10 }

 Yes, it works but my application seems to wait about >3 seconds to get the return "False"; I tried to add "Connect TimeOut=1" in my Connection String, but the problem is still there.
I dont know whether there is a faster way to check the connection to SQL server which is established or not.
Thank you very much,
Joesy

View Replies !   View Related
Connection Pool - Does Not Check For Server Status.
hi All,Connection Pool - Does not check for Server Status.Here is the scenario :1) SQL Server is up2) Create a connection pool for a particular connection string byrepeatedly executing the same query in .NET ( using SqlConnection andSqlCommand classes )This involves following steps- Open a connection- Execute a Query- Close the connection3) STOP the SQL Server.4) Run the same query again.We notice that- Opening a Connection goes through fine. If the pool was notformed ( if we are opening the connection for the first time ), thiswould have FAILED by throwing SQL Server not found execption.- Execute Query , Throws an Exception - General Network Error,Error Number 11.5) Now RE-START the SQL Server.6) Run the same query again.We notice that- Opening a Connection goes through fine.BUT, - Execute Query , Throws an Exception - General NetworkError, Error Number 11.An Exception is thrown even if SQL Server is UP!Once the Server is up, we want the connection to succeed.Now, How do we handle this scenario?How do we invalidate the Connection Pool?thanks,HiChetu

View Replies !   View Related
Check Your Connection Information And That The Report Server Is A Compatible Version
while connecting to Reporting Services from Mangament Studio getting following error

"The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.SqlServer.Management.UI.RSClient)"

any ideas???


View Replies !   View Related
Maint Plan - Failed To Acquire Connection &&"Local Server Connection&&"
I created a single step plan that does integrity checks. It fails with the error below. I created a new connection using our clusters virtual sql name.


Executed as user: ACCTCOMsqlagent. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:10:06 PM Error: 2008-02-15 13:10:49.02 Code: 0xC00291EC Source: {0CF32F3D-A8D1-492A-9C0F-AD4E0FC67D14} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-02-15 13:10:49.02 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2008-02-15 13:11:31.26 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.

The agent and db are running under domain accounts and the job is owned by sa.

Thanks for your help.




View Replies !   View Related
Connection To SQL Server Express Failed
hello
Ive added a simple grid view and used the database option to test connection to sql server express.I am connecting with  windows authentication
The error page states
"Cannot open database "Northwind" requested by the login. The login failed.Login failed for user 'CENTRINOASPNET'. "
Here is a copy of my connection string in the webconfig file
<connectionStrings>  <add name="NorthwindConnectionString" connectionString="Data Source=centrinosqlexpress;Initial Catalog=Northwind;Integrated Security=True" providerName="System.Data.SqlClient"/></connectionStrings>
Can anybody help solve my problem?
Gino

View Replies !   View Related
Sql Server Connection Failed Error
Dear Gurus,

I have installed sql server 2000 on computer and tried to import the data from the previous computer which was attached to one domain.Now we are using this sql server in another remote site where the domain name is same but users are different.My user was already there in previous domain and also i created in new domain its working fine but when i tried for other new users its not getting connecting and giving the following error while connecting thru odbc.

Conn Faild.
SQL State : 28000
SQL Server Error : 18452
[Microsoft][odbc Sql Server Driver][SQL Server] Login faild for user '(null)'.Reason : Not associated with a trusted SQL Server connection.

Please guid me to resolve the above problems.

View Replies !   View Related
Failed OLEDB Connection: Cannot Aquire Connection From Connection Manager
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.

Thanks,

John T

View Replies !   View Related
Getting OLE DB Connection Properties In Script
I have SSIS packages that send success/failure email upon completion, and I'd like to add a note that identifies the server and database used. I can certainly add variables to the packages and use them when constructing the email, but I'd prefer to get the information directly from the OLE DB connection itself. Is there a way to access the connection string from within a control-flowVB script task? Furthermore, can I get the data source and initial catalog from that connection string, or do I need to parse it myself?

Thanks!

Phil

View Replies !   View Related
Need Recommendations For Some Connection Properties
Howdy folks,

I'm trying to get a better idea of how I should set some of the SSCE connection properties. I will be deploying the application on a WinCE5 board with a 4G flash storage card and 512MB RAM. The application must run 24/7 with a medium amount of traffic. At any given point I expect up to 3 connections to the same database. I'd really like to keep performance high without risking any database corruption issues. As such, I need to make sure my connection properties are optimized.

I read from Joao's article that setting DBPROP_SSCE_MAXBUFFERSIZE = 1024 gave a considerable performance increase, while anything higher gave diminishing returns. Is this for a certain amount of RAM, or is it uncorrelated to RAM size?

What's the best practice for specifying DBPROP_SSCE_TEMPFILE_DIRECTORY and DBPROP_SSCE_TEMPFILE_MAX_SIZE? Is it possible in WinCE5 to directly put it in RAM? How big do these temp files get?

I've read of some bad experiences with autoshrink. Are there any reasons not to set DBPROP_SSCE_AUTO_SHRINK_THRESHOLD to 100 if the database will be compacted regularly?

Any other advice for the more obscure settings such as DBPROP_SSCE_FLUSH_INTERVAL or all the lock settings?

Thanks a bunch!

View Replies !   View Related
Fix For Transmission_status Message Connection Handshake Failed [...] The Logon Attempt Failed
Full message:

Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 66



Under these conditions, setting trustworthy on on the sending and receiving databases will solve this issue

1) Communicating between multiple instances

2) Using Kerberos security (NT Authentication, i.e. not certificates)

View Replies !   View Related
Notification Services Failed To Open A Connection To SQL Server.Server Name:ABC(Microsoft.SqlServer.NotificationServices)


I am getting the above error when I try to create Notificatioin services new Instance.

Additional Information is

Failed to connect to server ABC(Microsoft.SqlServer.ConnectionInfo)

An error occured while establishing connection to the server.When connecting to SQL Server 2005,this failure may be caused by the fact that under default settingsSQLServer deoes not allow remote connections.(Provider : Named Pipes Provider, error 40 -could not open connection to SQL Server)(Microsoft SQL Server error:53)

Please help me I am new to SQL Server 2005.I can'table to proceed.



















View Replies !   View Related
Connection To SQL Server Failed ... *important, Need Urgent Help*
Hello everyone, I've been searching the forum for three hours now and I couldn't find anything that helped me.
First I thought I didn't install the SQL server properly, I now found out that it is installed properly.
I am using VWD 2008 Express Edition. I could access the aspnetdb in the SQLExpress server. I could modify entries and create new databases. So the server obviously works.
 
Problem -> I cannot access the WebSiteAdmin modul ... for no apparent reason, it always gives me a timeout.
 
If you restart the tool by clicking the asp.net icon in the traylist stop it, then retry over the button in the VWD, then I did that a dozen times. I restart the tool and then access it five seconds later, no matter what I do I always get a time out. 
 
Any help is appreciated, I can't solve this and I really really need it. Thanks a lot in advance.

View Replies !   View Related
Login Failed - Not Associated With A Trusted SQL Server Connection
I'm getting the following error:  login failed for user '(null)', Reason: Not associated with a trusted SQL Server connection.Here's my connection string : <add key="ConnectionString" value="Persist Security Info=True; Trusted_Connection=Yes; Integrated Security=SSPI; Application Name=CCMIS; Initial Catalog=CCMIS; Data Source=NameofServer; Network library=dbmssocn; Packet Size=4096;" /> I'm running a windows application that calls a web service to update a SQL database.  The application is using a windows group account and the between the web service & the SQL server it's using a domain account.  My user-id is a member of the windows group account.  I'm not sure of the relationship between the domain account and the group account or if there is one?  I'm new to this permissions stuff.  The DBA tells me nothing has changed on the SQL side and I haven't done anything to the application (which was working yesterday).  Any ideas?  

View Replies !   View Related
SQL Server Login Failed - Not A Trusted Connection
I am trying to login to my SQL Server database using this:

conParks = New SqlConnection("Server=localhost;uid=Brian;pwd=abccba;database=Test")
conParks.Open()

The error I get is

Login failed for user 'Brian. Reason: Not associated with a trusted SQL Server connection.

Anyone know what I must change?

Thanks,

BB

View Replies !   View Related
Connection Failed - ODBC From Remote SQL SERVER
hello,
im trying to create an ODBC data source from a SQL SERVER 2005 database located in a remoted pc.
Client----------->PC1 : win 2000 sp4, not sql server
Remote server--->PC2 : win 2000 sp4, sql server 2005 express

From the Command Prompt, im typing "ping PC2" successfully.
After, in the ODBC datasource administrator-->System DNS tab, i choose "sql server" as a new data source , and in the server box , i'm typing PC2/SQLEXPRESS.

In the next steps, im typing the user-passwords.
The error :
connection failed
...
[microsoft][odbc sql server driver][named pipes]ConnectionOpen(CreateFile()).
Connection failed:
SQLState: '08001'
..
Client unable to establish connection

What goes wrong?
I follow the same steps locally, and everything is OK.

Sorry for my bad english:cool:

View Replies !   View Related
Check DB Failed.
Hi

I am a SAP Basis Administrator. One of the job has failed miserably that deals with the MSSQL database.

The error message is been pasted below:

Executed as user: NT AUTHORITYSYSTEM. ...ile: C:Program FilesMicrosoft SQL ServerMSSQLCCMS_CHEC
K_DB_HIST_2007.txt [SQLSTATE 01000] (Message 50000
) Table error: Object ID 0, index ID 0, page (1:2
881160). Test (m_headerVersion == HEADER_7_0) fail
ed. Values are 0 and 1. [SQLSTATE 42000] (Error 89
39) Table error: Object ID 0, index ID 0, page (1
:2881160). Test ((m_type >=DATA_PAGE && m_type <=
UNDOFILE_HEADER_PAGE) (m_type == UNKNOWN_PAGE &
& level == BASIC_HEADER)) failed. Values are 0 and
101. [SQLSTATE 42000] (Error 8939) Table error:
Object ID 0, index ID 0, page (1:2881160). Test (m
_freeData >= PAGEHEADSIZE && m_freeData <= (UINT)P
AGESIZE - m_slotCnt * sizeof (Slot)) failed. Value
s are 0 and 8192. [SQLSTATE 42000] (Error 8939) T
able error: Object ID 0, index ID 0, page ID (1:28
81161). The PageId in the page header = (0:0). [SQ
LSTATE 42000] (Error 8909) Table error: Object ID
0, index ID 0, page ID (1:2881162). The PageId in
the page header = (0:0). [SQLSTATE 42000] (Error
8... The step failed.

Please let me know how to rectify the error.



Sathish

View Replies !   View Related
Dynamically Changing The Connection Properties
I want to transfer data from one server to another by using SSIS. i want the connection string to be dynamic and also according to the some other variable, the transforming data is changing.

Could you provide me the solution thet how i am able to change my connetction string dynamically and the other variable too.

i am using VS 2003 as front end and SQL server 2005 as a backhand.

Due to VS.NET 2003 i am able to create DTS packages but i have to migrate it and then anly i am able to use it in JOB in SQL server agent of SQL server 2005.

is that any code or any stored procedurefrom which i am able to migrate DTS packages to SSIS packages.

Thank you



View Replies !   View Related
Expressions On The Properties Of A File Connection


I used an expression for the connection string of a File Connection.

I evaluted the expression and verified that it was correct.

I found that the package ran successfully (interactively orscheduled by SQL Agent) but the No file was ever created.



However if I removed the expression and hardcoded the Connection String, the package ran successfully (interactively orscheduled by SQL Agent) and the file would be created and log entries would appear.



Has anyone experienced this behaviour with SQL 2005 sp1.



Thanks













View Replies !   View Related
Failed To Acquire Connection / The AcquireConnection Method Failed
I am running the Sept CTP.  I have created a SSIS package that pulls data from a text file and inserts into a database.  When I run the package on the DB server it runs fine.  I have moved the package the the web server (we are attempting to kick off the package from a web site) and we get connections errors. We are running the package using dtexec from the command line.

View Replies !   View Related
Connection From XP SP2 To Windows 2003 R2 With SQL Server 2005 Failed
I cannot make named pipe connection with client by ODBC DSA.
Here is information. Refering to http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1.
[1] Client side:
1. What is the connection string in you app or DSN? (please specify) ODBC \[SERVER_NAME]pipesqlguery
2. If client fails to connect, what is the client error messages? (please specify) Connection failed: SQLState: 01000 SQL ServerError: 1326 [Microsoft][ODBC SQL Server Driver][Named Pipes]connectionOpen (Connect()) Connection failed: SQLState: 08001 SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
3. Is the client remote or local to the SQL server machine? [Remote | Local]
4. Can you ping your server? [YES | NO ]
In cmd.exe console, type ping -a <server_name>?.
5. Can you telnet to your SQL Server? [YES | NO, please specify the error message ]
In cmd.exe console, type telnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+[ to bring up telnet prompt and type quit? <enter>.
6. What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other ODBC (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify).
7. Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup)
8. What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes].
9. Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. You can use cliconfg.exe (SS 2000) or SQL Server Configuration Manager (SS 2005) to configure the alias. [NO]
10. Do you select force encryption on server and/or client? [NO]


I was able to connect with TCP/IP settings.
[2] Server side:
1. What is the MS SQL version? [SQL Server 2005]
2. What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)].
3. What is the SQL Server Protocol enabled? [Shared Memory | TCPIP | Named Pipes ]. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
4. Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG?
5. If SQL Server is a named instance, is the SQL browser enabled? [YES | NO]
6. What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account]
7. Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable | not enabled]
8. Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance.[YES | NO | not applicable | not enabled]


I could connect locally with named pipes.
Do I have to make some file shares manually?
[2a] Tool Used to Connect
What tool or Application are you using to connect to SQL Server (eg: Visual Studio, SQL ServerManagement Studio, SQLCmd.exe, OSQL, etc) and especiallythe version of SQL Server (Express, Workgroup, Standard, Enterprise, Developer)
[3] Platform:
1. What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ].
1. Server [Windows Server 2003 R2]
2. Client [Windows XP SP2]
2. Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify) NO].


[4] Misc:
1. If you have certificate configuration issue: Please use certutil.exe v store my? to dump certificate specific info and post it in your question. [NO]

View Replies !   View Related
Login Failed, User Is Not Associated With A Trusted SQL Server Connection
I set up SQL Express and Visual Studio Team System for the first time yesterday. I created a web service (on my localhost IIS) and added anMDF file to my App_Data folder. I added a table with five fields. I'm trying to connect to the database in my web service, but when my web service gets to the connection line it returns the error

System.Data.SqlClient.SqlException: Login failed for user ''. The user is not associated with a trusted SQL Server connection.

When I add in my domain name andpassword to the connection string I get the error

System.Data.SqlClient.SqlException: Login failed for user 'redmonddanmor'. The user is not associated with a trusted SQL Server connection.

I've queried these SQL forums, and the advice is usually "add the user to the trusted users" or "changed to mixed mode authentication", but none of the posts I foundspecified HOW exactly to do either. When I launch SQL Server Connection Manager all I can appear to do is stop and start the service. I'm not sure what needs to be set for SQLEXPRESS properties to log on as Network Service, Local System, orLocal Service.

View Replies !   View Related
Integrity Check Failed
on sql server 2000, try to do integrity check on several database once a week but failed, what would be main area to look up? thank you

View Replies !   View Related
DTS: Connection Properties Close The Enterprise Manager !
I designed a DTS package with eleven different connections. When I try to see the proberties of a connection the enterprise manager immediatly closes without giving me a warning. This happens only with two connections (in my example M1 and M2). This mistake has no influence to the execution of the package. In my opinion it is a fault of the DTS package desinger but may be that I made something wrong.
Is there anybody who knows this mistake? Thanks for your help.

View Replies !   View Related
Setting The OLEDB Connection Properties At Runtime
I used to do this in DTS but wondered how to do it in SSIS. I have a For Each ADO recordset loop that reads these four columns into variables:

DataSource Name, Name(for a WHERE clause), user and password.

For each "Building" there is a new server to connect to, with identical tables. I have 10 tables in the loop to pump from one database to a SQL 2005 database (i.e. 10 dataflows). I want to set the source connection information with the variables. My questions:

1. How do I set the connection information for the source connections? Do I just set the properties for the connection manager and then it sets for all the sources? What property do I set--do I need a script task?

2. How do I use the values from the "Name" column in a WHERE clause in each data flow?

Thanks!

Kayda

View Replies !   View Related
SSIS Scripts Task - Connection Properties
Hi All,

I am working on a SSIS package which is using a Script task, now I have all the connection properties set up in the .NET script using connection strings, what do I need to do if I have to set this up using a config file or something else which is more secure (I dont want to leave the connection information in the script). Please Advice.

Thanks



View Replies !   View Related
Login Failed For User 'TBD'. Reason: Not Associated With A Trusted SQL Server Connection.
I am setting up a shopping cart and I get the following error message -- Login failed for user 'TBD'. Reason: Not associated with a trusted SQL Server connection. It is probably a Web.Config issue abut am not sure how to edit the file.

<appSettings>

<add key="DBProvider" value="MSSQL" />
<add key="DBConn" value="data source=xx.xx.xx.xx;initial catalog=AspDotNetStorefront31;user id=TBD;password=TBD;persist security info=True;packet size=4096" />

</appSettings>

View Replies !   View Related
Login Failed For User ''. Reason: Not Associated With A Trusted SQL Server Connection.
Hello,

I have some problem here. I have a sql server installed on one machine and I have another development machine for my asp application. How could I actually access the asp application and sql server at the same time from another machine within the network. I kept on getting the error message above.

Thank you for your help :)

View Replies !   View Related
Login Failed For User ''. Reason: Not Associated With A Trusted SQL Server Connection.
Hi,



I have 2 windows 2003 server, i instllaed sql server 2005 enterprise edition on the first one (Mixed Mode), and i am trying to install sql server reporting 2000 on the second one,

I installed the sql 2000 connectivity only on the second one , and i installed the sql server sp4 also, while installing reporting services i used the sql login account (sa,pwd)

i got the following error :

Cannot connect to sql server instance ...

Login failed for user ''. Reason: Not associated with a trusted SQL Server connection.

NB1: Allow Remote connection is enabled on sql server 2005.

NB2: I tried to connect from server 2 to server 1 from odbc and it worked properly with (sa,pwd) i have only a problem from reporting server.

Please any help?

Tarek Ghazali

SQL Server MVP



View Replies !   View Related
Login Failed For User ''. Reason: Not Associated With A Trusted SQL Server Connection
Hello, here we have 2 developers, one developer has sql 2005 in his machine, the connection string has Integrated Security=SSPI, that developer can connect to the application, the other user gets that error when he tries to execute the application froms its own IIS.

The sql server has windows authentication, I want that the application uses one account, I tried to create one account, and give db_owner to it on the database, then I changed the connection string and it happens the same thing.

TKS

View Replies !   View Related
Connection Failed Error Creating Data Source For Server
Hopefully there's an easy answer for this. I'm totally new to SQL server and I'm trying to upsize an Access database. Whether I use the upsizing wizard or try to create a data source through the ODBC Data Source Administrator, I get a connection failed error. It tells me the server does not exist or my login is incorrect. I'm using NT authentication to connect to the server on my local drive. I just installed the whole 2005 express edition and the only thing that came up during the install was that I didn't have IIS installed. Ididn't see how that would be relevant, so I went ahead with the install.

Shouldn't this work with the default setup?I've searched around trying different "solutions" although I doubt they were specifically related to this very basic problem. I tried giving my login every right I could find through in the database engine properties in the server management studio, which connects fine itself with just my network login name and no password. What am I missing?

View Replies !   View Related
Integrity Check And Optimization Job Failed
I found the following error in my maintenance plan please help me on this

Under maintenace plan history i found this error:-

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.


and jobs failed with following error

i found this error in job history of optimization & integrity check jobs:-

Executed as user: XXXXadmin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Please help me find out the solution

Thanks in advance

Regards,

Sumit

View Replies !   View Related
Integrity Check And Optimization Job Failed
I found the following error in my maintenance plan please help me on this

Under maintenace plan history i found this error:-

[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]UPDATE STATISTICS failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.


and jobs failed with following error

i found this error in job history of optimization & integrity check jobs:-

Executed as user: XXXXadmin. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Please help me find out the solution

Thanks in advance

Regards,

Sumit

View Replies !   View Related
How To Check For Failed Database Backups
Hello everyone! Looking for some insight here on database backups that fail.

We have many SQL servers that we maintain by storing Job/Maintenence Plan history on a central server, which then emails out daily reports to let us know what backed up last night and what didn't

This was easy to do in SQL 2000, not so much in SQL 2005. I have put together a query that gathers the info I need for the successes:

SELECT DISTINCT '00000000-0000-0000-0000-000000000001' AS Plan_ID, mpld.line1 as "Plan Name", bud.database_name as "Database", mpld.server_name, 'Backup Database' as Activity, mpld.succeeded, bs.backup_finish_date, DATEDIFF (MS,bs.backup_start_date,bs.backup_finish_date) as Duration, bs.backup_start_date, mpld.error_number, mpld.error_messageFROM msdb.dbo.sysmaintplan_logdetail mpld
INNER JOIN msdb.dbo.backupset bs
on (select convert(char(12),mpld.start_time,109))=(select convert(char(12),bs.backup_start_date,109))-- on bs.database_name=bud.database_name
inner join
msdb.dbo.bu_dbs bud
on bs.database_name = bud.database_name
WHERE mpld.succeeded = 1 and mpld.line2 like 'Backup%' and bs.type='d'
and bs.backup_start_date > ( SELECT CONVERT(char(12), (GETDATE()-1), 109) )
ORDER BY bud.database_name DESC

But I am having trouble using a query to determine the databases the FAILED during backup. MSDB.BackupSet and MSDB.SYSMaintPlan_LogDetail really have nothing,because often times, even if a step in a Maint. Plan fails, the plan finishes reporting success.

Does anyone know of a good way to gather info about failed database backups?

Thank you!

Mario

View Replies !   View Related
Check Database Integrity - Failed
I have setup a full maintenance plan on SQL2005. When I run the job, I don't see any error but by loooking at the Log file viewer it appears that Check Database Integrity step failed because :

Alter failed for Server 'LUMONT001'.

Moreover, when I run DBCC CHECKDB from the console I have no error message. Any clue?
Thanks, Paul

View Replies !   View Related
A System Assertion Check Has Failed


When I Close (using .Net API) a SqlDataReader I am getting the following exception:

A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a QFE from Technical Support.

I have checked and the SQL is up to the latest service pack. We have checked the database using DBCC CHECKDB and there doesn't seem to be corruption. My question is what kind of bug is there in SqlDataReader.Close()?

Thank you.

Kevin

View Replies !   View Related
Migrating DTS 2000 To SSIS ; Modifying OLE DB Connection Properties
Hi - Im migrating packages in dts 2000 to SSIS 2005 using package migrator wizard. It loads a CSV to a table in DB. I need to change the server and file location paths after migration. While changing this, im encountering error - "the acquireconnection method call to connectionmanager failed

View Replies !   View Related
Migrating DTS 2000 To SSIS ; Modifying OLE DB Connection Properties
Hi - Im migrating packages in dts 2000 to SSIS 2005 using package migrator wizard. It loads a CSV to a table in DB. I need to change the server and file location paths after migration. While changing this, im encountering error - "the acquireconnection method call to connectionmanager failed

View Replies !   View Related
ASP.Net Pages And SQL Server Not In The Same Machine. Login Failed For The User, Not A Trusted Sql Connection
I am having an asp.net web site hosted in my machine's IIS (5.1). This aspx files are accessing data from an sql server 2000 database located in another machine. While i am trying to open a connection from the aspx files to the database, an error showing login failed for that user. Not a trusted sql server connection. so i unchecked the "allow anonymous access" in the directory security. But now its working from my machine (the web server, localhost). but when i try to access the aspx files from another machine with my system ip, the same error exists-Login failed for the user and not a trusted sql server connection. 

View Replies !   View Related
Login Failed For User '(null)'. Reason: Not Associated With A Trusted SQL Server Connection.
hi, 

there are two win2003 servers in the same workgroup. one has mssql 2000 server and other one has asp.net 2.0 web application connecting that mssql server. mssql server Authentication is SQL Server and Windows but when i try to connect using sql authentication with uid and pwd, i get the error;
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

searched a lot about it but couldnt find any solutions. the win2003 server which hosts mssql server has active directory. is this could be the problem? thanks in advance.

 ametedit :here is my connection string;"data source=192.168.16.1;initial catalog=SOLAR4;Trusted_Connection=yes;UID=Sql_user;PWD=123;"sql_user is dbowner of Solar4 database.

View Replies !   View Related
Login Failed For User '(null)'. Reason: Not Associated With A Trusted SQL Server Connection
I dont believe that no one can help me in this damn error,Please, I'm gonne lose my job offer If I didnt fix this. I have spent 7 days searching with no use !!
I use ASP.NET 2.0 with C# to develop an intranet site, it was working perfectly when i was on Visual Studio, when i tried to publish the site it gave me that error.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
the web application on IIS server, windows 2003 - the database on a different server windows 2003, sql server 2000.
Regaeding that we have proxy server, one firewall.
I tried to do the following steps with no use :(
1. Create a Domain Account with priveleges similar NETWORKSERVICE (windows server 2003).2. Grant this Domain Account (DomainName/NETWORKSERVICE ) access in the SQL Server Database for the necessary databases (created a new login for this user and gave it the privillage creator, read, write)3. <identity impersonate="true" userName="DomainNameUserName" password="password" />The second method is to simply set identity impersonate to true and assign the username and password in the IIS.1. Type inetmgr from your command prompt and give enter.2. This would open the IIS Control Panel.3. Expand the appropriate nodes and select the Virtual Directory of your application.4. Right Click and select Properties.5. Switch to the Directory Security Tab.6. Under Anonymous access and authentication control click Edit7. Check the Enable Anonymous access in case you want people to access the application without logging in with Windows Logon Screen.8. Uncheck the Allow IIS to control password and enter the DomainName/UserName and Password in the respective boxes. Usually IIS uses IUSER_MACHINENAME credentials for Anonymous access.9. Uncheck if any other authentication mode is checkedI did the previous step exactly like that. and the error still come.I remind you again we have a proxy server with one firwallI dont running under https X
My connection string is:    <add name="LocalSqlServer" connectionString="Data Source=database server IP; Initial Catalog=database name; Integrated Security=True"; UID="sa" ; pwd="password";      providerName="System.Data.SqlClient" />Please find me a solution

View Replies !   View Related
Login Failed For User '(null)'. Reason: Not Associated With A Trusted SQL Server Connection.
Basic setup

IIS 6 with ASP.Net 2.0, Integrated Windows Authentication turned on (anonymous turned off)
SQL Server 2000 with Windows Only Authentication on (SQL Server authentication turned off)
web.config file contains the following relevant entries:<identity impersonate="true" /><authentication mode=Windows" />
connection string:Data Source=[server name]; Integrated Security=SSPI; Initial Catalog=[database name];
When I run my query on my development server, it runs perfectly. When I run it on the production server (which is just an exact xcopy of the development web site), I get the "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection" error. I have verified that the settings I listed above are the same on both sites. What else should I check for?
I placed some test code on the page that outputs the current logged on user and the current asp.net user, and everything seems fine (both usernames are the same - the expected domainusername of the impersonated user who logged in to the site), so I don't know why the database would say the user was null. My test code for outputting the user is below:
string authUserName = User.Identity.Name;string aspUserName = System.Security.Principal.WindowsIdentity.GetCurrent().Name;Response.Write("You are: " + authUserName + "<br/>");Response.Write("This page runs as: " + aspUserName);

View Replies !   View Related
Login Failed For User '(null)'. Reason: Not Associated With A Trusted SQL Server Connection
Hi I have am developing on xp machine with iis 5.1 and trying to connect to a seperate windows 2003 machine with mssql 2000 installed.I would like to use a trusted connection and I added an asp account on the sql server with permissions to the database and also edited the security tab on IIS to have this account. I unchecked allow IIS to control this password.  When I look in the event viewer on my local machine I get an error:Process information:     Process ID: 2388     Process name: aspnet_wp.exe     Account name: MACHINENAMEASPNET  Exception information:     Exception type: SqlException     Exception message: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.    Any Ideas as to how I can fix this? 

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved