Installting sqlserver 2005 on the client machine for windows application

Hi
I developed a windows application in Visual studio 2005 and the database is sqlexpress.
I wanted my application to run on another system.For that i have installed sqlexpress 2005 on that machine.But that machine doesn't show me any enterprise manager or query manager for sqlserver.
Is there any solution for this.

Thanks

hi,

yes... you have to separately download and install SQL Server Management Studio Express... http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

regards

|||SQL Server Express does not come with EM or Query Analyzer. These two components have been merged into the SQL Server Managment Studio. The SQL Server Management Studio Express (which actually is a stripped of SQL Server Managment Studio (aka SSMS)) can be downloaded separately from Microsoft or is already included in the Express Advanced Edition (which actually includes some other cool features like Reporting Services for SQL Server Express).

http://msdn.microsoft.com/vstudio/express/sql/download/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Installing SQL Server Standard Edition 2005 after Installing SQL Server Express 2005

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

Yes, you can run these two editions on the same machine. By default, the instance name for an Express instance is SQLExpress. For the other editions, it is MSSQLSERVER, so you shouldn't have a instance name conflict, which is the only "gotcha" that people run into from time to time.

Thanks,
Sam Lester (MSFT)

|||One other gotcha is the management tools. SQL Express installs it's command line tools which will conflict with the management tools shipped with Standard Edition. See the following blog post regarding this topic: http://blogs.msdn.com/jpapiez/archive/2005/06/07/426418.aspx.|||

Hi,

Thanks for your answer.

It seems that I have installed finally SQL Server 2005 Standard Edition on my machine, but:

My previous Express Edition has gone, it seems my previous one has just been upgraded to Standard Edition.

Installing SQL Server Standard Edition 2005 after Installing SQL Server Express 2005

Hi

I have installed SQL Server Express 2005 on my machine.

I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.

Can these 2 Editions coexist with each other, or any troubles you think might encounter?

Thanks

Yes, you can run these two editions on the same machine. By default, the instance name for an Express instance is SQLExpress. For the other editions, it is MSSQLSERVER, so you shouldn't have a instance name conflict, which is the only "gotcha" that people run into from time to time.

Thanks,
Sam Lester (MSFT)

|||One other gotcha is the management tools. SQL Express installs it's command line tools which will conflict with the management tools shipped with Standard Edition. See the following blog post regarding this topic: http://blogs.msdn.com/jpapiez/archive/2005/06/07/426418.aspx.|||

Hi,

Thanks for your answer.

It seems that I have installed finally SQL Server 2005 Standard Edition on my machine, but:

My previous Express Edition has gone, it seems my previous one has just been upgraded to Standard Edition.sql

Integer field question

Hi
I need to create a table with an integer column that stores 2-byte
numbers in the range 0..65535, and forms part of the table's primary
key. Which data type should I pick?
I'm torn between:
(1) smallint - right size, but this is a signed type. So if a user
does a query for col > 60000, it won't work ..
(2) int - can hold number range correctly, but this is 4 bytes. I
could end up with 2 rows which are unique according to the primary
key, but having the same value for the first 2 bytes. Could fix with
an additional table constraint, but I wonder if there is a neater
way..
Can anyone recommend the best method to do this ?
thanks,
Neil
I don't think there's any simple way to do it. Int with a check constraint
to limit to numbers <= 65535 will solve it databasewise, but perhaps the
check constraint is not necessary if the middle-tier or GUI limits input to
2 bytes anyway?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
|||On 3 Mar, 09:39, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I don't think there's any simple way to do it. Int with a check constraint
> to limit to numbers <= 65535 will solve it databasewise, but perhaps the
> check constraint is not necessary if the middle-tier or GUI limits input to
> 2 bytes anyway?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
OK, thanks for the answer. Yes, the GUI will validate user input.
I will go for the "int" option.

Integer field question

Hi
I need to create a table with an integer column that stores 2-byte
numbers in the range 0..65535, and forms part of the table's primary
key. Which data type should I pick?
I'm torn between:
(1) smallint - right size, but this is a signed type. So if a user
does a query for col > 60000, it won't work ..
(2) int - can hold number range correctly, but this is 4 bytes. I
could end up with 2 rows which are unique according to the primary
key, but having the same value for the first 2 bytes. Could fix with
an additional table constraint, but I wonder if there is a neater
way..
Can anyone recommend the best method to do this ?
thanks,
NeilI don't think there's any simple way to do it. Int with a check constraint
to limit to numbers <= 65535 will solve it databasewise, but perhaps the
check constraint is not necessary if the middle-tier or GUI limits input to
2 bytes anyway?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||On 3 Mar, 09:39, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I don't think there's any simple way to do it. Int with a check constraint
> to limit to numbers <= 65535 will solve it databasewise, but perhaps the
> check constraint is not necessary if the middle-tier or GUI limits input t
o
> 2 bytes anyway?
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com
OK, thanks for the answer. Yes, the GUI will validate user input.
I will go for the "int" option.

Installing SQL Server 2000

Hi

I am trying to find out best practices for SQL Server 2000 installs
for corporate servers. We currently have someone doing it 'in their
spare time!' (I kid you not). When installing SQL server 2000 out of
the box on a freshly formatted machine, I would like to get some
feedback on the following:

1) I believe the 'sa' account should be removed at earliest
opportunity, after install.

2) Should there be any processes running under the 'sa' account is the
machine was correctly configured to use a domain account principle? I
was under the impression that this was not the case?

Any links to information on best practices would be appreciated.

Regards,
MitchHi

See inline:

"Mitch W" <mwheat@.hatch.com.au> wrote in message
news:b0f6e915.0406231817.1b6918b4@.posting.google.c om...
> Hi
> I am trying to find out best practices for SQL Server 2000 installs
> for corporate servers. We currently have someone doing it 'in their
> spare time!' (I kid you not). When installing SQL server 2000 out of
> the box on a freshly formatted machine, I would like to get some
> feedback on the following:
> 1) I believe the 'sa' account should be removed at earliest
> opportunity, after install.

This can not be removed! You can assign a strong password and use window
authentication rather than mixed mode.

> 2) Should there be any processes running under the 'sa' account is the
> machine was correctly configured to use a domain account principle? I
> was under the impression that this was not the case?

If using only windows authentication then you can not log in as sa.

> Any links to information on best practices would be appreciated.
http://www.microsoft.com/sql/spotlight/security.asp
http://www.sqlsecurity.com/DesktopD...index=0&tabid=1

> Regards,
> Mitch

John

installing SQL 2000 server client side components

Hi
I would like to install client side components of SQL 2000 server on a
server with Windows 2003 Web Edition. i have tried, but it will not. the
setup just exits. is this installation possible?
Note: ONLY client side components (the ultimate end is to install SQLXML 3.0
SP1; is this possible on server 2003 web edition?).
Thanks
JasonThe only edition that is supported on Web Edition is MSDE which does not
come with client tools. You will not be able to install the SQL Server
client tools on Web Edition. I don't think SQLXML 3 can be installed on web
edition at this time, which is a shame.
Mark Allison
SQL Server MVP
http://www.allisonmitchell.com
"Jason" <c_bananas@.mighty.co.za> wrote in message
news:O2zKFYV8DHA.2044@.TK2MSFTNGP10.phx.gbl...
> Hi
> I would like to install client side components of SQL 2000 server on a
> server with Windows 2003 Web Edition. i have tried, but it will not. the
> setup just exits. is this installation possible?
> Note: ONLY client side components (the ultimate end is to install SQLXML
3.0
> SP1; is this possible on server 2003 web edition?).
> Thanks
> Jason
>

Installing sql

Hi
I want know if is possible installing SQl 6.5 on windwos 2003 server
standard edition.
Can tell me link or material about this possibility?
Tia Pupo
I don't think it will work.
You get a worning dialog saying that SQL 2000 pre SP3 is not supported on
Windows 2003 and SQL 6.5 is a long way back.
Nik Marshall-Blank MCSD/MCDBA
"Pupo" <123star@.libero.it> wrote in message
news:uc2fKVGtFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi
> I want know if is possible installing SQl 6.5 on windwos 2003 server
> standard edition.
> Can tell me link or material about this possibility?
> Tia Pupo
>
|||http://www.microsoft.com/sql/howtobu...etsupport.mspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks it's just link that i looking for.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126181112.153934.174060@.g47g2000cwa.googlegr oups.com...
> http://www.microsoft.com/sql/howtobu...etsupport.mspx
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Installing SQL

Hi;
I am new to sql. I want to install MSSQL 2000 and have connectivity ( I am
learning DB design). I do not know how to setup the SQL Executive account. I
think it has something to do with network. I am using single PC ( no
network). I need server and client on my PC and don't know how to do it,.
Could somebody explain how to do it or point me to book or any material how
to do it so I can connect to DB, please.
Thanks in advance.jan (janpiasz@.sympatico.ca) writes:
> I am new to sql. I want to install MSSQL 2000 and have connectivity ( I
> am learning DB design). I do not know how to setup the SQL Executive
> account. I think it has something to do with network. I am using single
> PC ( no network). I need server and client on my PC and don't know how
> to do it,. Could somebody explain how to do it or point me to book or
> any material how to do it so I can connect to DB, please.

You mean the account under which SQL Server is to run?

The easiest way is to use the local system account, then you don't need
passwords or anything.

Else right-click on My Computer and choose Manage. Somewhere there,
you should be able to add users to your machine. Exactly how depends
on the OS you are running.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Yes, I read a book about MSSQL but I still can't do it. Local account does
not give me the possibility to connect to DB. for example I make ER diagram
in some kind of software, the software is suppose to generate SQL script
that is suppose to be ported to lets say Access. When I want to port the
script the ER program asks me for user name and password, I think it is the
password from SQL Executive and I am stuck. Is it possible to setup MSSQL
on a single PC to have server and client?

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948D5D54F709Yazorman@.127.0.0.1...
> jan (janpiasz@.sympatico.ca) writes:
>> I am new to sql. I want to install MSSQL 2000 and have connectivity ( I
>> am learning DB design). I do not know how to setup the SQL Executive
>> account. I think it has something to do with network. I am using single
>> PC ( no network). I need server and client on my PC and don't know how
>> to do it,. Could somebody explain how to do it or point me to book or
>> any material how to do it so I can connect to DB, please.
> You mean the account under which SQL Server is to run?
> The easiest way is to use the local system account, then you don't need
> passwords or anything.
> Else right-click on My Computer and choose Manage. Somewhere there,
> you should be able to add users to your machine. Exactly how depends
> on the OS you are running.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks; I think the key to solve my problems with setting up the account is
that I used Control panel to set it up. You say that I should use My
Computer/Manage, I think this is it. Thanks.
Jan

"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns948D5D54F709Yazorman@.127.0.0.1...
> jan (janpiasz@.sympatico.ca) writes:
>> I am new to sql. I want to install MSSQL 2000 and have connectivity ( I
>> am learning DB design). I do not know how to setup the SQL Executive
>> account. I think it has something to do with network. I am using single
>> PC ( no network). I need server and client on my PC and don't know how
>> to do it,. Could somebody explain how to do it or point me to book or
>> any material how to do it so I can connect to DB, please.
> You mean the account under which SQL Server is to run?
> The easiest way is to use the local system account, then you don't need
> passwords or anything.
> Else right-click on My Computer and choose Manage. Somewhere there,
> you should be able to add users to your machine. Exactly how depends
> on the OS you are running.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||jan (janpiasz@.sympatico.ca) writes:
> Thanks; I think the key to solve my problems with setting up the account
> is that I used Control panel to set it up. You say that I should use My
> Computer/Manage, I think this is it. Thanks.

Sorry, if I pointed you to the wrong place. That's a Windows issue and not
an SQL Server thing, so I blame it on that.

Any way, judging from your other post, I might have misunderstood your
question. The username/password you set up in the Control Panel is the
account with which SQL Server itself logs into Windows.

But if you use a data-modelling tool for ER diagrams, this tool ask you
for username/password to log into SQL Server, and that's a different
thing.

There are two ways to log in to SQL Server: Windows authentication and
SQL Server authentication. With Windows authentication, you don't provide
username and password, but SQL Server checks you credentials with Windows,
and if your Windows user have been granted access to SQL Server you are
let in. With SQL Server authentication, you provide username and password
and SQL Server looks them up in its internal register, and Windows is
not involved.

Windows authentication is preferrable in terms of security and simplicity.
Therefore, you need to configure SQL Server to accept SQL authentication.
But in the beginning, SQL authentication was all there was. So it might
be that your ER tool does not know about trusted connection, and prompts
you for a username/password. You can activate SQL authentication from
Enterprise Manager. Right-click the server, and choose Property and
head for the Security tab. From EM you can also create SQL Logins and
set their passwords. To have them to run the ER tool, you may have give
them privileges in the database; since this is a standalone machine, you
easiser may be to add them to the sysadmin role. Also, there is a built-in
user "sa" which has rights everywhere in the database. Check that this
user does not have a blank password, because that is very bad.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||jan (janpiasz@.sympatico.ca) writes:
> Thanks for your help, but it does not work because I am missing 'Model
> Manager'.
> It takes to much time and I must be doing something wrong. I know too
> little about MSSQL, but it will come (I hope in this lifetime ;-)).

"Model Manager"? Do you mean that you do not have Enterprise Manager?

Indeed, if all you have is MSDE, you don't have Enterprise Manager. In
such case this KB article covers this case:
http://support.microsoft.com/default.aspx?scid=325022.

But I have to confess that I am only guessing what your problem really
is.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||No it is called 'ModelMart' in ERWIN, I don't know where to find it. The
demo model doesn't have it.
Jan
"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns9490CE17536F4Yazorman@.127.0.0.1...
> jan (janpiasz@.sympatico.ca) writes:
>> Thanks for your help, but it does not work because I am missing 'Model
>> Manager'.
>> It takes to much time and I must be doing something wrong. I know too
>> little about MSSQL, but it will come (I hope in this lifetime ;-)).
> "Model Manager"? Do you mean that you do not have Enterprise Manager?
> Indeed, if all you have is MSDE, you don't have Enterprise Manager. In
> such case this KB article covers this case:
> http://support.microsoft.com/default.aspx?scid=325022.
> But I have to confess that I am only guessing what your problem really
> is.
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||You dont NEED model mart to use erwin. Just patience.

"jan" <janpiasz@.sympatico.ca> wrote in message news:<FvSYb.9274$d34.1112877@.news20.bellglobal.com>...
> No it is called 'ModelMart' in ERWIN, I don't know where to find it. The
> demo model doesn't have it.
> Jan
> "Erland Sommarskog" <sommar@.algonet.se> wrote in message
> news:Xns9490CE17536F4Yazorman@.127.0.0.1...
> > jan (janpiasz@.sympatico.ca) writes:
> >> Thanks for your help, but it does not work because I am missing 'Model
> >> Manager'.
> >> It takes to much time and I must be doing something wrong. I know too
> >> little about MSSQL, but it will come (I hope in this lifetime ;-)).
> > "Model Manager"? Do you mean that you do not have Enterprise Manager?
> > Indeed, if all you have is MSDE, you don't have Enterprise Manager. In
> > such case this KB article covers this case:
> > http://support.microsoft.com/default.aspx?scid=325022.
> > But I have to confess that I am only guessing what your problem really
> > is.
> > --
> > Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> > Books Online for SQL Server SP3 at
> > http://www.microsoft.com/sql/techin.../2000/books.asp|||I understand, but I want to port models to SQL 2000 or Access and don't now
haw to do it. If you know how to do it please let me know.
Thanks, Jan

"WangKhar" <Wangkhar@.yahoo.com> wrote in message
news:bb269444.0402190336.504db7df@.posting.google.c om...
> You dont NEED model mart to use erwin. Just patience.
> "jan" <janpiasz@.sympatico.ca> wrote in message
> news:<FvSYb.9274$d34.1112877@.news20.bellglobal.com>...
>> No it is called 'ModelMart' in ERWIN, I don't know where to find it. The
>> demo model doesn't have it.
>> Jan
>> "Erland Sommarskog" <sommar@.algonet.se> wrote in message
>> news:Xns9490CE17536F4Yazorman@.127.0.0.1...
>> > jan (janpiasz@.sympatico.ca) writes:
>> >> Thanks for your help, but it does not work because I am missing 'Model
>> >> Manager'.
>> >> It takes to much time and I must be doing something wrong. I know too
>> >> little about MSSQL, but it will come (I hope in this lifetime ;-)).
>>> > "Model Manager"? Do you mean that you do not have Enterprise Manager?
>>> > Indeed, if all you have is MSDE, you don't have Enterprise Manager. In
>> > such case this KB article covers this case:
>> > http://support.microsoft.com/default.aspx?scid=325022.
>>> > But I have to confess that I am only guessing what your problem really
>> > is.
>>> > --
>> > Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>>> > Books Online for SQL Server SP3 at
>> > http://www.microsoft.com/sql/techin.../2000/books.asp

Installing sql

Hi
I want know if is possible installing SQl 6.5 on windwos 2003 server
standard edition.
Can tell me link or material about this possibility?
Tia Pupo
I don't think it will work.
You get a worning dialog saying that SQL 2000 pre SP3 is not supported on
Windows 2003 and SQL 6.5 is a long way back.
Nik Marshall-Blank MCSD/MCDBA
"Pupo" <123star@.libero.it> wrote in message
news:uc2fKVGtFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi
> I want know if is possible installing SQl 6.5 on windwos 2003 server
> standard edition.
> Can tell me link or material about this possibility?
> Tia Pupo
>
|||http://www.microsoft.com/sql/howtobu...etsupport.mspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks it's just link that i looking for.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126181112.153934.174060@.g47g2000cwa.googlegr oups.com...
> http://www.microsoft.com/sql/howtobu...etsupport.mspx
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>

Installing sql

Hi
I want know if is possible installing SQl 6.5 on windwos 2003 server
standard edition.
Can tell me link or material about this possibility?
Tia PupoI don't think it will work.
You get a worning dialog saying that SQL 2000 pre SP3 is not supported on
Windows 2003 and SQL 6.5 is a long way back.
Nik Marshall-Blank MCSD/MCDBA
"Pupo" <123star@.libero.it> wrote in message
news:uc2fKVGtFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Hi
> I want know if is possible installing SQl 6.5 on windwos 2003 server
> standard edition.
> Can tell me link or material about this possibility?
> Tia Pupo
>|||http://www.microsoft.com/sql/howtob...netsupport.mspx
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Thanks it's just link that i looking for.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1126181112.153934.174060@.g47g2000cwa.googlegroups.com...
> http://www.microsoft.com/sql/howtob...netsupport.mspx
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>