Hello
I am installing Site Recovery Manager. I have a few questions about the database configuration. In my install steps for the database
I have the following:
-
For Microsoft SQL Server, the database should be configured as follows:
1. Schema name should be same as the user name and you must have a default schema associated with the user account
2. Bulk insert administrator privileges
3. If Windows authentication is used, install SRM service on a host that shares the same domain as the database server
4. If SQL Server is installed locally, you might need to disable the shared memory network setting on the database server
-
I have practically 0 experience with SQL 2005.
How do you ensure that the Schema name should be the same as the user name? My user name will be "vcadmin"
How do you " Bulk insert administrator privleges"
Thanks everyone...
I am no SQL 2005 expert either.....DB2 was my thing before VMware
CREATE SCHEMA vcadmin
AUTHORIZATION vcadmin;
GO
will create the vcadmin schema with vcadmin being the owner. In SQL Server 2005 every user will have a default schema and if no default schema has been assigned to a user, they will be part of the DBO schema.
the format for granting bulk insert is:
GRANT ADMINISTER BULK OPERATIONS TO VCADMIN
alternatively just make your VCADMIN user the database owner when you create the database.
cheers
Lee
I am no SQL 2005 expert either.....DB2 was my thing before VMware
CREATE SCHEMA vcadmin
AUTHORIZATION vcadmin;
GO
will create the vcadmin schema with vcadmin being the owner. In SQL Server 2005 every user will have a default schema and if no default schema has been assigned to a user, they will be part of the DBO schema.
the format for granting bulk insert is:
GRANT ADMINISTER BULK OPERATIONS TO VCADMIN
alternatively just make your VCADMIN user the database owner when you create the database.
cheers
Lee