How to test my new sql server?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Compact Edition » How to test my new sql server?

How to test my new sql server?

Rate Topic

Display Mode

Topic Options

Author

Message

rhungkoi

Posted Saturday, March 05, 2011 2:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 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

rgerald 53299

Posted Tuesday, March 08, 2011 7:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, March 08, 2011 10:27 AM
Points: 7, Visits: 18

XP needs to be the "Pro" version or higher to work as a client.

Post #1074821

Lowell

Posted Tuesday, March 08, 2011 8:03 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:29 PM
Points: 11,645, Visits: 27,738

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

rhungkoi

Posted Wednesday, March 09, 2011 1:48 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 2011 10:00 PM
Points: 3, Visits: 6

I have XP sp 3. What should I do next?

Post #1075377

Mad Myche

Posted Wednesday, March 09, 2011 9:37 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:49 AM
Points: 133, Visits: 413

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

rhungkoi

Posted Wednesday, March 09, 2011 10:01 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 09, 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 »

Permissions