Error Number 233 Severity 20
here for a quick overview of the site Help Center cannot alter the login 'sa' error 15151 Detailed answers to any questions you might have Meta Discuss change sa password sql 2012 the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Can no longer login to SQL Server 2008 R2 up vote 1 down vote favorite Not sure what might have caused it, I ended task on some SQL processes in task manager then restarted the computer. Now I can no longer login to SQL Server 2008 R2. This is the error I get when attempting to login: ================================== Cannot connect to JSMITH. =================================== A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider) ------------------------------ For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476 ------------------------------ Error Number: 2 Severity: 20 State: 0 ------------------------------ Program Location: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnectio
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Asked by: (Microsoft SQL Server, Error: 233) SQL Server > SQL Server Data Access Question 0 Sign in to http://stackoverflow.com/questions/10004381/can-no-longer-login-to-sql-server-2008-r2 vote
Hi, i hv installed SQL Server 2008 (Code Name Katmai), On my Windows XP SP-2. i was able to Connect with Sql Server (Database Engine) . Later I install https://social.msdn.microsoft.com/Forums/sqlserver/en-US/127f02e3-bc5b-4f5d-99a3-ea1cf0e9fdbc/microsoft-sql-server-error-233?forum=sqldataaccess VS 2008 , Full Install. after that i am not able to Connect with Sql server but Server Name. i am getting fallowing Error =================================== Cannot connect to ZING. =================================== 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 ------------------------------Server Name: ZINGError Number: 233Severity: 20State: 0 ------------------------------Program Location: 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 asyncRefor Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to https://www.experts-exchange.com/questions/28195027/Cannot-log-in-to-SQL-server-database-problems.html Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Cannot log in to SQL server/database problems Want to Advertise Here? Solved Cannot log in to SQL server/database problems Posted on 2013-07-25 MS SQL Server 2008 2 Verified Solutions 3 Comments 1,571 Views Last Modified: 2013-08-01 The story goes like this. Our website offers error number online account applications. The captured, sensitive data is written to a separate database on a secure server (separate from the main DotNetNuke DB). I discovered that a completed app didn't get written to the secure DB. To troubleshoot, I logged in to SQL Server 2008 R2 (Windows Server 2008 R2) to open the DB table and confirm data wasn't there. When trying to expand the database tree, I received this error number 233 error message. It also popped up when I tried to right click and view properties. Failed to retrieve data for this request microsoft.sqlserver.management.sdk.sfc select permission was denied. The SELECT permission was denied on the object 'extended_properties', database 'mssqlsystemresource', schema 'sys'. (Microsoft SQL Server, Error: 229) I sent a couple of test applications through after that, and they landed in the DB as they should. Maybe the lost data was an anomaly, but I still wanted to check the DB table before calling the customer and having the company look bad. So I logged back in to SS and took the DB offline (no error message on that move). This didn't help. I didn't immediately put the DB back online. I logged out for a while, When I tried to log back in, this is the error I got: Can't Connect to ADFSQL/ADF =================================== 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 ------------------------------ Server Name: ABC\ABC Error Number: 233 Severity: 20 State: 0 ------------------------------ Program Location: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.T