Wednesday, March 21, 2012

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!

No comments:

Post a Comment