Monday, February 20, 2012

registering a sql server

i'm the first time to use sql server 2000 to develop my
final year project....since i never create any database
using sql server 2000 before...my "sql server group" is
empty......when i register a server....a message
prompted out as folling "SqlConnection()is failed or
access denied"......what i have to do in order to
register a server successfullyHi,
Are you trying to register from the machine you have installed SQL Server,
If yes then add the server name as
"LOCAL". Use the SQL Server Authentication, then give
login name as "SA" and the password ( SHould be blank) and continue
registration.
If "Local" is not allowing then try identifying the SQL Server name by
opening the SQL error log in \log folder of sql server installation. Use
that server name to register.
Thanks
Hari
MCDBA
"chan" <chanling10@.time.net.my> wrote in message
news:11ab601c44210$e8320a40$a301280a@.phx
.gbl...
> i'm the first time to use sql server 2000 to develop my
> final year project....since i never create any database
> using sql server 2000 before...my "sql server group" is
> empty......when i register a server....a message
> prompted out as folling "SqlConnection()is failed or
> access denied"......what i have to do in order to
> register a server successfully

No comments:

Post a Comment