locked
Cant Access SQL Server (on Vista) from other Network PC (XP) RRS feed

  • Question

  • I have just installed Vista on one of my home network pcs. I also installed Outlook 2005 with Business Contact Manager. It installs an instance of SQL Server Express.

    I have created another database on this engine that I need to access from other PCs on my network.

    The server address is PCNAME\MSSMLBIZ and I can access the data the database using this name from the the Vista PC (PCNAME).

    When I try to acess the database using the same credentials (server, database, username (sa) and password) from an XP PC on the network - it times out and returns an error . My guess is that it is not seeing the database service at all.

    I have SQL Server Management Studio installed on the Vista PC and have full access to the instance.

    Server authentication is set for SQL Server and Windows Authentication mode.

    Can anyone help me?. I need to access the SQL Server from the XP PC.

    Ian

    Thursday, March 22, 2007 2:39 AM

Answers

All replies

  • Make sure that SQL Server Browser is running, you firewall is configured properly to allow the SQL Server traffic and that Remote connections are enabled for SQL Server. (See the screencats on my site for more information).

    Firewall configuration: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b914277


    Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    Thursday, March 22, 2007 7:34 AM
  • Yes - that worked - as soon as I set remote access on  Surface Area Configuration for Services and Connections page.

    Regards Ian

    Friday, March 23, 2007 12:47 AM
  • I have just installed SQL Server 2005 Developer Edition on Windows Vista Ultimate, but i cant access and see "sql server managment studio"  The only things i have are these >>>
     
    Saturday, April 14, 2007 3:56 AM