Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raghulvarma
Starting Member
21 Posts |
 Posted - 2008-10-08 : 12:16:01
|
| Hai Friends I have installed Vista home edition in my Computer, Now I want to work with sql server 2000. The problem is that even after the sql server 2000 gets installed I am not able to do any operations such as creating a table,insert , delete or any other things. The problem that it shows is Server: Msg 262, Level 14, State 1, Line 1CREATE TABLE permission denied in database 'master'.any help?Thanks in advanceRaghul |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-10-08 : 13:24:22
|
| I am bit surprised 'cos i didnt think 2000 will run on vista, except from an upgrade of XP.Anyway, vista comes with permissions, and i will advice you right click EM and choose run as administrator. Hopefully should solve the problem. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-08 : 14:33:08
|
| Yes,Vista supports SQL 2000. Did you delete admin permission that comes while installing SQL 2000? What about sa account? Can you login with that? |
|
|
|
raghulvarma
Starting Member
21 Posts |
Posted - 2008-10-08 : 22:03:09
|
quote:
Originally posted by afrika
I am bit surprised 'cos i didnt think 2000 will run on vista, except from an upgrade of XP.Anyway, vista comes with permissions, and i will advice you right click EM and choose run as administrator. Hopefully should solve the problem.
Even when I choose EM to run as administrator it displays the same message as access denied.In Service Manager the option in the Server :HOME-PC\SQLEXPRESSServices:SQL Server is displayed in this the start/continue button is invisible(not enabled)and I have also othre services like MSDTC in which when I click start button it show the message "Access denied"and in the other SQL server Agent when I click the start button it displays "The specified Service is does not exixt as an installed service.For all the three services the server remains the same.But when I go through the Enterprise Manager when I click the HOME-PC\SQLEXPRESS it shows that the connection has been failed(check SQL Server Registration properties).And also I could see other server in EM called (local)(Windows NT)when I dbl click I could see Items inside that (Databases,Management,Replication...).But I could not see this server inside the service manager.Any help?Thanks in advanceRaghul |
|
|
|
|
|
|
|
|
Install Sql Server 2000 in vista