Post reply

In my laptop some times sqlserver getting problem while connecting in to the instance

  • April 18, 2013 at 1:07 am

    #394617

    HI all ,

    In my laptop some times sqlserver getting problem while connecting in to the instance

    1. it is unable to connect the instance and iam checking the tcp/ip connections and all services but unable to connect in to the sqlserver

    2. every time this happens i always uninstall the sqlserver and its services and freshly installing the sqlserver then it is working for few days or few months later it happens again but unable to solve this every time

    3. iam checking these

    shared memory status enabled

    named pipes status enabled

    tcp/ip status enabled

    via status disabled

    windows firewall exception port number 1433 is added or not

    evry thing is working fine but it is unable to get connect in sqlserver [services are in not running during this period ] iam performing fresh instillation of the sqlserver How to avoid this and in which cases it happens if it happens in any server what should i do

    Thanks
    Naga.Rohitkumar

  • April 18, 2013 at 5:54 am

    #1607660

    If I understand you correctly, when you can't connect the services are not running? What happens when you start the services, can you then connect?

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------

  • April 18, 2013 at 6:10 am

    #1607674

    1. Don't uninstall and then reinstall. that's not going to help resolve the issue, even though it "seems" to.

    2. we really need the exact error you get. that tells us a lot.

    3. Not sure if the SQL server is located on the laptop, or the laptop connot connect to a server that exists ont he network. you need to clarify that.

    4. If SQL server is on the laptop, the connection problem is probably due to services not running(stopped locally) .

    When that happens, Go To Administrative Tools>>Services and start them:

    5. If the issue is because the laptop doesn't seem to connect to a different machine on the network that happens to have SQL server, it's often related to netowrk / DNS issues (the network assigns you an IP address when you connect, and that can change) so any cached settings on where to find a server might not work.

    logging off the domain, and then logging on usually fixes that.

    can you give us more details on the problem?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply