Post reply

Unable to connect to Database

  • March 29, 2011 at 8:43 am

    #150128

    Hi all, I have installed SQL Server 2005 express on my PC. I also installed a few sample databases like AdventureWorks. When I try to connect to this database it gives me a connection error and I am unable to connect. Can someone please advise me , If I am doing something wrong and how to fix this error ?

    Regards

    IQ

  • March 29, 2011 at 8:47 am

    #1304926

    have you enabled remote connections? (from memory this defaults to off for express)

    and started SQL browser ?

  • March 29, 2011 at 9:03 am

    #1304935

    Hi there, Thanks for ur reply. How do I enbale remote connections and start the SQL browser. I am sorry for my dumb questions but I am a newbie.

    Thanks again.

  • March 29, 2011 at 9:13 am

    #1304940

    open sql server configuration manager.

    select sql server services.

    ensure SQL server is running.

    if you have instances then you will need to start sql browser (most likely you don't though)

    then check the network configuration protocols, and enable tcp/ip connections.

  • March 29, 2011 at 9:15 am

    #1304942

    Thanks , SQL server configuration manager is in the control panel or is it somewhere else ?

  • March 29, 2011 at 9:19 am

    #1304949

    it will be under programs -- > under sql 2005 --> configuration tools

  • March 29, 2011 at 9:21 am

    #1304952

    Thanks, I will try this and will soon let you know how it goes.

  • March 29, 2011 at 9:28 pm

    #1305236

    I continue to get the same error. I have checked the services and can see an instance named VSS Writer started and running. I tried using this with the computer name as in XYZ-PC\VSS Writer to connect but I continue to get the same error. Please advise.

    Thanks

    IQ

  • March 30, 2011 at 9:53 am

    #1305526

    Since you are connecting on the same PC you do NOT need to enable remote connections.

    Please do not post the same question multiple times as it fragments answers. Here is the thread that I think everyone should post to, http://www.sqlservercentral.com/Forums/Topic1085565-149-1.aspx

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

Viewing 9 posts - 1 through 8 (of 8 total)

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