Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 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 May 9th, 2006, 02:39 AM
Authorized User
 
Join Date: Nov 2004
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Default Registration Process for Sql Server 2000

Hi All,

         I have installed Sql Server 2000 at two machines containing, Microsoft XP Professional. I will call both machines X and Y for reference.

Now when i want to make registration at Machine X for Sql server installed at machine Y. whenever i do this it gives me error that "Msg 17 Level 6 Server Does Not exists or Access Denied".

I tried again and again but all in vain... interesting factor is that when i make this registration at Machine Y for Sql Server installed at Machine X.... it was successful...

Any help will be highly appreciated..
__________________
Tiyyob
 
Old May 9th, 2006, 03:25 AM
Friend of Wrox
 
Join Date: May 2006
Posts: 246
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Are you using intergrated security (trust) or SQL security?

It seems that machine Y does not accept the user credentials you supply from machine X.

1. If using SQL security, make sure username and password is correct
2. It using trust, add the user for Machine X to Machine Y in appropriate group.

 
Old May 9th, 2006, 03:18 PM
SQLScott's Avatar
Wrox Author
 
Join Date: Dec 2004
Posts: 338
Thanks: 0
Thanked 2 Times in 2 Posts
Default

Since it is Windows XP, do you have service pack 2 with Firewall security turned on on machine Y? This might also cause a problem...

 
Old May 9th, 2006, 06:05 PM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 385
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you install sql server set them both up with domain security and sql security. Insure you can ping the other server and your port (normally 1433) is open between them. Also insure you using the exact same version of mdac on both computers.

Just my two cents.






Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server 2000 and SQL Server 2000 CE dparsons SQL Server 2000 1 July 31st, 2006 12:59 PM
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
SQL SERVER 2000 AND ACCESS 2000 ckentebe SQL Server 2000 3 June 17th, 2004 08:50 PM
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.