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 configure data source that gets ID from the URL?

When configuring the SqlDataSource, what source do I need to specifyfor getting the ID passing through the URL? I tried Form but it's notgetting the ID through the URL. Help is appreciated.QueryString|||Thanks! That works!

how to configure a server as distributor

When configuring my SQL Server as a distributor I get the following
error:
Error 14113:Could not execute 'copy "
C:\Program Files\Microsoft SQL Server\MSSQL\DATA\DISTMDL.MDF"
"C:\Program Files\Microsoft SQL Server\MSSQL\DATA\distribution.MDF"'.
Check
'instdist.out' in the install directory
I could not find a file named instdist.out in the install directory.
Please Help!!
Thanks.
The setup will require you to be a system administrator - are you logged on
as one?
Also has the distribution database been created?
Also, check that you have sufficient room for a copy of the distribution
database.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I've logged in as system administrator.
distmodel database is also there and have sufficient space on my disk.
but still the problem has not been solved.
please show me a way.
thanx
jeff
Paul Ibison wrote:
> The setup will require you to be a system administrator - are you logged on
> as one?
> Also has the distribution database been created?
> Also, check that you have sufficient room for a copy of the distribution
> database.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||I'd set it up manually and see where the issue is:
sp_adddistributor
sp_adddistributiondb
sp_adddistpublisher
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||First disable distribution from the Replication menu
Then try below commands in query analyser
sp_helpserver ( to see server name)
sp_dropserver 'SERVERNAME','DROPLOGINS'
sp_addserver 'SERVERNAME','LOCAL'
Then try creating Distribution again
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:u7Y6pBCBHHA.3540@.TK2MSFTNGP03.phx.gbl...
> I'd set it up manually and see where the issue is:
> sp_adddistributor
> sp_adddistributiondb
> sp_adddistpublisher
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
|||Take the database distmodel to Offline
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com