Failed To Connect To Localhost When Trying To Use Surface Area Configuration
Feb 13, 2008
Hello all, I hope someone can help me with this.
This is a new SQL Server 2005 cluster that we just installed for the first time, with SP2. I am trying to use a stored procedure with xp_cmdshell to run a script to backup the databases. I get the following error: locked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.
So I started Surface Area Configuration on the local SQL Server itself, and clicked on "Surface Area Configuration for Features". I then got the following error:
"Failed to connect to localhost. (Mirosoft.SqlServer.ConnectionInfo)
Additional information: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I am logged onto the server as a user with Admin privs; I installed SQL Server using that id. I am logged in via remote connection, so I know it allows remote connections... and I am logged into the server itself when I try to run the tool, so I don't understand why it's saying that it's trying to connect remotely.
Has anyone else ever experienced this problem? Thanks for any help you can give.
I installed SQL Server 2005 Enterprise Edition (64-bit) and then applied SQL SP2. When I launch the "SQL Server 2005 Surface Area Configuration" and choose "Surface Area Configuration for Features" I'm trying to enable xp_cmdshell.
After ticking the checkbox, and clicking Apply, I receive the error below. Anyone have any ideas on how to fix this?
===================================
Alter failed. (Microsoft.SqlServer.Smo)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Configuration&LinkId=20476
------------------------------ Program Location:
at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking) at Microsoft.SqlSac.Public.Smo.SetSetting(Credentials credentials, DatabaseFeature feature, Int32 value) at Microsoft.SqlSac.MainPanel.UserControlSSxp_cmdshell.ProcessOK(HashKey givenKey, String machineName) at Microsoft.SqlSac.MainPanel.FormFeatures.commitDBChanges() at Microsoft.SqlSac.MainPanel.FormFeatures.commitChanges()
===================================
Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. (Microsoft.SqlServer.ConnectionInfo)
------------------------------ Program Location:
at Microsoft.SqlServer.Management.Common.ServerConnection.GetStatements(String query, ExecutionTypes executionType, Int32& statementsToReverse) at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType) at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(String cmd) at Microsoft.SqlServer.Management.Smo.ConfigurationBase.DoAlter(Boolean overrideValueChecking) at Microsoft.SqlServer.Management.Smo.ConfigurationBase.Alter(Boolean overrideValueChecking)
I have just finished installing SQL 2005 Ent Edition on Win 2000 Adv Server, SQL2005 SP2, and SP2 Hotfix KB934458. After the installation, I could see and configure all services via SQL Configuration Manager and SQL Server Surface Area Configuration tools. This worked for a couple of days and now both configuration tools no longer detect SQL2005 components. SQL Server Surface Area Configuration issued an error that said "No SQL Server 2005 components were found on specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLAC)". SQL Configuration Manager did not list any installed services. I don€™t know what caused this. Anyone has any idea? Please help! Below is the Installation Report which shows installed components.
===================================
The following components are installed on this server
Dear All, i'm trying to publish a maintenance plan in sql server 2005.
but soon after right click and selecting a new maintenance plan, it is displaying an alert with "AgentXP's component" is turned off.
please let me know how to ON those services. i've read and followed the instructions but i was unable to find where exactly to start.
please guide me in this regard
my version of OS is sql server 2000 professional
my version of sql server is :Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Vinod Even you learn 1%, Learn it with 100% confidence.
Hi, we are having a strange problem when trying to configure the surface area of my sql server 2005. When we open the tool the only nodes that appears are: Reporting Services and Integration Services. But the Database Engine node is not showing. What do we have to do to access the Database Engine node and configure Remote Connection.
Up til now i've been working with Access, i have only got a few weeks experience with SQL, so dont eat me. I set up a SQL Database, and placed it into my site, etc, set up all the connection strings. It connects fine, but cannot log in. It tells me; Cannot open database "C:USERSJAREDDESKTOPSTYXSTYX - BUILD 2APP_DATASTYXDB.MDF" requested by the login. The login failed.Login failed for user 'Webdev01Jared'. I'm running Vista (x86), and SQL Server 2005 Express SP2, and i'm aware that Vista by default does not automatically enable remote access in SQLExpress for local admins. So i go into Surface Area Configuration. I've read about it, and it's two steps, Click "Add New Administrator", then select the priveleges in the left box and click the button to put them in the right box. Simple enough, and it works, sure, click the button, it moves across, done. But. Hit OK. It's done nothing, i still cant connect, and the cherry on top; open up the SAC again to check and there is nothing in the right box. It's exactly how it was before i changed it. The problem is definitely this, and not the account, as i can log in for SQL Management Studio just fine, with the same windows authentication credentials. Thanks in advance.
I am currently running a Windows Vista Enterprise OS platform using SQL Express, whenever i add a user to the administrator group using the SQL Server Surface Area Configuration UI, each time i click on the link to add New Administrator, the previous administrator i just added still appears on the left - just as if i never added this user previously.
Is there a way around this issue? or is this a SQL Express problem, because i also tried doing it with SQL Server Enterprise edition on a Win2K3 SP2 box and it gives the same results.
Sorry for the annoying. I would like to the configuration settings for the surface area. There's an option which able to let us change computer (whether is local computer or remote computer). Let say I put my own computer's name (Hans as example) for configuration as the remote compute, it's work fine to me. However, if I put my remote computer's name, it displays this error message to me.
Error :
Computer Tomato does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again.
I am sure that the remote computer is working since I am able to ping the remote computer and test on telnet as well. But why it seems that surface area can't detect my remote computer. Hope can get some resistance from everyone here. Thanx alot.
I want to send mails from SQL Server 2005 Management Studio Express for which I referred to the article at http://www.databasejournal.com/features/mssql/article.php/3626056. I could successfully do the steps from step 1 to step 6 listed at the above URL. In fact, when I sent a test mail (as cited in step 6), SQL Server displays the message Mail queued though the mail didn't get delivered. The mail server address I am using is smtp.mail.yahoo.co.uk.
But when I expand the Management node in the Management Studio Express GUI, I don't find Database Mail as a child node. In fact, there are only 2 child nodes under the Management node - SQL Server Logs & Activity Monitor.
Why isn't Database Mail listed under the Management node? What am I missing here?
Also when I open Surface Area Configuration & then click Surface Area Configuration for Services and Connections, the following error gets generated:
Computer localhost does not exist on the network, or the computer cannot be configured remotely. Verify that the remote computer has the required Windows Management Instrumentation components and then try again. (SQLSAC)
Additional Information:
The type initializer 'System.Management.ManagementPath' threw an exception. (System.Management) Unable to cast COM object of type 'System.Management.WbemDefPath' to interface type 'System.Management.IWbemPath'. The operation failed because the QueryInterface call on the COM component for the interface with IID '(38C15AF2-736C-477E-9E51-238AF8667DCC)' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)). (System.Management) When I click Surface Area Configuration for Features, it generates the error cited above but from the first bulleted list.
How do I overcome this error? I confirmed that Windows Management Instrumentation is running by opening Services from Control Panel ---> Administrative Tools.
I am on WinXP Pro SP2. Please note that I also have SQL Server 7.0 installed in my machine which is a standalone m/c.
The operation system is windows xp, and before i installed the SQL SERVER2005 the SQL SERVER2000 had installed. the course of installing the SQL SERVER2005 has no error at all. but i can not find the Database Engine under MSSQLSERVER from surface area configuration ============== thank you in advance for any help
hi ; everybody i have almost installed sql server 2005 enterprise edition on windows xp sp2 and i havent connected to any server .i have taken error:40 with my all attempts.tcp/ip protocol have been enabled on sql server configuration manager.i have tried to start sql server surface area configuration but every my attempt have been resulted a fault which is below. [No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)] i dont suppose that i did something wrong when i setupped.because i read every article on the internet about how to make setup.also; i setupped numbers of times on my pc. but i didnt accomplished. i thank for any help.please; give your solution explicitly.
I've run into a problem after upgrading production servers running under Microsoft Cluster Server, Windows Enterprise Server 2003 SP1, and SQL Server 2005 SP1 Enterprise Edition.
Once I completed the upgrade and applied the patch, I needed to examine the values set in the Features component of the Surface Area Configuration tool. The tool attempts to connect to localhostinstancename, but reports the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error:26 - Error Locating Server/Instance Specified)(Microsoft SQL Server)
I'm logged into the virtual server via Remote Desktop, but the SAC tool thinks I'm logged into the physical server supporting the virtual server. I seem to be caught between a rock and a hard place here, as I can't enable remote connections without first gaining access on the server itself.
Greetings all,I cannot connect to my SSIS service from Management Studio. This is on my local machine, which is my "sandbox" and preliminary development platform.
There are slightly different error messages and extended information returned depending on whether I connect using "localhost" or my explicit machine name.
I have tried registering MSXML*.dll as suggested elsewhere in these forums. I've also tried the DCOM config changes suggested elsewhere in these forums (or someone's blog?) - can't find the link at the moment.
This is all on the same machine and I am a local admin on this machine.
Anyone seen this? Anyone have any suggestions. I'd appreciate any tips.
Regards,
Tom
<< LocalHost - Copy Message Text >> TITLE: Connect to Server ------------------------------ Cannot connect to localhost. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "localhost" failed: Class not registered. ------------------------------ Connect to SSIS Service on machine "localhost" failed: Class not registered. ------------------------------ BUTTONS: OK ------------------------------
<< LocalHost - Show Technical Details >> =================================== Cannot connect to localhost. =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser() =================================== Connect to SSIS Service on machine "localhost" failed: Class not registered. ------------------------------ 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.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) =================================== Connect to SSIS Service on machine "localhost" failed: Class not registered. ------------------------------ 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)
<<ExplicitMachineName - Copy Message Text >> TITLE: Connect to Server ------------------------------ Cannot connect to TOM-H. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Connect to SSIS Service on machine "TOM-H" failed: Class not registered. ------------------------------ Connect to SSIS Service on machine "TOM-H" failed: Class not registered. ------------------------------ BUTTONS: OK ------------------------------
<< ExplicitMachineName - Show Technical Details >> =================================== Cannot connect to TOM-H. =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser() =================================== Connect to SSIS Service on machine "TOM-H" failed: Class not registered. ------------------------------ 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.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) =================================== Connect to SSIS Service on machine "TOM-H" failed: Class not registered. ------------------------------ 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)
Hello, I've installed SQLServer2k5 Sept CTP with the following config: W2K SP4 Pro, SQL2K5 Std Sept CTP complete clean install. Everything works except SAC for features. I get the error below when trying to start it. SAC for Services & Connections connects without problem and has local & remote connections via both TCP/IP and Named Pipes enabled for the server, and local & remote connections enabled for analysis services. All SQL2K5 components & services are started in the Services control panel. I've looked at port useage, wondering if some other process is using the port that SAC for features is pinging, but since SAC for Services & Connections works fine that doesn't seem to be culprit. I also get an error when running the Tuning Advisor, saying it can't connect, but demoted that to just a warning by closing some extraneous connections to the servere (had >10 open). Still get a warning, but it doesn't prevent the Tuning Advisor from completing. I've tried turning on and off various services, from Remote Registry Service to IIS, but no luck. Anyone know what else I chould check to troubleshoot this? Thanks! Failed to connect to server localhost
I'm posting this in the Setup forum as I think the problem relates to my SQL Server Configuration. Being new to server management pls ask for more info if I don't explain this clearly enough, I'm running out of idea.
Here's the set up:
Windows Server 2003 Web Edition SP2 SQL Server 2005 Enterprise Edition SP1
When I try to run apps I get the following message:
I've found some great notes on the TechNet forums explaining this error and how to resolve it by configuring the Surface Area Tool... remote connections etc
But, this is where I draw a blank as I cannot access the Surafce Area Configuartion for Services and Connections because certain components are not installed, or I do not have admin rights. I definitly have the admin rights, but have no idea where to start looking for aforementioned components.
During the SQL Server install I recevied the warning:
SQL Service Edition System Compatibility - Some components of this edition of SQL Server are not supported on this Op system.
It sounds pretty generic and doesn't offer anymore details, but could this be effecting it?
I've also noticed that when I open SQL Server Configuration Manager and click on SQL Server 2005 Services nothing appears in the right-hand panel??? I'm sure there should be???
I've been all over TechNet & Books online and cannot find any reference for what I'm experiencing.
Being very new to SQL Server, I have to ask - when I try to connect to SQL Server 2005 using TCP/IP I cannot. To accomplish this I was directed to use the Surface Area Configuration utility.
When I do this, I do not see the Database Engine the docks reffer to - any help/comments/suggestions?
I get this problem when tryoing to connect to the surface area configuration for services & connections As well as for features. However I can connect via another computer and change the options accordingly but I just can't do it locally from the server ? Does any one know why please, the links in the message don't help ?
=================================== An exception occurred in SMO while trying to manage a service. (Microsoft.SqlServer.Smo) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.InnerWmiException&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request) at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ProcessRequest(Request req) at Microsoft.SqlServer.Management.Smo.Wmi.WmiSmoObject.EnumChildren(String childTypeName, WmiCollectionBase coll) at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.InitializeChildCollection() at Microsoft.SqlServer.Management.Smo.Wmi.ServiceCollection.get_Count() at Microsoft.SqlSac.MainPanel.FormFeatures..ctor(String machineName, Form callingForm) =================================== Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476 ------------------------------ Program Location: at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Wmi.WMIProxy.ExecProcess(Object request) =================================== ------------------------------ Program Location: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext() at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildDataTable(ManagementObjectCollection listManagementObject) at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.BuildResult(ManagementObjectCollection listManagementObject) at Microsoft.SqlServer.Management.Smo.Wmi.WmiBase.GetData(EnumResult erParent) at Microsoft.SqlServer.Management.Smo.Environment.GetData() at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci) at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request) at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)
I am struggling to set a SQL Server Express for remote access...
Since it is the only instance on this server, I have set it up to use port 1433 by amending the IPALL entry of the Server Network Configuration, TCP/IP Properties.
I have also disabled "Shared Memory" and "Named Pipes" to leave only TCP/IP enabled as a server network config. I have stopped the Browser Service because I think I don't need it if I use port 1433.
From the server itself, I can connect to my SQL Server through "localhostSQLEXPRESS" or "servernameSQLEXPRESS" but not from "10.xxx.xxx.xxxSQLEXPRESS" or "127.0.0.1SQLEXPRESS"
I suppose until I can access my server from itself using the IPAddress, there is no chance connecting remotely...
I'm trying to log into a local sql 2005 exp server on my XP box. I've created a new user and create a new db. The new user is mapped to the db and has read/write access. When I try to log in directly to the server via the management studio express I get the following error:
==================================
Cannot connect to localhost.
===================================
A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476 --- THIS LINK IS DEAD AS IT DOES NOT EXIST
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected) at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server) at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()
Unable to connect to the remote server (Microsoft.SqlServer.Management.UI.RSClient)
------------------------------
No connection could be made because the target machine actively refused it (System)
------------------------------ SCHALTFLĂ„CHEN:
OK ------------------------------
Has anybody had that problem before? Happens right after installation, no customisation of the SQL Server has been done yet. And I run the server on localhost.......
I have a test environment set up at home with a small windows server 2003 Active Directory domain. I created a windows security group on the dc and added myself and another user to the group. I then use this group as a login for SQL Server and add the login to the sysadmin server role. This works exactly as I would expect on the Windows Server computer (which is also the Domain Controller) regardless of which computer I use to connect to this Windows Server computer. However, when I set up the exact same login on the local sql server instance of my client laptop running windows xp pro, the I get an error message (Login failed for user MYDOMAINdgolds...) when I attempt to connect to the local instance of SQL server, even though I am able to connect to the instance on the domain controller with no problems using this same client laptop under the same user account. The only way I am able to connect locally on the laptop under this account (which does not have local admin privileges on any box, for testing purposes) is to add the user account separately as a login, rather than as part of a group. I'm curious as to why being a member of a security group that is part of the sysadmin server role does not allow me to connect to the local instance of SQL Server on this client laptop. The windows server computer is running SQL2k5 Enterprise, and the client laptop is running SQL2k5 developer. Any insight into this would be appreciated.
The report simply just report a tables content and i can preview it by Ctrl+F5 without problem.
However, after I publish the website to localhost,which is Http://localhost/ViewReport/. I failed to open the report in http://localhost/viewreport/default.aspx The page is opened but there is a error message at the reportviewer portion.
" ASPNET user don't have permission to view the report.." something like that.
Anyone know what causes the problem?
I am thinking is it because I am using build in account "Local system" to run the Sql express 2005 Databaes and reporting service? But I have no choice, when I install the SQl express 2005, the only build in account I have is "Local System", but "Local Service " and" Network Service" is missing from my system. It is weird. Is it because of windows server 2000?
I am trying to connect to my local SQL server 2005 from "Server Explorer" but it is giving the error of "Remote Connectons" not allowed.
I am using "windows authentication" login.
My SQLExpress and SQLExpress browser are running from "SQL server configuration manager".
If i use a "App.Config" file to connect to database, the SQl connection can open and i can run the stored procedure.... but cannot access the database on my local machine.
Anyone encounter differences between SQL2K EE and SQL2K Dev Editon?FAILS-----Machine_A [App Server] <-- JDBC --> Machine_ASQL2K_Dev_Ed..dbError: "com.inet.tds.SQLException: Connection refused"When app server on Machine_A attempts to connect to database onMachine_A the conenction is refused.SUCCEEDS---------Machine_A [App Server] <-- JDBC --> Machine_BSQL2K_EE..dbWhen app server on Machine_A attempts to connect to database onMachine_B the conenction succeeds and the app server runs normally.JDBC driver: com.inet.tds.TdsDriverjdbc:inetdae7:locahost:1433I don't believe the app server is exhausting the 10-connection max onSQL2K developer edition (there is a 10-connection limit imposed on thedeveloper edition, correct?)LB
When trying to open the sharepoint webpage I'm getting this error - cannot connect to the configuration database sharepoint 2010.Database is on SQL server 2008.Tried opening the site on server - got the same error.Googled and tried to start the mssqlserver services (browser and sql server) but they fail to start with error code 17058.
Googled what this error was about and some solutions led me to check the error log in event viewer. For mssqlserver I got following message in the event proverties window -Â Could not open error log file <path of log file> ''. Operating system error = 5 (access denied).When I tried to login on the sql server management studio, it does not let me login and gives error -Â
I got to know that this can happen due to unexpected reboot of server. I checked my server and it had actually restarted unexpectedly.URL...
Guys, could anyone please help me to resolve this problem:
I'm trying to install MSSQL Server 7 Desktop Edition on Windows 98 (First Edition v4.10.1998). Everything goes smoothly until the 'Starting Service ...' icon appears. Then I'm getting a setup error which says that it failed to configure server and refers me to 'cnfgsr.out' file:
------------------------------------- Starting Service ...
An error occurred while attempting to start the service (1460)
SQL Server configuration failed. -------------------------------------
The ERRORLOG file contains the following:
------------------------------------- 2000-01-11 18:42:40.40 kernel Microsoft SQL Server 7.00 - 7.00.623 (Intel X86) Nov 27 1998 22:20:07 Copyright (c) 1988-1998 Microsoft Corporation Desktop Edition on Windows 4.10 (Build 1998: )
2000-01-11 18:42:40.48 kernel Copyright (C) 1988-1997 Microsoft Corporation. 2000-01-11 18:42:40.49 kernel All rights reserved. 2000-01-11 18:42:40.52 kernel Logging SQL Server messages in file 'C:MSSQL7logERRORLOG'. 2000-01-11 18:42:40.86 kernel initconfig: Number of user connections limited to 32767. 2000-01-11 18:42:40.87 kernel SQL Server is starting at priority class 'normal'(1 CPU detected). 2000-01-11 18:42:41.02 kernel User Mode Scheduler configured for thread processing 2000-01-11 18:42:43.15 server Directory Size: 2559 2000-01-11 18:42:43.43 spid0 Using 'sqlimage.dll' version '4.0.5' Stack Dump being sent to C:MSSQL7logSQL00001.dmp Stack Dump being sent to C:MSSQL7logSQL00002.dmp 2000-01-11 18:42:48.84 spid0 Problem creating symptom dump file due to internal exceptionUnable to get thread context - no pss 2000-01-11 18:42:48.86 spid0 Problem creating stack dump file due to internal exception ---------------------------------------------------
Any help would be appreciated. Thank you very much.
Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.
When i try to connected to existing configuration database it's only shows NT AUTHORITYNETWORK SERVICE as my login user for database access , when i type another user , error message " you must specifay the same user account as your farm server you wish to join " how i can change it.
please help me how i can change the configuration user and password for my singel farm server
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections.
I have tried all of the recommendations I can find here without any luck. What am I missing?