Post reply

SQL Server 2005 Remote connect problem

  • January 8, 2009 at 7:47 pm

    #204846

    Hi all,

    I want to know how can i connect to remote server DB? i have read through some blogs and sites, they all mention to enable remote access right for the sql server in "SQL Server Surface Area Configuration". But don't know why i still can't connect.

    here is what i done in Server PC.

    1) Open surface area and enable both tcpip and bla bla..

    2) Start the DB engine service.

    3) it pop up an error (Error in start service.bmp) and can't start.

    4) I go to main page of surface area and click on 'Add New Administrator'.

    5) Enable all access from left to right pane and click OK, it again pop up an error (Error in setting Administrator.bmp)

    6) I go to user account and enable all access to my current account. (administrator, debugger, Remote desktop users, SQL ....., etc). I added my account All groups.

    7) Then try to start the service again, it still failed with same error message.

    8) I have SQL 2000 and 2005 in same machine(Server PC). SQLExpress is running OK. and MSSQLSERVER can't run.

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

    Now in my client PC, i can connect to other Server PC DB. but not the above one.

    What i done in Client PC,

    1) I open SQL Management studio express and browse server name of above lets says "SCSFPC", I found it.

    But only "SCSFPC", no "\SQLExpress" for DB.

    2) I tried to connect other server PC, they have like this "SerPC1\SQLEXPRESS", "SerPC2\SQLEXPRESS". But for "SCSFPC", i can't find the "\SQLEXPRESS" name. Don't know why. It is running OK in Server PC but why i can't find it?

    any idea guys?

    Here is all my screen shots for my errors.

    http://scsfdev.fileave.com/SQL_Server_Error/[/url]

    Hope you guys can give me some hints.

    Thanks. (And sorry for bulky of text)

  • January 12, 2009 at 7:39 am

    #925266

    Let me see if I understand your questions. You want to connect to a SQL instance from another machine. One instance ("MSSQLSERVER") will not start, and another ("SCSF\SQLExpress") cannot be seen from other machines. You also mention a SQL2000 instance on this machine.

    SQL 2000 instance.

    I don't believe SQL2000 instances appear in the SQL 2005 Surface Area Configuration (SAC) window. (Mine doesn't.) It sounds like you have at least 3 instances on your machine: 1 SQL2000 and 2 SQL2005. You could see them all in your "admin tools\Services" window. The SQL2000 instance will be in the M's ["MSSQL$instanceName"], and the SQL2005 instances will be in the S's ["SQL Server (instanceName)"].

    "MSSQLSERVER" instance.

    In your Surface Area Config window, "MSSQLSERVER" stands for a default instance of SQL server 2005. It is not an Express edition, because it has SQL Agent. According to your screenshots, that instance won't start. Are you trying to connect to this instance from another machine? Is your "server" a Vista machine?

    "SCSF\SQLExpress" instance.

    Do you have any problems starting this instance?

    In order to see a SQL named instance (like "MyServer\SQLExpress") from a different machine, "SQL Server Browser" must be running. The browser is the bottom entry in your SAC screenshot. Is it running? (You can also start/stop it from the windows Services window.) It has to be running to identify the port of named instances so that remote machines can connect.

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

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