 |
| 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
|
|
|
|
December 3rd, 2007, 02:55 AM
|
|
Registered User
|
|
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
|
|
Unable to create database.
Hi
When I tried to create a database for first time it gives error that "You do not have previledge to create database on 'master'", since I have a blank SQL Server 2005 (no objects other than system objects) i don't have any other groud to work. Please advice
Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.
|
|
December 3rd, 2007, 08:15 AM
|
|
Friend of Wrox
|
|
Join Date: Nov 2003
Location: Lehigh Acres, FL, USA.
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
You must check your user role and permission, this indicates that you don not have the necessary database credentials and and are not granted those privileges.
Jaime E. Maccou
|
|
December 4th, 2007, 05:04 AM
|
|
Registered User
|
|
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
|
|
But how...? since this is my first database, do we need any other seetings tobe done before creating user database?
Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.
|
|
December 4th, 2007, 01:08 PM
|
|
Friend of Wrox
|
|
Join Date: Aug 2006
Location: Bangalore, Karnataka, India.
Posts: 231
Thanks: 0
Thanked 1 Time in 1 Post
|
|
can you tell me what option you choose while installing SQL Server. now you are using Authentication or you are using sa aith password.
thanks......
|
|
December 6th, 2007, 02:39 AM
|
|
Registered User
|
|
Join Date: Apr 2005
Location: Mumbai, Maharastra, India.
Posts: 352
Thanks: 14
Thanked 0 Times in 0 Posts
|
|
I am using windows authentication, and I log at Administrator.
I have operating sys as Windows Vista Home Premium,
in this os by default Administratinve login will not grant me Admin rights in SQL Server 2005, so I have to create an administrator from configuration management studio, but ouver here, when I click on Add Administrator link, I couldn't see any window actualy nothing is happening there, its confusing.
Rupen Anjaria.:)
------------------
It is not difficult to be on TOP...It is difficult when you carry Truth,Commitment and Transparency with you.
|
|
Similar Threads
