sql server connection

  • Hi Every body,

    Just know i had install MS SQL SERVER 2005 in my system.

    But it is not connecting it is asking server name there what i had given the server name could you any body please suggest me

    i am using . or SA but it is not connecting

    Thanks

  • Hi,

    Just doublechecking but is the SQL Server service really up and running?

    Doublecheck the server name in the errorlog (you'll find it in %\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG), there is an entry "Server name is....".

    Can you confirm you have entries like:

    Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].

    Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].

    Server is listening on [ 'any' 1434].

    Server is listening on [ 'any' 1434].

    Are you trying to connect to a local SQL Server or over the network?

    Please provide the error message as well 🙂

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • is it a default or named instance?

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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