New to SQL

Hello,

I just installed SQL 2005 on my laptop,,,, I know this is not an email question but maybe you can guide me to where i can find the answers.....

I want to test it out and configure it with cognos and informatica.....

Is it possible for me to create sample servers and configure it for a test

I did instal web Server (Abyss), not sure if this helps......

How do i set up a test server on my computer

And is all possible to do it on one computer?

thank-you in advance

You already have a default instance ( 1 server) installed on your computer. If you want to have more use Microsoft Virtual PC to install another instance as you have another pc. Or install a second instance , a named instance that mean you have another server on your laptop.

Sure for working with Virtual PC or install another instance you have to have disk size, RAM (for a Virtual PC application with SS2k5 you have to have 512 MB Ram )

So, 512 RAM for SQL on the laptop with 512 Mb RAM for SQL on Virtual PC you have to have minimum 1 GB RAM.

As a web server you can use IIS (Internet Information Services) on Microsoft host

|||

Thank-you!

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

thank-you

|||In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

Download SQL express
|||

Vidhya Sagar wrote:

In windows XP you can install only SQL express edition or SQL Server 2005 trail version (180 days valid).

No, it is not correct

I have Windows XP Professional and the command select @.@.version has output:

-

Microsoft SQL Server 2005 - 9.00.3027.00 (Intel X86)

Oct 27 2006 15:59:00

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition on Windows NT 5.1 (Build 2600: Service Pack 2)

(1 row(s) affected)

|||

russski wrote:

How can i create a server on my windows xp computer so i can connect to it from SQL 2005?

If ou install a SQL server on a machine you install both client and server ; in some time ou have the option to install only client tools. So , if you have a SQL on the host and a virtual PC machine running on that machine with SQL installed you can experiment connecting one to another.|||Hi,

Thx for the information. As you said all editions of SQL2k5 can be installed on XP Professional edition expect Enterprise edition.
In XP Home edition you can go only for express or developer or trial edition.