Post reply

unable to connect to localhost

  • March 20, 2012 at 10:06 am

    #266061

    HI

    I cant connect to my localhost on sql server 2008, it says the server was not found

    ive tried

    localhost

    (local)

    .\sqlexpress

    localhost\sqlexpress

    anyone any ideas where i am going wrong?

    Thanks in advance

  • March 20, 2012 at 10:07 am

    #1461742

    are the sql services running?

  • March 20, 2012 at 10:08 am

    #1461743

    Start by opening up SQL Server Configuration Manager and verifying that the services are running (SQL Server Service).

    Jared
    CE - Microsoft

  • March 20, 2012 at 10:08 am

    #1461744

    it looks like they are

    in configuration manager you mean?

    which services should i be looking for?

  • March 20, 2012 at 10:10 am

    #1461746

    can look in config manager or services.msc, looking for a state of running or started depending which you look at

  • March 20, 2012 at 10:12 am

    #1461749

    It looks like maybe you are trying to connect to sql express? Did you use a custom instance name for SQL express?

    This article may provide some insight, assuming the services are running. http://msdn.microsoft.com/en-us/library/ms365247.aspx

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • March 20, 2012 at 10:18 am

    #1461752

    anthony.green (3/20/2012)

    can look in config manager or services.msc, looking for a state of running or started depending which you look at

    which service should i be looking for?

    thanks

  • March 20, 2012 at 10:20 am

    #1461754

    dunne.neal (3/20/2012)

    anthony.green (3/20/2012)

    can look in config manager or services.msc, looking for a state of running or started depending which you look at

    which service should i be looking for?

    thanks

    MSSQLSERVER

    Jared
    CE - Microsoft

  • March 20, 2012 at 10:20 am

    #1461755

    SQL SERVER (instancename) where instancename is the name of the instance you want to connect to, if its default is MSSQLSERVER, if its named it will be the name so SQL SERVER (SQLEXPRESS)

  • March 20, 2012 at 10:26 am

    #1461761

    go to Control panel>>Administrative Tools>>Services.

    you want to make sure the service exists first.

    if it doesn't, then you probably only installed the client tools.

    if it does, look at the name of the service, as anthony identified.

    if it is named anything except MSSQLSERVER, it's a named isntance,a nd you have to include the instnace name in the connection;

    like MACHINENAME\SQLEXPRESS as seen in this screenshot.

    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!

  • March 20, 2012 at 10:26 am

    #1461762

    if i go to configuration manager the only service in the SQL Server Services list is SQL Server Integration Services 10.0

    if i go to services.msc

    then that is also the only service associated with sql server on the list

  • March 20, 2012 at 10:29 am

    #1461767

    dunne.neal (3/20/2012)

    if i go to configuration manager the only service in the SQL Server Services list is SQL Server Integration Services 10.0

    if i go to services.msc

    then that is also the only service associated with sql server on the list

    that is your problem then. You do not have database engine installed on your local machine. Should you? Most people do not need it locally, but I tend to do all my SSC testing on it.

    Jared
    CE - Microsoft

  • March 20, 2012 at 10:29 am

    #1461768

    then you dont have a local instance of SQL installed which is why you cannot connect

  • March 20, 2012 at 11:01 am

    #1461781

    sorted lads thanks a lot

Viewing 14 posts - 1 through 13 (of 13 total)

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