| Author |
Topic |
|
rpc86
Posting Yak Master
200 Posts |
 Posted - 2008-06-03 : 20:38:38
|
Hi guys,I installed an SQL Server 2000 Standard Edition on my PC running on Windows XP (ver 2002).I have a Visual Studio 2005 for my VB.NET project, and this is my first time to develop in .NET using SQL Server 2000. After installing the Visual Studio 2005, there is also installed an SQL Server 2005 Configuration Tools.When I used the SQL Server 2000 to register the server name, there was an error message saying...[SQL-DMO]You must use SQL Server 2005 management tools to connect to this server. Is there a conflict between Visual Studio 2005 and SQL Server 2000?I have already used SQL Server 2000 (five years ago), but never encountered such problem during registration and creation of databases.Please advice.Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 20:52:33
|
| As error says it is not supported in SQL 2000. |
 |
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2008-06-03 : 21:27:59
|
| is there an SP for SQL 2000 to solve this problem? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 21:29:01
|
| How can you install sql2k standard edition on Win XP? The message indicates that you have sql2k5 installed on the machine. |
|
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2008-06-03 : 21:41:01
|
| the sql2k5 was only installed when i installed the visual studio 2005. It is not a complete sql2k5. It's just something like utilities.my main problem is that I could not register server on my sql2000.do you mean sql2000 will not work on winxp? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 23:13:56
|
| Sql2k standard edition doesn't work on win xp. Double check sql services on the machine and post service name here. VS2k5 doesn't have sql client tools by the way. |
|
|
|
rpc86
Posting Yak Master
200 Posts |
Posted - 2008-06-04 : 00:52:54
|
Ok,I changed my installation. I removed sql2k standard edition and installed sql2k Personal Edition. I also removed the sql2k5, because it has too many requirements just like the above inquiries from me.Now this is my problem now.I can create a database in SQL Server 2000 Personal Edition only if I'm logged as admin in the windows log. But if I log as a user, I cannot do the same thing and it has an error message regarding the server registration.Login failed to server 'myServer' Please help.Thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-04 : 01:38:01
|
quote:
Originally posted by rpc86
Ok,I changed my installation. I removed sql2k standard edition and installed sql2k Personal Edition. I also removed the sql2k5, because it has too many requirements just like the above inquiries from me.Now this is my problem now.I can create a database in SQL Server 2000 Personal Edition only if I'm logged as admin in the windows log. But if I log as a user, I cannot do the same thing and it has an error message regarding the server registration.Login failed to server 'myServer' Please help.Thank you.
Does your user account have a valid SQL login? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-04 : 22:56:45
|
| Because local admin has sql sysadmin rights by default. |
|
|
|
|
Server Registration Problem