New to SQL 2005 Express

I haven't used this software except locally on my laptop. If you have built a databased web app using this, how do you deploy the db? Does it have to be installed and/or supported on your webhosting service? If so, it seems to be of limited use, if not, very helpful.

Thanks for the help

To deploy the application, the destination will need to have SQL Server Express installed as well. You can read a detailed article about that here:

http://msdn2.microsoft.com/en-us/library/ms165639.aspx

Buck Woody

|||

That's what I was afraid of....doesn't look as this will be the answer. Back to mysql or MS SQl 2000.

Thanks for the reply!!

TLCoop

|||No problem - but MySQL or MS SQL 2000 will have the same issue, won't it?|||

There might be some confusion here. SQL Express is SQL Server 2005. Your hoster will need to support SQL Server 2005, but they don't have to have SQL Express installed. It's the exact same database file because they are the exact same products, just with different feature sets.

If you're hosting company requires that you upload your database using scripts, we are working on a tool to help do that. You can find a CTP of the tool on CodePlex.

Mike

|||

Thanks Mike,

My host doesn't offer mssql 2005 yet. They do have mssql 2000, and maybe(hopefully)some of sqlexpress2005 is backwards compatible. I can always generate scripts and run a query for db population on mssql 2000. I'll take a look at CodePlex.

I appreciate the help!

Terry

|||

Thanks Buck for the reply. My Host doesn't offer MSSQL 2005 nor SQLExpress 2005 support yet. They offer both MySQl and MS SQL 2000 right now, so I'll try and 'script' a db from express 2005. I appreciate the help.

Terry

new to SQL 2005

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

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

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

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

new to SQL 2005

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

Is this what you're looking for?

https://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

Best regards

- Jens

|||

Thank-you! but i already installed them,

Im looking for is how to configure it so it will work with them?

thank-you !

|||

Hi,

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

thank-you

|||

Have a look at this url:

http://msdn2.microsoft.com/en-us/library/ms143708.aspx

Best regards

- Jens

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.

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.

New IBM Laptop running SQL server cannot connect to another sql server on network

I am trying to connect a new LBM Laptop to an SQL server on the
network
and I get "test connection failed because of an error in initializing
provider, [dbnetlib][connectionopren(connect()),] SQL server does not
exist or access denied. The laptom has sql server running on it
locally and I am trying to connect to an SQL server on the network.
Thanks
TomHi

You should make sure that SQL Server is at Service Pack 3a on both machines
and check the MDAC installation on the laptop with the MDAC component
checker (see microsoft download centre)?

If you can connect to the network SQL Server from other machines, then check
the network settings on the laptop.

John

"TomCullen" <cullentw2000@.yahoo.com> wrote in message
news:6ba80eaf.0410220926.6c2f4355@.posting.google.c om...
> I am trying to connect a new LBM Laptop to an SQL server on the
> network
> and I get "test connection failed because of an error in initializing
> provider, [dbnetlib][connectionopren(connect()),] SQL server does not
> exist or access denied. The laptom has sql server running on it
> locally and I am trying to connect to an SQL server on the network.
> Thanks
> Tom