none
Cannot connect to SQL Server 2014 from Visual Studio 2008 RRS feed

  • Question

  • Cannot connect to SQL Server 2014 from Visual Studio 2008
    • Moved by Bob Beauchemin Wednesday, August 27, 2014 5:00 PM Moved to forum for client-side ADO.NET for best results
    Wednesday, August 27, 2014 6:45 AM

Answers

  • Replace by blow string is ok!

    <add key="CCode" value="Server=xxx.xxx.xxx.xxx\SQL2014;Initial Catalog=crp2;Integrated Security=False;User ID=sa;Password=xxxxx; Min Pool Size=10; Max Pool Size=512; Packet Size=4096; Pooling=true;"></add>

    Thank a lot  

    Wednesday, August 27, 2014 8:35 AM

All replies

  • Hello,

    Which error message are you getting?

    Is it "not supported Version of SQL Server"? The "Server Explorer" in VS 2008 supports only SQL Server 2005 and with the latest update for VS also SQL Server 2008, but not higher versions. You have to use SSMS = SQL Server Management Studio to manage SQL Server / create databases etc.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 27, 2014 7:03 AM
  • Please ensure your connection string is something like
    	<connectionStrings>
    		<add name="conn2" connectionString="Data Source=192.?.?.?\your_db_instance;Initial Catalog=your_db_schema;Integrated Security=False;User ID=your_db_login;Password=??????" providerName="System.Data.SqlClient"/>
    	</connectionStrings>
    


    within Web.config/app.config file in your project, to ensure the project will work fine with the database.

    Many Thanks & Best Regards, Hua Min

    Wednesday, August 27, 2014 7:29 AM
  •  <!--***TESTING***-->
      <crp3TSystemConfig>
          <add key="crp3Code" value="Server=SQLTESTING\SQL2014;database=crp2;uid=sa;pwd=kof1999; Min Pool Size=10; Max Pool Size=512; Packet Size=4096; Pooling=true;"></add>

    --------------

    Connection ok with ODBC Data Souce

    • Edited by Derek Hui Wednesday, August 27, 2014 8:00 AM
    Wednesday, August 27, 2014 7:54 AM
  • Can you please try to adjust it like what I've suggested?

    Many Thanks & Best Regards, Hua Min

    Wednesday, August 27, 2014 7:59 AM
  • Replace by blow string is ok!

    <add key="CCode" value="Server=xxx.xxx.xxx.xxx\SQL2014;Initial Catalog=crp2;Integrated Security=False;User ID=sa;Password=xxxxx; Min Pool Size=10; Max Pool Size=512; Packet Size=4096; Pooling=true;"></add>

    Thank a lot  

    Wednesday, August 27, 2014 8:35 AM
  • Derek, which error message are you getting? Which data Access components are you using? Cann you connect to SQL Server using SSMS?

    With that less on information it's difficult to give you further assistance.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 27, 2014 8:53 AM