How to configuring SQL 2K & connect to it.

I am new to SQL Server 2000 and need step-by-step help
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techin.../2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx
.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." Wh
at
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

How to configuring SQL 2K & connect to it.

I am new to SQL Server 2000 and need step-by-step help
setting it up and connecting to it. I am in desperate
need of help. If anyone can I'll greatly appreciate it.
Hi,
After the installtion of SQL server, You can use the user friendly utility
Enterprise manager to administer the
SQL Server and databases. The tasks are:-
1. Create a new database
2. Create new login
3. Assign the required role the login created.
Once you create the Login and database you can use the other utility named
"Query Analyzer" to connect to the
SQL Server. Using Query Analyzer you can execute all TSQL commands
For tracing you can use the utility "Profiler"
To enable and Disable the protocols you can use 'Server Netwotk utility".
For more information on Administration, TSQL commands download the latest
boks online from below link:-
http://www.microsoft.com/sql/techinf...2000/books.asp
Thanks
Hari
MCDBA
"Rafyel" <rafyelb@.tmail.com> wrote in message
news:2a38901c467a4$0b4909d0$a601280a@.phx.gbl...
> I am new to SQL Server 2000 and need step-by-step help
> setting it up and connecting to it. I am in desperate
> need of help. If anyone can I'll greatly appreciate it.
|||Thanks for your help. I've tried this and cannot connect still. I
continue to recieve a error message "[Microsoft][ODBC SQL Server
Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
am I doing wrong?
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
|||Hi,
This error can come in below situations:-
1. SQL Server is down
2. Your client network issues. Try a ping to server and check the network
connection
3. Providing wrong SQL server name.
If all the above is OK, then create a ALIAS server name using the CLient
network utility specifying protocol as TCIP , IP address , port number.
After that try to connect using that ALIAS name.
Thanks
Hari
MCDBA
"Rafyel Brooks" <rafyelb@.tmail.com> wrote in message
news:OIgy7n7ZEHA.3132@.TK2MSFTNGP10.phx.gbl...
> Thanks for your help. I've tried this and cannot connect still. I
> continue to recieve a error message "[Microsoft][ODBC SQL Server
> Driver][TCP/IP Sockets]SQL Server does not exist or access denied." What
> am I doing wrong?
>
> *** Sent via Devdex http://www.devdex.com ***
> Don't just participate in USENET...get rewarded for it!
|||Okay, I've started a new installation and started all over. I've
selected to use Windows NT authentication. Now I have to setup correctly
the database and create the login. whats the proper procedure?
Rafyel
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

How to cluster SQL 2005?

Hey everyone,
We are about to try to cluster SQL 2005 for HA on two windows 2003 ent.
servers. Anyone know of a step-by-step white paper? Do I need a "Quorum"
disk like our Exchange cluster?
Are the steps for clustering Windows the same as when we did our Exchange
2003 cluster? If so, then I only need the SQL part of the steps.
TIA,
Clayton
The steps for clustering Windows are the same, regardless of what app you
will be running. As for SQL Server 2005 cluster installs, check out:
http://msdn2.microsoft.com/en-us/library/ms179530.aspx
Also, check out www.clusterhelp.com for resources and training.
HTH
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Clayton Sutton" <none@.none.com> wrote in message
news:trl6h.9238$8d4.2542@.fe01.news.easynews.com...
Hey everyone,
We are about to try to cluster SQL 2005 for HA on two windows 2003 ent.
servers. Anyone know of a step-by-step white paper? Do I need a "Quorum"
disk like our Exchange cluster?
Are the steps for clustering Windows the same as when we did our Exchange
2003 cluster? If so, then I only need the SQL part of the steps.
TIA,
Clayton
|||Hello clayton
it is important to have quorum disk because it is a resource for clustering
in windows environment.
U could find step by step installation on http://msdn2.microsoft.com
Khwaja Arshaduddin
"Clayton Sutton" wrote:

> Hey everyone,
> We are about to try to cluster SQL 2005 for HA on two windows 2003 ent.
> servers. Anyone know of a step-by-step white paper? Do I need a "Quorum"
> disk like our Exchange cluster?
> Are the steps for clustering Windows the same as when we did our Exchange
> 2003 cluster? If so, then I only need the SQL part of the steps.
> TIA,
>
> Clayton
>
>
|||Thanks guys!
Clayton
P.S.: I just wrote an iTunes podcast tutorial and just want to publicize
it. You can find it at: http://www.nikoli.net/itunepod
*************************************
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eHmYWhACHHA.5064@.TK2MSFTNGP02.phx.gbl...
> The steps for clustering Windows are the same, regardless of what app you
> will be running. As for SQL Server 2005 cluster installs, check out:
> http://msdn2.microsoft.com/en-us/library/ms179530.aspx
> Also, check out www.clusterhelp.com for resources and training.
> HTH
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> .
> "Clayton Sutton" <none@.none.com> wrote in message
> news:trl6h.9238$8d4.2542@.fe01.news.easynews.com...
> Hey everyone,
> We are about to try to cluster SQL 2005 for HA on two windows 2003 ent.
> servers. Anyone know of a step-by-step white paper? Do I need a "Quorum"
> disk like our Exchange cluster?
> Are the steps for clustering Windows the same as when we did our Exchange
> 2003 cluster? If so, then I only need the SQL part of the steps.
> TIA,
>
> Clayton
>