MS SQL Server Error 233

Hi,
When I try to login to SQL Server 2005 from Microsoft SQL Server Management
Studio, I got following:
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.) (Microsoft SQL Server,
Error: 233)
I use the "SQL Server authentication" mode and user name and password seems
correct.
I went to the "Surface Area Configuration for Services and Connections" and
check the "Remote Connections" under "Database Engine", it is "Using TCP/IP
only".
Also I checked "SQL Server Configuration Manager", under "SQL Server 2005
Network Configuration" -> "Protocols for MSSQLSERVER", "Shared Memory",
"Named Pipes" and "TCP/IP" are all "Enabled"
Please advise!
Thanks!
enable tcp/ip and you are good to go.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
sql

MS SQL Server Database Connection Problems

Hi

I can connect successfully to the Microsoft SQL Server "Beauty" (get also nonzero for successfull connection). If i run the application (see code below). I get following Error Message "Illegal Objectname 'TestTabelle' ". I double checked the SQL statement and it should be correct. Even the spelling of TestTabelle is right. For testing purposes I've also included 5-6 data records in the tabel.

I try to connect via ODBC. I've created the database with MS SQL Enterprise Manager. Right Click -> Create New Database. I called it "Test" and created in "Test" a new Table, which is called "TestTabelle".

I found information how i can connect to a ms sql server "Beauty", i've also found how i can connect to a table, BUT where is the information which Database ?`in my case it should be Test.

how can i setup a default database... Cause in my application i can't access my Test Database.... See code below :(

Why is this code BOLD not working if i try to select a database ?

Thank You
Indian

{
CDBVariant value;
char sql_statement [2048] = "";

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("DSN=Beauty;UID=Administrator"), CDatabase::noOdbcDialog);

//CRecordset object "rs" created to access and manipulate database records.
CRecordset rs(&db);
strcpy(sql_statement,_T("SELECT * FROM TestTabelle")); <- NOT WORKING... GETTING ERROR MESSAGE if i use this sql_statement " USE TEST; SELECT * FROM TestTabelle"
rs.Open(CRecordset::forwardOnly,sql_statement);

//Get quantity from Database
int n = rs.GetODBCFieldCount( );
while(!rs.IsEOF())
{
for( int i = 0; i < n; i++ )
{
rs.GetFieldValue("index",value);
m_Buy_List.InsertItem(i,LPCTSTR(value.m_pstring));

rs.GetFieldValue("product",value);
m_Buy_List.SetItemText(i,2,LPCTSTR(value.m_pstring ));

rs.GetFieldValue("price",value);
m_Buy_List.SetItemText(i,3,LPCTSTR(value.m_pstring ));
}
rs.MoveNext( );
}

//Close records access.
rs.Close( );

//Close database connection.
db.Close();

}double-click on Administrator (login) and select the default database from the drop-down box at the bottom of this dialog box.|||Better yet, use a more explicit query. Try:

strcpy(sql_statement,_T("SELECT * FROM Test.TestTabelle"));|||Better yet, use a more explicit query. Try:

strcpy(sql_statement,_T("SELECT * FROM Test.TestTabelle"));|||Sorry. Just replace the line in your code.

You could also skip ODBC, and specify the database in your connection string by using OLEDB.

Try this line in your code to connect to the server...

//CDatabase object "db" created to connect database
CDatabase db;
db.OpenEx(_T("Provider=SQLOLEDB.1;Data Source=Beauty;Initial Catalog=Test;UID=Administrator"), CDatabase::noOdbcDialog);|||i figured it out

thx

MS SQL Server 2000 installation problem

Dear Members:
This is my first installation of MS SQL Server 2k on the MS Server 2000 operating system successfully. Problems begin with the installation of the MSDE 2000 Release A showing that the instance is invalid. Please help.

Quote:

Originally Posted by Wilfredopr

Dear Members:
This is my first installation of MS SQL Server 2k on the MS Server 2000 operating system successfully. Problems begin with the installation of the MSDE 2000 Release A showing that the instance is invalid. Please help.

Hello and welcome to msdner.com. As you have posted in the Members Introduction Forum, I have copied your query to the Windows Forum and moved it to the SQL Server Forum. I am hopeful that experts there may be able to help you with your SQL Server installation problems.|||http://technet2.microsoft.com/WindowsServer/en/library/937ecfe9-e8e0-41ac-85f7-4b65956f3d1e1033.mspx?mfr=true

:)

Quote:

Originally Posted by Wilfredopr

Dear Members:
This is my first installation of MS SQL Server 2k on the MS Server 2000 operating system successfully. Problems begin with the installation of the MSDE 2000 Release A showing that the instance is invalid. Please help.

|||

Quote:

Originally Posted by radcaesar

http://technet2.microsoft.com/WindowsServer/en/library/937ecfe9-e8e0-41ac-85f7-4b65956f3d1e1033.mspx?mfr=true

:)

Thanks to your replys. I did the following steps:(1) I reinstalled the SQL2kServer and instead of "default" i entered my instance name "microa". (2) in the MSDE2000RelA i installed a new instance name like "micro9". (3) in the upgrading MSDE2000 Sp4 i entered setup /upgradesp sqlrun INSTANCENAME=micro9 /L*v C:\msdelog.log
All the above setup was completed, now i will run into SQL and will let you know the status. Thanks again for your valuable time.