! I can not create a new database with SQL SERVER MANAGEMENT STUDY
EXPRESS and Windows VISTA. ERROR: Permission denied CREATE DATABASE
(Micorosoft SQL Server Error: 262)
But how do I give me the permission?
Someone me knows?
Thank you very much everybody!
Aldo

If you connect to your SQL Server instance using Windows Authentication mode
and Windows account that is a member of the "Local Administrators" Windows
Group, then you should be able to be performing this action.

Are you using a customized Login when connecting to your SQL Server insance?
If so, what permissions did you assign to this Login?

--
Ekrem Önsoy


"Odla" <boffialdo@libero.it> wrote in message
newseTSj.300830$%k.405531@twister2.libero.it...
> ! I can not create a new database with SQL SERVER MANAGEMENT STUDY
> EXPRESS and Windows VISTA. ERROR: Permission denied CREATE DATABASE
> (Micorosoft SQL Server Error: 262)
> But how do I give me the permission?
> Someone me knows?
> Thank you very much everybody!
> Aldo
>

Yes, I use Windows Authentication mode and Windows account.
How I can check if it is member of "Local Administrator"?
May be this is the problem!
Thank you very much for your !
Aldo



"Ekrem Önsoy" <ekrem@compecta.com> ha scritto nel messaggio
news:72F479FC-731C-4EB7-871A-6C93400D5C2B@microsoft.com...
> If you connect to your SQL Server instance using Windows Authentication
> mode and Windows account that is a member of the "Local Administrators"
> Windows Group, then you should be able to be performing this action.
>
> Are you using a customized Login when connecting to your SQL Server
> insance? If so, what permissions did you assign to this Login?
>
> --
> Ekrem Önsoy
>
>
> "Odla" <boffialdo@libero.it> wrote in message
> newseTSj.300830$%k.405531@twister2.libero.it...
>> ! I can not create a new database with SQL SERVER MANAGEMENT STUDY
>> EXPRESS and Windows VISTA. ERROR: Permission denied CREATE DATABASE
>> (Micorosoft SQL Server Error: 262)
>> But how do I give me the permission?
>> Someone me knows?
>> Thank you very much everybody!
>> Aldo
>>
>

If you log in to your Windows as a normal user, then your Windows Account
would not be a member of the Local Administrators Windows Group. And when
connecting to your SQL Server instance, you'd only have rights as much as a
normal user.

If you managed to install SQL Server using the same Windows Account, then it
must be an Administrator account. You may have UAC (User Access Control
which is a new feature of Vista and it assumes you are a normal user even if
you'd be an administrator unless you demand for this right particularly)
active as you run under Windows Vista. So, when openning SSMS, you can try
right clicking on the SSMS icon and click "Run as Administrator". This may
be the fact that prevents you logging in as an Administrator.

To see Windows account in your system, you can right click on your
"Computer" icon on your desktop (or whereever it is) and click "Manage" on
the popup menu. Then go to "Local Users and Groups" and expand it, then go
to Users node. Alternatively, you can use Control Panel's "User Accounts"
component.

--
Ekrem Önsoy



"Odla" <boffialdo@libero.it> wrote in message
news:8IVSj.300882$%k.405579@twister2.libero.it...
> Yes, I use Windows Authentication mode and Windows account.
> How I can check if it is member of "Local Administrator"?
> May be this is the problem!
> Thank you very much for your !
> Aldo
>
>
>
> "Ekrem Önsoy" <ekrem@compecta.com> ha scritto nel messaggio
> news:72F479FC-731C-4EB7-871A-6C93400D5C2B@microsoft.com...
>> If you connect to your SQL Server instance using Windows Authentication
>> mode and Windows account that is a member of the "Local Administrators"
>> Windows Group, then you should be able to be performing this action.
>>
>> Are you using a customized Login when connecting to your SQL Server
>> insance? If so, what permissions did you assign to this Login?
>>
>> --
>> Ekrem Önsoy
>>
>>
>> "Odla" <boffialdo@libero.it> wrote in message
>> newseTSj.300830$%k.405531@twister2.libero.it...
>>> ! I can not create a new database with SQL SERVER MANAGEMENT STUDY
>>> EXPRESS and Windows VISTA. ERROR: Permission denied CREATE DATABASE
>>> (Micorosoft SQL Server Error: 262)
>>> But how do I give me the permission?
>>> Someone me knows?
>>> Thank you very much everybody!
>>> Aldo
>>>
>>
>
>

I am successful!
I made right clicking on the SSMS icon and click "Run as Administrator" and
everything works!
THANK YOU VERY MUCH !!!!

Aldo



"Ekrem Önsoy" <ekrem@compecta.com> ha scritto nel messaggio
news:7170E20B-7599-40B1-B1F1-35A7F5197AB6@microsoft.com...
> If you log in to your Windows as a normal user, then your Windows Account
> would not be a member of the Local Administrators Windows Group. And when
> connecting to your SQL Server instance, you'd only have rights as much as
> a normal user.
>
> If you managed to install SQL Server using the same Windows Account, then
> it must be an Administrator account. You may have UAC (User Access Control
> which is a new feature of Vista and it assumes you are a normal user even
> if you'd be an administrator unless you demand for this right
> particularly) active as you run under Windows Vista. So, when openning
> SSMS, you can try right clicking on the SSMS icon and click "Run as
> Administrator". This may be the fact that prevents you logging in as an
> Administrator.
>
> To see Windows account in your system, you can right click on your
> "Computer" icon on your desktop (or whereever it is) and click "Manage" on
> the popup menu. Then go to "Local Users and Groups" and expand it, then go
> to Users node. Alternatively, you can use Control Panel's "User Accounts"
> component.
>
> --
> Ekrem Önsoy
>
>
>
> "Odla" <boffialdo@libero.it> wrote in message
> news:8IVSj.300882$%k.405579@twister2.libero.it...
>> Yes, I use Windows Authentication mode and Windows account.
>> How I can check if it is member of "Local Administrator"?
>> May be this is the problem!
>> Thank you very much for your !
>> Aldo
>>
>>
>>
>> "Ekrem Önsoy" <ekrem@compecta.com> ha scritto nel messaggio
>> news:72F479FC-731C-4EB7-871A-6C93400D5C2B@microsoft.com...
>>> If you connect to your SQL Server instance using Windows Authentication
>>> mode and Windows account that is a member of the "Local Administrators"
>>> Windows Group, then you should be able to be performing this action.
>>>
>>> Are you using a customized Login when connecting to your SQL Server
>>> insance? If so, what permissions did you assign to this Login?
>>>
>>> --
>>> Ekrem Önsoy
>>>
>>>
>>> "Odla" <boffialdo@libero.it> wrote in message
>>> newseTSj.300830$%k.405531@twister2.libero.it...
>>>> ! I can not create a new database with SQL SERVER MANAGEMENT STUDY
>>>> EXPRESS and Windows VISTA. ERROR: Permission denied CREATE DATABASE
>>>> (Micorosoft SQL Server Error: 262)
>>>> But how do I give me the permission?
>>>> Someone me knows?
>>>> Thank you very much everybody!
>>>> Aldo
>>>>
>>>
>>
>>
>