Discussion:
SQL Server Access issue
(too old to reply)
iccsi
2012-02-25 16:02:59 UTC
Permalink
I installed SQL Server 2008 R2 Express on Windows 7 machine and try to
access from my XP machine.
It seems XP machine cannot see the SQL server on Windows 7 machine.
I am able to create an ODBC connection from other Windows 7 machine,
but XP machine can not see SQL server on Windows 7 machine.

Do I need do any special for XP to create an ODBC connection to Sql
Server Express on Windows 7 machine?

Your help and information is great appreciated,


iccsi
Erland Sommarskog
2012-02-26 16:48:59 UTC
Permalink
Post by iccsi
I installed SQL Server 2008 R2 Express on Windows 7 machine and try to
access from my XP machine.
It seems XP machine cannot see the SQL server on Windows 7 machine.
I am able to create an ODBC connection from other Windows 7 machine,
but XP machine can not see SQL server on Windows 7 machine.
Do I need do any special for XP to create an ODBC connection to Sql
Server Express on Windows 7 machine?
What error message do you get? What happens if you use SQLCMD to connect
from the XP machine?

Are all the machines in the same domain? Do you have a domain at all? If you
have a workgroup, do you have the same username and password on all
machines?

Are you using Windows authentication or SQL authentication?

Have you checked firewalls?
--
Erland Sommarskog, SQL Server MVP, ***@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
iccsi
2012-02-26 19:38:12 UTC
Permalink
Post by Erland Sommarskog
Post by iccsi
I installed SQL Server 2008 R2 Express on Windows 7 machine and try to
access from my XP machine.
It seems XP machine cannot see the SQL server on Windows 7 machine.
I am able to create an ODBC connection from other Windows 7 machine,
but  XP machine can not see SQL server on Windows 7 machine.
Do I need do any special for XP to create an ODBC  connection to Sql
Server Express on Windows 7 machine?
What error message do you get? What happens if you use SQLCMD to connect
from the XP machine?
Are all the machines in the same domain? Do you have a domain at all? If you
have a workgroup, do you have the same username and password on all
machines?
Are you using Windows authentication or SQL authentication?
Have you checked firewalls?
--
SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Thanks for helping,
It was my mistake,
I need type server name and instance name, but I did not have server
instance name.

Thanks again for helping,


iccsi

Loading...