none
SQL Server Connectivity Issue

    Question

  • Dear All,

    I am facing a very strange problem in SQL Server(2008 R2) Connectivity with SQL Client(Windows CE .5) Scanners. Everything was working perfectly and then i restart the server(Windows Server 2012 Std) :(

    I am able to Ping Server with IP/Name. Now the Problem Is What. POS has also the same Database as Scanners But Scanners are unable to connect(Sometimes Connecting, Sometimes SQL Connectivity Error). POS tables are working just perfectly But Scanner Tables are not working fine. I drop and reCreate Database with all it's data, Now Scanner were able to connect with Server But after sometimes same issue is on the New Database. 

    Can anyone help me what's happening there :(

    Thanks


    Jazaib Hussain

    Thursday, July 04, 2013 7:37 PM

All replies

  • Go to configuration manager and start the services

    k

    Thursday, July 04, 2013 8:25 PM
  • Dear, 

    All the Services are running fine... Server Browser and SQL Server (SQLExpress) are running Automatic, While SQL Server Agent is Stopped and On Manual. 

    Named Pipe and TCP/IP is Enabled. 

    Thanks


    Jazaib Hussain

    Thursday, July 04, 2013 8:55 PM
  • you should try the build in account in sql configuration to see if it is working

    k

    Thursday, January 09, 2014 4:37 PM