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

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

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

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||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 >>>

Cant Access SQL Server (on Vista)

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

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

|||

Yes - that worked - as soon as I set remote access on Surface Area Configuration for Services and Connections page.

Regards Ian

|||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 >>>

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.
Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

cannot start SQL server

I was using SQL server service manager with no problem.
I've installed "Business Contact Manager" and now service manager cannot
connect to the server.
Thanks for any advise.Is the problem that you cannot connect to sql server or that the service
itself cannot start. You can try starting the service through the services
MMC instead of through service manager, by going to:
start->run->services.msc, look for the MSSQLServer (or MSSQL$INSTANCENAME)
service and do a right click->start.
What error are you seeing?
You can check this KB for some suggestions on how to troubleshoot SQL
connectivity:
How to troubleshoot connectivity issues in SQL Server 2000 - ID: 827422
http://support.microsoft.com/?id=827422
Also, check the latest SQL Error logs (c:\program files\microsoft sql
server\mssql\LOG\errorlog - the file with no extension is the latest sql
errorlog) and the application system event logs (in event viewer) for any
errors which occur during the time you attempted to start the SQL Service.
HTH,
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx