Home » SQL Server

Microsoft SQL server error:233

I am getting this error when connecting to sql. I cant get into my databases now- its pretty ugly.

"A connection was succesfulyl established with the server, but then an error occured during the login process.

(provider: Shared Memeory Provoder, error: 0 - No Process is on the other end of the pipe.)Microsoft SQL server error:233

Anyone who knows what is going on soem help would be much appreciated.



16 Answers Found


Answer 1

Which application do you use connecting to sql  Server ? Did you try another one ? Did you try to see if there are any event log entires for the time trying to connect ?

Jens K. Suessmeyer



Answer 2

You may also want to try connecting with a different login if you haven't already.


Answer 3

Thanks for the answers guys. I tried every possible login to no avail. I ended up having to remove visual studio, sql  server 2005 then .NET framwork. Then reinstalling in that order. Just removing/reinstalling SQL did not work. Took around 5 hours all up.

Pretty soul destroying stuff but thems the breaks I guess.


Answer 4

You could try first checking if the following protocols are enabled from the SQL Server Configuration Manager:

1. Named Pipes


Also, check from the Surface Area Configuration Manager to find out if your SQL Express Instance is configured to accept remote connections.

Please refer the following link for more help:




Answer 5

OUCH! Thanks for posting your resolution. I would have hoped you could have found a less drastic measure.



Answer 6

I meet , restart your database. To restart your databse at "SQL Server Configuration Manager.


Answer 7

hie.. all the solutions are right..
after trying all.. see your sql  server agent[ sql server  configuration manager] also start your server from run-->services.msc]
it might be stopped.. if it is so.. make it connected from both way i mentioned..

me too getting same error...


Answer 8

After several frustrating attempts to get this resolved, I completed the following steps to resolve the "Microsoft sql  Server, Errorf:233.  

1. Log into an administrative account that has access to both the machine and sql server  2005 database
2. Open up SQL Server Management studio with "Windows Authentication" 
3. Click on the security folder
4. Click on "logins"
5. Then click on the account that is not working 
6. Answer - Make sure there is a database within the "Database Default"  specified "I placed the admin account to master"

In my case there was no database specified within the default which put the login into limbo causing the Error:233


Answer 9

After restarting the SQL server, i'm able to connect to the Database from my application.

Answer 10

I had similar issue.


I had an user on SQl as abc(name changed), I deleted the user and without rebooting I created a user with same name as "abc", and tried login to SQL with abc credentials.
A connection was succesfulyl established with the server, but then an error  occured during the login process.

(provider: Shared Memeory Provoder, error: 0 - No Process is on the other end of the pipe.)Microsoft SQL server  error:233

I created another user xyz and tried login with same xyz and I was able to login.
Then I rebooted the machine and tested with abc account and I was able to login.

Now I deleted xyz and created xyz again, now I was not able to login with xyz with same error.

It seems when we deleted a user SQL Server requires a reboot, if we want to create user with same name again.

Answer 11

Make sure the user is not disabled

1. Login as an Administrator into the SqL Server
2. Expand Security/ Logins folder
3. Right Click on the particular user and go to properties
4. Click Status Permission: Granted
 Login : Enabled

It worked for me after it is enabled


Answer 12

1. Login as Administartor
2. Right click on the Instance name - Server Properties
3. Security page
4. Set the Server Authentication - 'SQL Server and Windows Authentication mode'
5. Restart the SQL Service

Answer 13

I have suddenly this same problem with an express 2005 running on XP for years. I've tried evrything you suggested to no avail! the sa login is now useless. Any new suggestion?




Answer 14



Thanks Guys its worked for me.Especially Thanks 2 Moshez


Answer 15

Thanks for the answers ,i tried everything from the start of the post ,my sql  server had everything mentioned here like allow remote connections,tcp/ip,in security in login the user allowed,default db set.finally the one that worked for me was a simple step go to the services and click sql server  and stop it and then start it again there,it worked :-) cant believe this simple thing kept me wondering for hours how to fix it



Answer 16

Goto Services.msc and start "SQL Server Browser" Service. It will work.





I try to connect with PDO to my SQL Server 2008 Express.

$DBO = new PDO( "sqlsrv:(\SQLEXPRESS)", NULL, NULL, array('Database' => "mydatabase") );

I always receive this error:

Error!: [08001][Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].

I can connect to the AdvantureWork expample database with:

$serverName = "(local)\sqlexpress";
$connectionOptions = array("Database"=>"AdventureWorks");

/* Connect using Windows Authentication. */
$conn = sqlsrv_connect( $serverName, $connectionOptions);


Any idea why I cannot connect with PDO?




Database error: Cannot connect ot Database: [Microsoft][SQL Server Native Client 10.0][SQL Server]Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
ODBC Error
Session halted.


$host = "tcp:s6s1aw1dwr.database.windows.net";
 $dbname = "internet";
 $dbuser = "skytech@s6s1aw1dwr";
 $dbpwd = "******";
 $driver = "{SQL Server Native Client 10.0}";


let me know what could be the reason ?


Hi All,

 we are migrating an 32 application from win server 2003 to win server 2008 R2  64 bit machine, as part of that i created a ODBC component to access database , userid and password to this ODBC component is obtained from a registry

when trying to get it from registry i am getting the following error:

Error Establishing Data Connection-[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ''.

path which i gave to access the registry key values are :

const RegistryPathForKey = "\SOFTWARE\Wow6432Node\Microsoft\<specific values to my project>\

i created ODBC component from syswow64--> odbcad32.exe

created registry keys under node wow6432node

i tried to hardcord the values though i was able to continue with my application , later i got one more problem , there was error in creating the objects for com+ application and my application did not work

kindly help in any way on this

Thanks in Advance,

Fayaz K

Hi All,

Several weeks ago I created a compressed back up in ms sql 2008 enterprise version.  I am trying to experiment with the Restore capability and getting the BELOW error.  I am trying to restore the database using the Restore Database GUI.

The database size was 250GB and after creating the backup it became 104GB. I selected the database From a Device option. I created this backup on Windows 2008 and copied that file into my Vista Ultimate computer and trying to restore at that computer.

When I go to the actual server to restore the database it seems it picks up the right database without getting any error. But I don't want to take any chance and I want to test this backup in a different computer, with ms sql 2008?

What Am I missing?

The media family on device 'I:\HumanFinders\Drive_E\SQL_Backup\HumanFind\HumanFind_20090321' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)
MicroSoft SQL Server, Error: 3241



An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteWithResults(String query)
   at Microsoft.SqlServer.Management.Smo.BackupRestoreBase.ExecuteSqlWithResults(Server server, String cmd)
   at Microsoft.SqlServer.Management.Smo.Restore.ReadBackupHeader(Server srv)
   at Microsoft.SqlServer.Management.SqlManagerUI.SqlRestoreDatabaseGeneral.buttonSelectDevice_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


The media family on device 'I:\HumanFinders\Drive_E\SQL_Backup\HumanFind\HumanFind_20090321' is incorrectly formed. SQL Server cannot process this media family.
RESTORE HEADERONLY is terminating abnormally. (.Net SqlClient Data Provider)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=3241&LinkId=20476

Server Name: DORON
Error Number: 3241
Severity: 16
State: 0
Line Number: 1

Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteWithResults(String sqlCommand)


I have a MSSQL 2008 on a windows 2008 server.

I cant delete a publication that isnt in use anymore i get the following error.

TITLE: Microsoft SQL Server Management Studio

Could not delete publication 'TASS Publication'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22&EvtSrc=Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Replication.ReplicationMenuItem&EvtID=CantDeletePublication&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission.
Changed database context to 'tass'. (Microsoft SQL Server, Error: 15517)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531&EvtSrc=MSSQLServer&EvtID=15517&LinkId=20476




I have tried to delete it by right clicking and delete. I have tried by query.


execsp_droppublication @publication =N'<sqlServerName>'


I have looked at many forums.

I am trying to do this as 'sa'.

Do you have any suggestions?


I have written this SQL query in query designer in Report Builder

When I run it I appear to be getting the following message:

Cannot call methods on int (Microsoft SQL server, error: 258). Does anyone know why I am getting this. In theory this query should work.


AccountsContacts.ContactID AS [AccountsContacts ContactID]









,Enquiries.ContactID AS [Enquiries ContactID]




inner JOIN Enquiries ON Enquiries.ContactID = AccountsContacts.ContactID


Enquiries.EnquiryID = @Enquiries.EnquiryID


I can not install Sql server R2 in Windows Server 2003 R2 .

i try to install manualy .Net Framework 3.0 and 3.5 but didn;t suceed.

i try to install Windows Update but update installation got a error and not installe

please give me instruction.



I've trying searching around but i really can't find an answer.



Error:3201.. I'm trying to change the directory and still it permission denied. Please help.



I dunno everytime I use DRIVER={SQL Server};SERVER=localhost;UID=;PWD=; under the provided string it works but when I change the server into my other machine host this error occure.


Please help.


SQL server 2000 with remote clients at 3 locations. Sites had been connected via leased line. We switched everything to internet/VPN. Everything works, but a several times a day, the clients receive this error:

Microsoft SQL Server Login
Connection failed:
SQL State: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
Connection open
(connect ( ) )
Connection failed:
SQL State: '08001'
SQL Server Error: 17

If they exit and log back in, then it's OK. Here's what has changed:

New ISP at HQ and remote sites with new static IPs. New firewalls/VPN setup. VPNs setup to alloow all traffic between sites. Internal IP addresses/computer names did not change. Only exception is the HQ gateway is different, but all network settings were updated to reflect that. I have all of the remote firewalls pinging the HQ firewall every 30 seconds and have not seen any hint of a problem in the firewall logs. Seems to be isolated to SQL. None of the SQL server or client configs were touched. I know little about SQL. What do the errors above mean and does anyone have any ideas? THANKS!


1. Two node cluster - node1, node2
2. Windows 2008
3. SQL Server 2005 SP3 (with Critical Update package 10)
4. Each node has an active instance.
    node1: virtualnameA\instanceX
    node2: virtualnameB\instanceY
5. Windows XP client

From client, using SSMS I can connect to both instances i.e. virtualnameA\instanceX and virtualnameB\instanceY.

From node1, using SSMS I can connect to virtualnameA\instanceX but not virtualnameB\instanceY.
From node2, using SSMS I can connect to virtualnameB\instanceY but not virtualnameA\instanceX.
I get this error 26.

This error message popped up when when I tried to connect to virtualnameA\instanceX from node2
TITLE: Connect to Server
Cannot connect to virtualnameA\instanceX.

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

I have tried this but this is not the issue:

Appreciate your feedback and clues.




I have used the following query for a dataset:








Not too sure what am i missing that it jus prompt me error and not filling up the blank 'jobname' column with data from TABLEB..JOBB

how can I reinstall this *.dll file ??
I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500


Microsoft SQL Server 2005 Express
Windows XP service pack 3

When trying to install Microsoft SQL server 2005 Express following error keeps coming up:
Error 1603 installing Microsoft SQL Server 2005 Setup Support Files

Below is from the log:
MSI (s) (98:F8) [15:11:00:015]: Note: 1: 1708
MSI (s) (98:F8) [15:11:00:015]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

MSI (s) (98:F8) [15:11:00:015]: Cleaning up uninstalled install packages, if any exist
MSI (s) (98:F8) [15:11:00:015]: MainEngineThread is returning 1603
MSI (s) (98:9C) [15:11:00:125]: Destroying RemoteAPI object.
MSI (s) (98:D0) [15:11:00:125]: Custom Action Manager thread ending.
=== Logging stopped: 18/08/2010  15:11:00 ===
MSI (c) (B8:10) [15:11:00:125]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.  Counter after decrement: -1
MSI (c) (B8:10) [15:11:00:125]: MainEngineThread is returning 1603
=== Verbose logging stopped: 18/08/2010  15:11:00 ===

Looks like some entries in the registry database are left even after uninstalling using the Add/Remove programs. so I have tried to remove the following manually after having used Addemove software:
* C:\Program Files\Microsoft SQL Server
* "The Microsoft SQL Server" key (and all its sub-keys) under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\
* All keys related to SQL Server under HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001
* All keys related to SQL Server under HKEY_LOCAL_MACHINE\SYSTEM\ControlSet004

Still get the error.

I know that Error 1603 has been posted before in this forum but I don't seem to find the solution for this problem in the answers (maybe I am missing something).

Any suggestions will be very much appreciated.

Thanks in advance

I'm trying to install an update of  Microsoft SQL Server 2005 but an error is always occurring. Error is 737d n sometime 2fe4


I was able to do my work with ease on my Database server, until sometime Friday evening. Don’t exactly know what transpired, only that I can now no longer run queries or even create new databases. Here is a sample of what happens when I try to create a database

CreateDatabase PetitionSample

Msg 262, Level 14, State 1, Line 1

CREATE DATABASE permission denied in database 'master'.

I used to be able to create databases, create new users and so on. My Server is installed on a Vista machine and I am running Developer version and using Management studio 2008 to access it. Anyone have any idea what could be going on?



Iam using MSSQL Server 2008 Developer Edition.  Iam not able to login using windows authentication through Microsoft SQL Server Management Studio.  When i try to login it through  the error message  ( Login failed for user testserver\administrator (Microsoft SQL Server,Error:  18456))

but iam able to login successfully using sa account.

OS Version:  windows 2008 standad Edition R2

DataBase  :  MSSQL 2008 Developer Edition.

Any one can help me on this? Thanks







I have Client - Server system where client is MS access 2007 and server database is SQL server 2008. Conversion happened recently from MS Access 2003 and SQL Server 2005. User suddenly experiences these kind of error which they never encountered. Please help.


Microsoft SQL Server Login


Connection failed:

SQLState: '28000'

SQL Server Error: 18452

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.


MS Access uses ADO connectivity to connect to SQL server 2008.

Connectionstring the application uses is,

"ODBC;DRIVER=SQL Server;SERVER=CT2WP010.svr.us.companyname.net;DATABASE=AMLMetrics;Trusted_Connection=Yes"


Please help !!!



I am trying to synchronize two databases and getting the below error.  I am using Microsoft SQL Server Management Studio 2008 to sync the two databases.  One of the databases is running Analysis Services 2008SP1 (the source) and the other is running Analysis Services 2008R2 (the destination).  I have tried the Microsoft SQL Server 2005 Backward Compatibility tool and that did not work.  My thought is that the different versions are causing a conflict.  The surprising thing is that it appears to be working and then fails.  Keep in mind I am using an administrator account.  Can someone please advise?

Thanks,  A.L.

Total Size=20563KB

Errors in the OLE DB provider. The server returned the following error:  (The OlapInfo element at line 1, column 1586 (namespace ) cannot appear under Envelope/Body/Execute/Command/InternalSynch/BackupLog.). 

Backup and restore errors: An error occurred while synchronizing the 'as_CFR' database. 

Server: The operation has been cancelled. 

Backup and restore errors: An error occurred while synchronizing the 'as_CFR' database. 

Database synchronization failed.


<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure