Unable To Connect Using Dedicated Administrator Connection (DAC)
Oct 15, 2007
All,
I was wondering if anyone could tell me why I could not connect to my server with the DAC when the server CPU utilization for all CPU's was greater than 90%.
BACKGROUND: I have successfully established DAC connections to this server in other periods when the CPU utilization was not pinned so high. I have done so by RDP'ing into the server, opening SSMS and cancelling the request to connect Object Explorer. Finally, I start a new query adding the "Admin" prefix to my server.
As I mentioned, when the server has CPU resource available, this works fine. This indicates that all the groundwork to setting up and using the DAC is laid correctly (i.e. DAC is enabled, I am connected locally, I am logged in with a user role with proper permissions, etc.).
This leads to my question. Why can I not connect to SQL Server 2005 Standard Edition using the DAC when all the (8-way) CPU utilization is at 90% or higher?
I need to make this connection to analyze why the server is so busy.
I would like to setup the membership and role in web administrator tool, however, under Security section, I got the error message of "Unable to connect to SQL database". I tried to run aspnet_regsql.exe to edit the config(C:WINDOWSMicrosoft.NETFrameworkv2.0.50727>aspnet_regsql.exe), however, it still shows this error message. I am using web developer 2008 and SQL Server 2005. Please advice me how to tackle this problem.
Trying to upgrade a 6.5 to a 2K. Running SQL Agent from an admin account, admin account active as admin on both 6.5 machine and 2K machine, but I can not get the upgrade past the second screen, where I get the error message: Unable to connect to export server, please verify that you are an NT Administrator on that machine.
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)
this is the error message I found when I run my asp.net application and the connection string as follows: <add key="ConnectionInfo" value="Server=(local);Database=Dive;Trusted_Connection=yes;" /> can someone tell me how to connect and how to specify username and password in Visual Web Developer 2005 Express Edition.......... I'm a little bit new on VWD 2005 I need an assistance on it.
I am not able to connect to SQL Database server using windows authentication when I am connected through VPN connection.However I am able to connect to same server using SQL server authentication and also able to do RDP to DB server machine.
I found a resolution in one of the forum suggesting to change UserRasCredentials to 0 value in *.pdk file.Since VPN connection which I am using generates instant proxy this resolution doesn't work.
Also application which I am using does windows authentication connection it is required for me to impersonate windows authetication when connected using VPN.
i am trying to consume an webservice which under secure layer (HTTPS)
eg: https://test.com/test.asmx
i'm connected thro' a proxy server.
when i use the same url in IE it works fine, but when i connect thro' http connection manager it always throws me a error saying "unable to connect to remote server "
can anyone provide me solution to over come this problem
I connected successfully in SQL Server Management studio using the 'sa' login and changed the authentication mode to Windows NT because I could not connect using my windows login but now I can't get any connection at all because 'sa' is no longer trusted.
I changed the loginmode registry setting to 2 and rebooted my PC but this has made no difference.
I'm using SQL Server 2005 Standard edition on Windows 2003 Standard server.
I can connect with no problems as user 'sa' to SQL Server Management Studio. I can also create users and databases there with no problems and I can connect to them using SQL Server Management Studio, again, with no problem. However,. I want to use the Web Data Administrator.
I installed it,. without a problem, and I can access it as Server/Administrator and then using 'sa' and it's corresponding password.
So where is the problem?
The problem is that when I create a different user on the server and want them to have access to the Web Data Administrator, they can pass the WindowsAuth pop up screen, but when prompted to enter the MSSQL username and password, the login doesn't pass. In fact you only see the clock hangin, but no login process is taking place.
iam having vs2005 installed on my machine and i also installed sqlserver2005 dev edition on my machine...Now iam devloping a Window Appplication in which I need to populate a grid from Sqlserver2000 (dev edition) which installed on remote (i.e another network)....when i try to run my application it gives me a error tht "Unable to connect to sqlserver2005".actaully i specified in my connection string to connect to Sqlserver2000 on the remote machine.
I feel to know how to enable remote connection on Sqlserver 2000.So tht i can access this sqlserver2000 from another machine
Database server: - Remote machine running SQL 2005 Standard as a named instance - Named pipes and TCP are enabled for remote connections - SQLBrowser service is running - Listening on default named pipe (\servernamepipeMSSQL$instancenamesqlquery)
Client: - Vista Business machine - Not in same domain as server, but on the same network (via Cisco VPN) - SQL 2005 Express is installed (for use with local databases) - Windows Firewall enabled - Running Symantec Antivirus, Corporate Edition
Connectivity: - I CAN connect to SQL 2005 databases on the remote server using "nperverinstancename" - I CAN connect to SQL 2005 databases on the remote server using Excel 2007
The problem is that I cannot successfully create an ODBC datasource using the "ODBC Data Source Administrator" application. I'm using the "SQL Server" driver and trying to create a System DSN. I'm also running the tool with elevated permissions.
- When I try to use "servernameinstancename" as the server and TCP as the connection type, I get this error:
Connection failed: SQL Server Error: 18452; "[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user ''. The user is not associated with a trusted SQL Server connection.
- When I try to use "npervernameinstancename" as the server and Named Pipes, I get this error:
Connection failed: SQLState: '01000'; SQL Server Error: 1326; [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect()). Connection failed: SQLState: '08000'; SQL Server Error: 17; [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Help! I've really been beating my head against the wall on this one. It all works just fine with a Windows XP client machine.
I€™ve developed a BI system using the SQL Server 2005 Developer€™s Edition.
SSAS, SSIS and SSRS have been added to a SQL Server 2005 Standard Edition Server in preparation for delivering the developed database to this live environment.
So I am able to connect directly to the Database Engine, SSAS, SSIS and SSRS successfully from the actual SQL Server 2005 Standard Edition box which is sat on a Windows 2003 Server operating system.
However when I launch SQL Server Management Studio from a desk top PC which is connected to the SQL Server Standard Edition box I can€™t connect to either SSIS or SSRS, however I can connect to the Database Engine and it also seems that I can connect to SSAS OK.
I am using Windows Authentication where the I used a SQL Server account which exists with €œsysadmin€? permissions and this SQL Server account has the same login name as the Windows Server 2003 desktop login.
We are trying to set up SQLAgent Proxy account. If the SQLServer service id is a domain admin, do we still have to add it to the local administrators group?
I want to connect to company's SQL Server from home and to connect to home's SQL server from company remotely. The new released SQL Server Web Data Administrator by Microsoft seems solving my issue. I use it to connect to different SQL servers in different domains company wide successfully, but I failed to connect to home from company( I have static IP on the home server). Also I want to know how to configure the sever name if I want to connect to company's SQL Server from home. The company SQL server is inside the firewall with a internal IP. How it works?
Please help! I am new in SQL Server 2000 Administration. My manager had ask me to manage a SQL Server, but Windows Adminstrator refuse to give me Local Admin rights. I only have sa account to login to databases. I don't know any excuses or reasons to give to Windows Adminstrator so that he can give me the local admin rights. If any one have this answer, please help. Thank you.
I use SQL Server 2012 and visual studio 2010.I created SSIS Project with task "Execute Package". Control flow view as: Package1 (execute package) -> Package2 (data flow).Data flow in Package2 view as: ADO.NET source -> ADO.NET destination.
When I started Package2, it's work. I havn't errors.But when I started Package 1 I have error "Unable to get managed connection from the Connection Manager runtime". In execution log I see that ADO.NET source produced this error on verification stage. Package failed on verification stage, not on execution stage.Why when I started Package 2 it work, but when I started Package1 (and Package1 started Package2) it failed?
I have SQL Server Express and VB 2005 Express installed in a Microsoft Windows XP Pro PC that is a terminal PC in our office Network. My Network Administrator has granted my terminal PC for Administrator Use. I tried to do the ADO.NET 2.0-VB 2005 programming in my terminal PC and I could not get a remote connection in the Window Form Application via Window Authorization. I do not know how to make this kind of remote connection in my Network. Please help and advise.
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect" whenever i try to connect to the remote DB which is present at a different system.
Hello everybody I wrote a vb.net win app that uses a mssql 2005 express DB. On my localcomputer everything worked without a problem. Now I wish to deploy my app on a remote computer (that has mssql 2005 express installed), so. I added an app setup project to my project using the vs2005 setup tool, installed the app on the remote computer, and copied the mdf file to the remote computer. I'm able to see the DB through the remote computer mssql manager, But when I try to start the app on the remote computer I get this error massage : A connection was successfully established with the server, but then an error occurred during the pre-login handshake. error: 0 - No process is on the other end of the pipe.) my connectionstring (in the config file) looks like that : <connectionStrings> <add name="Info_Manager.My.MySettings.MaxinetConnectionString" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> <add name="Info_Manager.My.MySettings.MaxinetConnectionString1" connectionString="Data Source=DOTAN-XPSQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMaxinet.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" /> </connectionStrings> by the way changing the user instance attribute to "false" didn't help. Does anybody know how to fix this problem.
Every time i reboot my NT Server and the SQL server service starts up. It logs this message to the event Viewer
Severity: 9 Error:10004, OS: 11001 Unable to connect: SQL Server is unavailable or does not exist. General network error. Check your documentation.ConnectionOpen (gethostbyname()()).
I don`t have any problem with the databases, all the users are able to connect to server and database without any problems, looks like everything is working at its best. But i am little concerned about this error message.
Everything has been working fine our SQL Server (lets call it Server A) (v2000 under NT 4), however sometime over the weekend it is unable to connect to one of our other SQL Servers (Server B).
In the Event Viewer I found this error: SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip (TCP/IP)): Error 10013.
Everything on this server appears to be working fine, as in everything can connect to Sever A that needs to, but Server B can't connect to A, nor is it working the other way.
Also, Server A SQL Services run on port 2006, and B is on the standard 1433. Everything has been working with this up until today?
Let me start by saying that, yes we know v6.5 is no longer supported byMicrosoft and that moving to SQL2000 might resolve our problem.Actually the migration to SQL2000 is 1 to 2 months out and in the QAphase now. Unfortunately we need to resolve the current 6.5 issue nowas it heavily impacts a major revenue stream for the company with everyoutage we encounter.The Problem:At least once every 24 hours the SQL Server begins disallowing new userconnections. When this happens the 2 CPUs begin to thrash. About 5minutes later the error log begins to print out the following errormessage: "Unable to connect. The maximum number of '500' configured userconnections are already connected. System Administrator can configure toa higher value with sp_configure." No new connections can be made to theserver; however, the existing connections continue to function normally.We never see anywhere near 500 user connections in the system (it tendsto average around 350 connections). If we begin to disconnect users theserver continues reporting that the maximum number of users isconnected. Eventually running queries thru an open connection will hangand we have to resort to a hard reboot of the server as neither SQLServer will not shutdown nor will the operating system.The Server:Compaq Proliant DL380 with dual 863 MHz. processors (x86 Family 6 Model8 Stepping 3 GenuineIntel), 917,020 KB of physical memory, MicrosoftWindows 2000 Server (Version 5.0.2195 Service Pack 4 Build 2195), TotalVirtual Memory 3,138,688 KB, Page File Space 2,221,668 KBSQL Server:Microsoft SQL Server 6.50 - 6.50.479 (Intel X86). Some pertinentconfiguration settings: memory - 244100 (in 2K units), user connections– 500, RA worker threads – 3, max worker threads – 255We found one reference to the above error message in the MicrosoftKnowledge Base and that refers to a condition where the server has 2GBor more of physical memory with 1.5GB assigned to SQL Server. This doesnot pertain to our situation. Have any of you ever encountered thisproblem?I appreciate your insights.*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!
I am using MS VB 2005 Express to connect to a DB created in SQL 2005 Express and have not been able to make a connection. I am including answers to questions along with screen shots where it would make it clear, hope they come through. I f anyone has any ideas on what I have not done, or what I have incorrectly done, please let me know. I notice in the log that the database I am trying to connecto to does not show up as started. I don't understand why is doesn't show up, and I don't understand what I would need to do to start it.
[1] Client side:
What is the connection string in you app or DSN? (please specify) Data Source=.MSSQLSERVER;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMusuemInventory.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True
If client fails to connect, what is the client error messages? (please specify) SQL Network Interface, error 25, Connection string is not valid
Is the client remote or local to the SQL server machine? [Remote | Local] Local
Can you ping your server? [YES | NO ] In cmd.exe console, type €œping -a <server_name>€?. Yes can ping server
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>. YES telnet connects on port 135
What is your client database provider? [SNAC | MDAC | ADO.NET1.0 | ADO.NET2.0| other (please specify] Or/And, what is your client application? [SQL Management Studio | SQL Profiler | Visual Studio | Other (please specify). Using .NET Framework Data Provider for SQL Server
Is your client computer in the same domain as the Server computer? (Same domain | Different domains | WorkGroup) Yes
What protocol the client enabled? [Shared Memory | TCPIP | Named Pipes]. Shared Memory
Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. No aliases
[2] Server side:
What is the MS SQL version? [ SQL Server 2005 | SQL Sever 2005 ]
Miscrsoft SQL Server Express Microsoft SQL Server Management Studio Express 9.00.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
What is the SKU of MS SQL? [Enterprise | Standard | Workgroup | Express (or MSDE) | other (please specify)]. Express
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. Shared Memory
Does the server start successfully? [YES | NO] If not what is the error messages in the SQL server ERRORLOG? Yes
If SQL Server is a named instance, is the SQL browser enabled? [YES | NO] Yes Browser is running
What is the account that the SQL Server is running under?[Local System | Network Service | Domain Account] Local System
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? [YES | NO | not applicable] Not applicable
Do you make firewall exception for SQL Browser UDP port 1434? [YES | NO | not applicable ] No
[3] Platform:
What is the OS version? [Windows XPSP2 | Windows 2003 | Windows 2000 | Windows 98 | others (please specify ) ]. Microsoft Windows XP Professional Version 2002 Service Pack 2
Do you have third party antivirus, anti-spareware software installed? [Symantec | Norton | other (please specify)]. McAfee
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question. [5] Tips: 1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG Today entries in Log File
2006-10-01 03:07:35.14 spid51 Starting up database 'ReportServer'. 2006-10-01 03:07:35.28 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:07:35.28 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:07:40.50 spid51 Starting up database 'ReportServer'. 2006-10-01 03:07:40.62 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:07:40.62 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:08:45.62 spid51 Starting up database 'ReportServer'. 2006-10-01 03:08:45.75 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:08:45.75 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:10:50.75 spid51 Starting up database 'ReportServer'. 2006-10-01 03:10:50.85 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:10:50.85 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:14:55.85 spid51 Starting up database 'ReportServer'. 2006-10-01 03:14:55.98 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:14:55.98 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:23:00.98 spid51 Starting up database 'ReportServer'. 2006-10-01 03:23:01.17 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:23:01.17 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 03:39:01.20 Server Server resumed execution after being idle 47 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 03:39:01.20 spid51 Starting up database 'ReportServer'. 2006-10-01 03:39:01.31 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 03:39:01.31 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 04:11:01.31 Server Server resumed execution after being idle 1006 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 04:11:01.32 spid51 Starting up database 'ReportServer'. 2006-10-01 04:11:01.43 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 04:11:01.43 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 05:15:01.50 Server Server resumed execution after being idle 2926 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 05:15:01.50 spid51 Starting up database 'ReportServer'. 2006-10-01 05:15:01.59 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 05:15:01.59 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 07:23:01.76 spid51 Starting up database 'ReportServer'. 2006-10-01 07:23:01.87 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 07:23:01.87 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 08:18:02.20 Server Server resumed execution after being idle 1968 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 08:18:04.75 spid52 Using 'xpstar90.dll' version '2005.90.2047' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2006-10-01 08:20:02.13 spid52 Using 'xplog70.dll' version '2005.90.2047' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required. 2006-10-01 08:33:25.51 spid54 Starting up database 'aspnetdb'. 2006-10-01 08:33:26.00 spid54 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 08:33:26.92 spid54 Starting up database 'MyCompany'. 2006-10-01 08:33:27.21 spid54 Starting up database 'ReportServer'. 2006-10-01 08:33:27.40 spid54 Starting up database 'ReportServerTempDB'. 2006-10-01 08:33:27.88 spid54 Starting up database 'aspnetdb'. 2006-10-01 10:50:18.71 Server Server resumed execution after being idle 4523 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 10:50:18.73 Logon Error: 17828, Severity: 20, State: 3. 2006-10-01 10:50:18.73 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>] 2006-10-01 11:19:40.78 Server Server resumed execution after being idle 672 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 11:36:52.20 spid52 Starting up database 'aspnetdb'. 2006-10-01 11:36:52.45 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 11:36:52.98 spid52 Starting up database 'MyCompany'. 2006-10-01 11:36:53.29 spid52 Starting up database 'ReportServer'. 2006-10-01 11:36:53.56 spid52 Starting up database 'ReportServerTempDB'. 2006-10-01 11:36:53.96 spid52 Starting up database 'aspnetdb'. 2006-10-01 11:37:27.62 spid52 Starting up database 'C:PROGRAM FILESMICROSOFT SQL SERVERMSSQL.1MSSQLDATAADVENTUREWORKS_DATA.MDF'. 2006-10-01 11:37:28.21 spid52 Starting up database 'MyCompany'. 2006-10-01 11:37:28.48 spid52 Starting up database 'ReportServer'. 2006-10-01 11:37:28.71 spid52 Starting up database 'ReportServerTempDB'. 2006-10-01 11:39:02.56 spid52 Starting up database 'ReportServer'. 2006-10-01 11:39:02.67 Logon Error: 18456, Severity: 14, State: 16. 2006-10-01 11:39:02.67 Logon Login failed for user 'NT AUTHORITYNETWORK SERVICE'. [CLIENT: <local machine>] 2006-10-01 12:39:22.70 Server Server resumed execution after being idle 2709 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 14:02:22.34 Server Server resumed execution after being idle 1287 seconds: user activity awakened the server. This is an informational message only. No user action is required. 2006-10-01 14:02:22.34 Logon Error: 17828, Severity: 20, State: 3. 2006-10-01 14:02:22.34 Logon The prelogin packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library. [CLIENT: <local machine>]
Last but not least: There is a wealth of information already available to help you answer your questions.
(1) SQL Server 2005 Books Online: http://msdn2.microsoft.com (2) Microsoft Support Knowledge Base: http://support.microsoft.com (3) SQL Protocol Team Blog: http://blogs.msdn.com/sql_protocols (4) MSN Search: http://search.msn.com/ or use your favorite search engine.
I am unable to connect SQL Server Management Studio to any of the databases on my computer. At this stage I am simply starting the Management Studio and asking it to connect to a database I made a few months ago before this connection trouble arose. I'm specifying the server name "BENCHLAP" which is the name of My Computer, using Windows Authentication. The error I get is: 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 client is local. At least, it is if I understand correctly - the instance of SQL Server is installed on the same machine as the instance of IIS that I intend to use to test my web applications after we have resolved this issue, and the same machine as the one I shall use to view the application on. I can ping the server if i type "ping -a BENCHLAP". It is successful I think it also connects via telnet ok as well, by typing "telnet BENCHLAP 135" All client protocols are enabled, as are the server protocols. Don't know if this is a security risk but I did it to try and solve the problem, to no avail. There are no aliases, according to the Configuration Manager.
The server itself is SQL Server Express 2005, runnning on Windows XP Professional. My anti virus software is AVG. I'm afraid I don't know anything more, and have been researching this error for quite some time now. Is anybody able to help me please? Ben
Cannot someone please help me with following problem. I am trying to create a program to update a sql datbase from.NET 2003. I am doing this by using SQL Server Express 5. The problem is, is that when I run the program and click the button to view the table in SQL Express 5 I keep getting an 'System.NullReferenceException' and the table is not shown. When I look at the debug details it says that 'object reference not set to an instance of an object'. Am not sure where am goin wrong as the connection is opened to the local server in SQL Express and I have created a connection object and initialised it to the address fo the datatable in SQL. Please find below the code I am working on which shows the connection string in question and the table being called in button 6 which causes the exception. Any help would be greatly appreciated....thanks
using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient;namespace MovieBase { /// <summary> /// Summary description for Form1. /// </summary>public class Form1 : System.Windows.Forms.Form {private System.Windows.Forms.Button button1; private System.Windows.Forms.Button button2;private System.Windows.Forms.Button button3; private System.Windows.Forms.Label label1;private System.Windows.Forms.Button button4; private System.Windows.Forms.Button button5;private System.Data.SqlClient.SqlConnection sqlConnection1; private System.Windows.Forms.ComboBox GengreList;private System.Windows.Forms.Button button6; private System.Windows.Forms.Button button7;private System.Data.SqlClient.SqlCommand sqlSelectCommand1; private System.Data.SqlClient.SqlCommand sqlInsertCommand1;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; private System.Windows.Forms.Label label2;public DataSet MDSet = new DataSet(); SqlDataAdapter MyAdapt;private System.Data.SqlClient.SqlCommand sqlSelectCommand2; private System.Data.SqlClient.SqlCommand sqlInsertCommand2;private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter2;public SqlConnection MovCon = new SqlConnection("Data Source = SHERMAN/SQLEXPRESS;Initial Catalog= MovieDBase;User Id=myUsername;Password=myPassword");
/// <summary> /// Required designer variable. /// </summary>private System.ComponentModel.Container components = null;public Form1() { // // Required for Windows Form Designer support // InitializeComponent();
// // TODO: Add any constructor code after InitializeComponent call // } /// <summary> /// Clean up any resources being used. /// </summary>protected override void Dispose( bool disposing ) {if( disposing ) {if (components != null) { components.Dispose(); } }base.Dispose( disposing ); }#region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary>private void InitializeComponent() {System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(Form1)); this.button1 = new System.Windows.Forms.Button();this.button2 = new System.Windows.Forms.Button(); this.button3 = new System.Windows.Forms.Button();this.label1 = new System.Windows.Forms.Label(); this.button4 = new System.Windows.Forms.Button();this.button5 = new System.Windows.Forms.Button(); this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();this.GengreList = new System.Windows.Forms.ComboBox(); this.button6 = new System.Windows.Forms.Button();this.button7 = new System.Windows.Forms.Button(); this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();this.label2 = new System.Windows.Forms.Label(); this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();this.sqlInsertCommand2 = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapter2 = new System.Data.SqlClient.SqlDataAdapter();this.SuspendLayout(); // // button1 // this.button1.Location = new System.Drawing.Point(184, 168); this.button1.Name = "button1";this.button1.Size = new System.Drawing.Size(96, 23); this.button1.TabIndex = 0;this.button1.Text = "Add A Movie"; this.button1.Click += new System.EventHandler(this.button1_Click); // // button2 // this.button2.Location = new System.Drawing.Point(184, 248); this.button2.Name = "button2";this.button2.Size = new System.Drawing.Size(96, 23); this.button2.TabIndex = 1;this.button2.Text = "Delete A Movie"; this.button2.Click += new System.EventHandler(this.button2_Click); // // button3 // this.button3.Location = new System.Drawing.Point(184, 208); this.button3.Name = "button3";this.button3.Size = new System.Drawing.Size(96, 23); this.button3.TabIndex = 2;this.button3.Text = "View Movies"; this.button3.Click += new System.EventHandler(this.button3_Click); // // label1 // this.label1.Font = new System.Drawing.Font("Myriad Web Pro", 14.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.label1.Location = new System.Drawing.Point(280, 8);this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(120, 24);this.label1.TabIndex = 3; this.label1.Text = "MOVIEBASE"; // // button4 // this.button4.Location = new System.Drawing.Point(448, 344); this.button4.Name = "button4";this.button4.Size = new System.Drawing.Size(192, 23); this.button4.TabIndex = 4;this.button4.Text = "Current Movie Count"; this.button4.Click += new System.EventHandler(this.button4_Click); // // button5 // this.button5.Location = new System.Drawing.Point(496, 112); this.button5.Name = "button5";this.button5.Size = new System.Drawing.Size(128, 32); this.button5.TabIndex = 5;this.button5.Text = "Find Movie"; this.button5.Click += new System.EventHandler(this.button5_Click); // // sqlConnection1 // this.sqlConnection1.ConnectionString = "workstation id=SHERMAN;packet size=4096;integrated security=SSPI;data source="SHE" + "RMAN\SQLEXPRESS";persist security info=False;initial catalog=MovieDBase";this.sqlConnection1.InfoMessage += new System.Data.SqlClient.SqlInfoMessageEventHandler(this.sqlConnection1_InfoMessage); // // GengreList // this.GengreList.BackColor = System.Drawing.SystemColors.InactiveCaptionText;this.GengreList.Items.AddRange(new object[] { "Horror", "Comedy", "Family/Entertainment", "Drama", "Boxsets", "Sci -fi/Fantasy"});this.GengreList.Location = new System.Drawing.Point(184, 344); this.GengreList.Name = "GengreList";this.GengreList.Size = new System.Drawing.Size(121, 21); this.GengreList.TabIndex = 6; // // button6 // this.button6.Location = new System.Drawing.Point(264, 104); this.button6.Name = "button6";this.button6.Size = new System.Drawing.Size(160, 40); this.button6.TabIndex = 7;this.button6.Text = "View Movie List"; this.button6.Click += new System.EventHandler(this.button6_Click); // // button7 // this.button7.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.button7.Location = new System.Drawing.Point(360, 432);this.button7.Name = "button7"; this.button7.Size = new System.Drawing.Size(104, 40);this.button7.TabIndex = 8; this.button7.Text = "Exit Movie Base";this.button7.Click += new System.EventHandler(this.button7_Click); // // sqlSelectCommand1 // this.sqlSelectCommand1.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" + "Table 1]";this.sqlSelectCommand1.Connection = this.sqlConnection1; // // sqlInsertCommand1 // this.sqlInsertCommand1.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," + " Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" + "umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand1.Connection = this.sqlConnection1; this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release")); this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director")); // // sqlDataAdapter1 // this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1; this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"), new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"), new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})}); this.sqlDataAdapter1.RowUpdated += new System.Data.SqlClient.SqlRowUpdatedEventHandler(this.sqlDataAdapter1_RowUpdated); // // label2 // this.label2.Font = new System.Drawing.Font("Myriad Web Pro", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(0))); this.label2.Location = new System.Drawing.Point(64, 344);this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(120, 23);this.label2.TabIndex = 9; this.label2.Text = "Genres"; // // sqlSelectCommand2 // this.sqlSelectCommand2.CommandText = "SELECT [Item Number], [Movie Title], Genre, [Date of Release], Director FROM [Mov" + "Table 1]";this.sqlSelectCommand2.Connection = this.sqlConnection1; // // sqlInsertCommand2 // this.sqlInsertCommand2.CommandText = "INSERT INTO [MovTable 1] ([Item Number], [Movie Title], Genre, [Date of Release]," + " Director) VALUES (@Param1, @Param2, @Genre, @Param3, @Director); SELECT [Item N" + "umber], [Movie Title], Genre, [Date of Release], Director FROM [MovTable 1]";this.sqlInsertCommand2.Connection = this.sqlConnection1; this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.VarChar, 50, "Item Number"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param2", System.Data.SqlDbType.VarChar, 50, "Movie Title")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Genre", System.Data.SqlDbType.VarChar, 50, "Genre"));this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param3", System.Data.SqlDbType.VarChar, 50, "Date of Release")); this.sqlInsertCommand2.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Director", System.Data.SqlDbType.VarChar, 50, "Director")); // // sqlDataAdapter2 // this.sqlDataAdapter2.InsertCommand = this.sqlInsertCommand2; this.sqlDataAdapter2.SelectCommand = this.sqlSelectCommand2;this.sqlDataAdapter2.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "MovTable 1", new System.Data.Common.DataColumnMapping[] {new System.Data.Common.DataColumnMapping("Item Number", "Item Number"), new System.Data.Common.DataColumnMapping("Movie Title", "Movie Title"),new System.Data.Common.DataColumnMapping("Genre", "Genre"), new System.Data.Common.DataColumnMapping("Date of Release", "Date of Release"),new System.Data.Common.DataColumnMapping("Director", "Director")})}); // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.BackColor = System.Drawing.SystemColors.InactiveCaption;this.BackgroundImage = ((System.Drawing.Image)(resources.GetObject("$this.BackgroundImage"))); this.ClientSize = new System.Drawing.Size(704, 502);this.Controls.Add(this.label2); this.Controls.Add(this.button7);this.Controls.Add(this.button6); this.Controls.Add(this.GengreList);this.Controls.Add(this.button5); this.Controls.Add(this.button4);this.Controls.Add(this.label1); this.Controls.Add(this.button3);this.Controls.Add(this.button2); this.Controls.Add(this.button1);this.Name = "Form1"; this.Text = "Form1";this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread]static void Main() {Application.Run(new Form1());
Hi All, I am trying to connect to an SQL SERVER in a remote production server from ASP.net using following code. Dim conProd As New OleDbConnection("Provider=SQLOLEDB.1;Data Source=ServerName;UID=User Name;PWD=Password;Initial Catalog=Database")conProd.Open()I am getting following error while running this script [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. But I am able to connect to this server using following three other ways:1) Using query analyzer2) I created DSN and performed test connection, it succeded.3) In ASP.NET -> Server Explorer -> Data Connections, I added this connection and test connection also successful.I tried to connect to this server in VB 6.0 using following code Dim conProd As New ADODB.ConnectionconProd.Open "Provider=SQLOLEDB;Data Source=ServerName;Initial Catalog=Database; Timeout=500;", "UserName", "Password" I am able to connect using this above code in VB 6.0 also.But I dont what is happeing in .NET. Please help me. I am using XP and VS .NET 2003
I just installed MSDE but when I try to connect to a database or create a new database I get the following message:"Microsoft ASP.NET Web MatrixUnable to connect to the database.General network error. Check your network documentation.ConnectionRead (rec()).TDS buffer length too largeTDS buffer length too large"Can anyone tell me how to correct this problem?Thanks,
I have set up a database in SQL Server 2005 (The express version) and am trying unsucessfully to make a connection to it from MS Visual Web Developer 2005 Express version. I always get the same error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this error 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 open a connection to SQL Server)" How can I set up SQL Server to allow remote connections? I am trying to establish a connection from my web page to this database. Is there a user that I need to establish on the SQL Server side?
I upgraded my 6.5 server to 7.0 two days ago running into small problems with the database upgrade wizard. I had some small problems with security which took me some time but was not that difficult once I figured it out. I then proceeded to switch back to 6.5 mode to transfer all the data that had been done that day to my development machine so I could then import it to the SQL 7.0 version. When I was done with the transfer I switched back successfully, started the server successfully, but I was unable to connect. I get the error "Connection could not be established...", so after several attempts to connect and shuting the server down I now am at a loss. The server runs fine in 6.5 mode but it will not connect in 7.0?? Tonight I am going to try to reinstall SP1, if that does not work I am going to try to reinstall SQL 7.0. Any suggestions???
On a fresh installation of SQL Server 6.5, I have opened the EM and registered the server but am unable to connect. I get the error of 'A connection could not be established to [ServerName]- [DB-Library] Unable to connect: SQL Server is unavailable or does not exist. General Network Error. Check your documentation.'
I've tried connecting with all different DB-Lib settings to no avail. Ultimately, I want to use TCP/IP. I am, however, able to connect to other SQL Server boxes from this EM, just not the local server. I am able to stop and start the services from Control Panel and from SQL Service Manager.
Since I haven't been able to log into the local SQL Server, I've registered the server in EM to log in with sa and a blank password. I've already completely uninstalled SQL and reinstalled it to see if that would help. It didn't.
Does anyone have any idea what the problem could be?
Hi, I am connected to SQl server 7.0 thru TCP/IP .when I run Profiler I get a message like this - "[MS ODBC SQL Server Driver]The operation could not be completed b'coz your security context could not be impersonated." I tried using NamedPipes/MultiProtocol N/wLibrary but then also it do not work? Any idea.... TIA Pd
I am running SQL 2000 on Windows 2000 Server. The clients are running different OS ranging from Win 98/NT/2000. Although i am able to connect to the local host, but whenever i try to connect over the network the following error pops up :
unable to connect to server <server name> Server : Msg 11, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][TCP/IP Socket]General network error. Check your network documentation.
I checked up the event long on the server and found the following entry:
Event Type: Warning Event Source: MSSQL$NETSDK Event Category: (8) Event ID: 19011 Date: 1/20/2003 Time: 2:12:32 PM User: N/A Computer: <computer name> Description: The description for Event ID ( 19011 ) in Source ( MSSQL$NETSDK ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: (SpnRegister) : Error 1355.
May i further clarify that this error started today n till last week end (saturday, i am
stationed in India) there was no problem and the users were able to connect to the server
without any problem. My network engineer feels that its an sql problem and has nothing to do with network related issues.
i would appreciate if anybody could help me out. thanking in advance
recently i made my PC dual boot by installing windows 2000 advanced server. It already had win2000 profesional installed on it. since then i have been unable to connect to sql server running on some other server(called CONTROLS) on the LAN. I am able to access the CONTROLS server thru 'my networkplaces' and able to see all its hsared directories and access htem. but when i open Enterprise manager i cannot connect to CONTROLS. Please help me . i have already wasted 2 days over it.
I have 2 machines JAWS (publisher/distributor) and PSG (subscriber) on trusted domains. MSSQL & SQLExec services of both machines run under the local NT Administrator account
username: Administrator password: XXXX
this NT Administrator account has the same username and password on both machines. Their network protocols are named pipes. After I set up replication following the sql manual, the LogReader, Distribution and Sync tasks all report the error "unable to connect to JAWS". I'm wondering what else I need to do. Any help are greatly appreciated. Thanks,
