Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 25th, 2005, 09:07 AM
Registered User
 
Join Date: Dec 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default server registration problem



Hi all !

I’ve just installed sql server 2000, and want to work on my pc, as a database server,

In the enterprise manager I, I choose the option :

- new sql server registration (under Microsoft sql srvers)



then in the register sql server wizard, I choose my machine’s name as a server,

in the end of the wizard session I’ve got the message :





(*) <machine’s name..> -SQL server does not exist or access denied. Connectionopen (Connect)



I used windows authentication as login.

I really don’t know what to do and why sql server 2000 don’t know how to recognize my computer as a server



If I’ll try to access the properties of the new server I’ll get the next message:

The server \\. Is not known to be running, Are you sure you wish to connect ?

(and while writing yes I’m getting (*) again…)



Regards,

pitter

 
Old December 28th, 2005, 04:21 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 1,348
Thanks: 0
Thanked 5 Times in 5 Posts
Default

Use "(local)" as your server name. Also this is a forum for sql2005

Jim

 
Old December 30th, 2005, 11:22 AM
Authorized User
 
Join Date: Mar 2005
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Pitter,

first check what sql server edition u have installed.
enterprise edition can be installed on windows 2000 server, data center, 2003 only.
now It depends what configuration u have chosen when installing sql server.

SQL type: default, named instance if named then what is the name of instance.
becoz if named instance is chosen then u have to give the sql server name as <computername>\<instance name> otherwise use ur computer name as instance name or (local).

what type of authentication u have chosen
Authentication 1. Windows Authentication 2. sql server authenication
if sql server authentication then at the time of sql server registration u will have chose the same.

if it doesn't solve your problem then check to see whether the sql server service(ms sql server) is running.

u can see it by start->control panel->administrative tools->services
if it is stopped then start it.



SQL Technical Consultant





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL server registration failed cuy .NET Framework 2.0 1 June 14th, 2006 01:07 AM
SQL Server Registration Problem Fitz SQL Server 2000 4 May 22nd, 2006 08:15 AM
server registration problem pitter SQL Server 2000 1 December 27th, 2005 04:53 AM
server registration error aspnet79434319 SQL Server ASP 0 June 26th, 2005 07:52 AM
SQL Server Registration using Dial up reyboy SQL Server 2000 2 July 15th, 2003 09:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.