Showing posts with label necessary. Show all posts
Showing posts with label necessary. Show all posts

Monday, March 26, 2012

Minium Permissions necessary to create a login?

What are the minimum permissions necessary to use CREATE LOGIN?

I'm using db_accessAdmin and db_securityAdmin and db_owner. The user as access to the database.

It still says I can't create the login. What am I missing?

The answer is in Books Online:

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

"Requires ALTER ANY LOGIN permission on the server. If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission on the server."

Creating a login requires permissions at the server level, it cannot be accomplished with database level permissions.

Thanks
Laurentiu

sql

Minium Permissions necessary to create a login?

What are the minimum permissions necessary to use CREATE LOGIN?

I'm using db_accessAdmin and db_securityAdmin and db_owner. The user as access to the database.

It still says I can't create the login. What am I missing?

The answer is in Books Online:

http://msdn2.microsoft.com/en-us/library/ms189751.aspx

"Requires ALTER ANY LOGIN permission on the server. If the CREDENTIAL option is used, also requires ALTER ANY CREDENTIAL permission on the server."

Creating a login requires permissions at the server level, it cannot be accomplished with database level permissions.

Thanks
Laurentiu

Friday, March 23, 2012

Minimum version of Visual Studio.NET

What is the minimum requirement or version of Visual Studio.NET
necessary for editing reports when running Reporting Services. I am
running on a SQL 2000 sp3 and Windows 2003 server.Anything that comes with VS.2003 (It cannot be VS 2005). The cheapest is
VB.Net
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"refdk" <fuhlendorf@.gmail.com> wrote in message
news:1140804364.362272.141300@.z34g2000cwc.googlegroups.com...
> What is the minimum requirement or version of Visual Studio.NET
> necessary for editing reports when running Reporting Services. I am
> running on a SQL 2000 sp3 and Windows 2003 server.
>|||Thanks, I will try that :-)
/Ren=E9

Friday, March 9, 2012

migration tips

is there any materials online

for migrating to 2005 rs.

is it necessary to migrate the reportserver db to 2005 also?

Hey joeydj, nice to see you here. You might want to take the MOC 7031. You can also check out http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rptsvcs.mspx for other resources which might be of use to you|||thanks for the link