Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to test my new sql server? Expand / Collapse
Author
Message
Posted Saturday, March 5, 2011 2:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 10:00 PM
Points: 3, Visits: 6
I just installed ms sql 2003 server and I have an XP client on the same network. How do I test the coonection of my client XP to the server? I can ping it and access the Windows server but I need to know if the SQL server can be access by my XP to test connectivity. Is there any Windows XP utility I can use like the ODBC and how?

I am a newbie and I will appreciate a lot any help. tia
Post #1073676
Posted Tuesday, March 8, 2011 7:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, March 8, 2011 10:27 AM
Points: 7, Visits: 18
XP needs to be the "Pro" version or higher to work as a client.
Post #1074821
Posted Tuesday, March 8, 2011 8:03 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 7:44 AM
Points: 12,910, Visits: 32,015
rgerald 53299 (3/8/2011)
XP needs to be the "Pro" version or higher to work as a client.


I'm not sure what you mean by that; as long as the driver, whether SQL SQLNCLI or the SQL SQLOLEDB, any windows operating system, regardless of versions, would be able to connect;
maybe you mean as an RDP client(Remote Desktop?)

the OP posted in the Compact Edition forum, which i think was just an oversight...but if it is Compact Edition specific,, maybe there's a restriction on the sdb database file I'm not aware of?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1074830
Posted Wednesday, March 9, 2011 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 10:00 PM
Points: 3, Visits: 6
I have XP sp 3. What should I do next?
Post #1075377
Posted Wednesday, March 9, 2011 9:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 22, 2014 11:33 AM
Points: 136, Visits: 444
I would probably start by installing an MS SQL Client such as the express version of SSMS and see if the client application can communicate with the SQL Server

Director of Transmogrification Services
Post #1075663
Posted Wednesday, March 9, 2011 10:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 10:00 PM
Points: 3, Visits: 6
Mad Myche (3/9/2011)
I would probably start by installing an MS SQL Client such as the express version of SSMS and see if the client application can communicate with the SQL Server


thank you sir... i will try this.
Post #1075991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse