Hi Ken, I ahve a couple of questions: Are you testing from the SQL Server, Does your SQL Installation have both SQL Mode and Windows Authentication enabled? What Protocols do youhave enabled to support authentication? Go to Programs SQL Server 2008\Configuration Tools\SQL Server Configuration Manager and check to ensure you have TCP enabled. Also, check the port and ensure the Windows Firewall rules allow the port you are using as a test you can turn off windows Firewal for the appropriate membership (Domain, Private, and Pubic). However, what happens when you use the Adminisrative Tools\DataSource (ODBC) to setup the connection instead of using a script. Reference: http://msdn.microsoft.com/en-us/library/windows/desktop/ms711810(v=vs.85).aspx and http://msdn.microsoft.com/en-us/library/aa937531(v=sql.80).aspx Happy New Year, -IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.

I used Windows authentication instead of SQL Server authentication, which requires User name and password, and (local) instance and got successful connection to AlphaSQL database and tables in database. The TCP/IP was enabled and port set to 1433. I was able to get connection to SQL Server in local mode and able to create sample database and some sample tables. I have yet to be able to get a connection with SQLEXPRESS instance, as I keep getting the normal error you get if you do not have TCP/IP enabled, even though I have gone thru every tutorial to fix problem, Firewall is controlled by Norton Security on my Win 7 system, even though I turn off Firewall when attempting connection. Do not have that problem with Win XP system with firewall controlled by Windows. Just trying to connect to external SQL Server database with my Alpha Software Devdelopment system, thru its connection strings. Now that it is working, that is all I care. Do not need remote connection. Just looking to connect to third party application databases to create websites from that data.

I have installed SQL Server on Win XP system. Have created a SQL Server database (AlphaSQL). Have created 2 tables, Customer and Notes. Have created a Login in Security with User name of AlphaSQL and password of alpha following tutorial sqla5. Go to A5V11, tools, external database, alphaDAO, new, Connection name AlphaSQL, select build, SQL Server. Enter User name of AlphaSQL and password of alpha and test connection. Get following error mesaage - [Microsoft] SQL Server Native Client 10.0[SQL Server]Login failed for user AlphaSQL SQL State is:2800. [Microsoft] DQL Server Native Client 10.0 Packet size change not supported by server, default SQL atate is: IM006.

Hi Ken, I ahve a couple of questions: Are you testing from the SQL Server, Does your SQL Installation have both SQL Mode and Windows Authentication enabled? What Protocols do youhave enabled to support authentication? Go to Programs SQL Server 2008\Configuration Tools\SQL Server Configuration Manager and check to ensure you have TCP enabled. Also, check the port and ensure the Windows Firewall rules allow the port you are using as a test you can turn off windows Firewal for the appropriate membership (Domain, Private, and Pubic). However, what happens when you use the Adminisrative Tools\DataSource (ODBC) to setup the connection instead of using a script. Reference: http://msdn.microsoft.com/en-us/library/windows/desktop/ms711810(v=vs.85).aspx and http://msdn.microsoft.com/en-us/library/aa937531(v=sql.80).aspx Happy New Year, -IvanIvan Sanders My LinkedIn Profile, My Blog, @iasanders.

I used Windows authentication instead of SQL Server authentication, which requires User name and password, and (local) instance and got successful connection to AlphaSQL database and tables in database. The TCP/IP was enabled and port set to 1433. I was able to get connection to SQL Server in local mode and able to create sample database and some sample tables. I have yet to be able to get a connection with SQLEXPRESS instance, as I keep getting the normal error you get if you do not have TCP/IP enabled, even though I have gone thru every tutorial to fix problem, Firewall is controlled by Norton Security on my Win 7 system, even though I turn off Firewall when attempting connection. Do not have that problem with Win XP system with firewall controlled by Windows. Just trying to connect to external SQL Server database with my Alpha Software Devdelopment system, thru its connection strings. Now that it is working, that is all I care. Do not need remote connection. Just looking to connect to third party application databases to create websites from that data.