Installing SQL

[jan]

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.

[Erland Sommarskog]

Re: Installing SQL

jan (janpiasz@sympa tico.ca) writes:[color=blue]
> 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.[/color]

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/techinfo/productdoc/2000/books.asp

[jan]

Re: Installing SQL

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:Xns948D5D5 4F709Yazorman@1 27.0.0.1...[color=blue]
> jan (janpiasz@sympa tico.ca) writes:[color=green]
>> 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.[/color]
>
> 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/techinf...2000/books.asp[/color]

[jan]

Re: Installing SQL

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:Xns948D5D5 4F709Yazorman@1 27.0.0.1...[color=blue]
> jan (janpiasz@sympa tico.ca) writes:[color=green]
>> 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.[/color]
>
> 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/techinf...2000/books.asp[/color]

[Erland Sommarskog]

Re: Installing SQL

jan (janpiasz@sympa tico.ca) writes:[color=blue]
> 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.[/color]

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/techinfo/productdoc/2000/books.asp

[Erland Sommarskog]

Re: Installing SQL

jan (janpiasz@sympa tico.ca) writes:[color=blue]
> 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 ;-)).[/color]

"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/techinfo/productdoc/2000/books.asp

[jan]

Re: Installing SQL

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:Xns9490CE1 7536F4Yazorman@ 127.0.0.1...[color=blue]
> jan (janpiasz@sympa tico.ca) writes:[color=green]
>> 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 ;-)).[/color]
>
> "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/techinf...2000/books.asp[/color]

[WangKhar]

Re: Installing SQL

You dont NEED model mart to use erwin. Just patience.

"jan" <janpiasz@sympa tico.ca> wrote in message news:<FvSYb.927 4$d34.1112877@n ews20.bellgloba l.com>...[color=blue]
> 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:Xns9490CE1 7536F4Yazorman@ 127.0.0.1...[color=green]
> > jan (janpiasz@sympa tico.ca) writes:[color=darkred]
> >> 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 ;-)).[/color]
> >
> > "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/techinf...2000/books.asp[/color][/color]

[jan]

Re: Installing SQL

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.0 402190336.504db 7df@posting.goo gle.com...[color=blue]
> You dont NEED model mart to use erwin. Just patience.
>
> "jan" <janpiasz@sympa tico.ca> wrote in message
> news:<FvSYb.927 4$d34.1112877@n ews20.bellgloba l.com>...[color=green]
>> 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:Xns9490CE1 7536F4Yazorman@ 127.0.0.1...[color=darkred]
>> > jan (janpiasz@sympa tico.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/techinf...2000/books.asp[/color][/color][/color]