Creating new sql database from a different server than sql

[gaurang.vora]

Hi All, Can any one please help me on creating sql database on sql
server from a different application server, i could find lot of
examples where the code would create the database with "Create
Database" command on the server where SQL is installed, but my
application is on appserver1 and SQL is installed on SQL1, 2 different
servers. I am using C# and SQL2K. Any help would be highly
appreciated. Thanks.

 

[Mary Chipman [MSFT]]

You are still going to have to pass the T-SQL CREATE DATABASE command
to the second server even though you are using C3. The calling process
will need to have permissions configured on the second server in order
to execute the command.

--Mary

 

[gaurang.vora]

You are still going to have to pass the T-SQL CREATE DATABASE command
to the second server even though you are using C3. The calling process
will need to have permissions configured on the second server in order
to execute the command.

--Mary

Hi, I would pass the T-SQL of Create Database through a command object
from C#, but i am not aware about the permissions to be configured on
the SQL server, so can you please guide me through the same. Thanks.

 

[Mary Chipman [MSFT]]

The database administrator on the target server must configure the
necessary permissions for you -- it's not something you can do from
client code.

--Mary

 

[gaurang.vora]

The database administrator on the target server must configure the
necessary permissions for you -- it's not something you can do from
client code.

--Mary

Hi, Thank you very much for the help. But i am curious to know what
permission are you talking about, is it user level permission, means
the user who is going to run the app should be allowed to create the
database, if yes then can you please tell me how it could be done, i
would personally like to do this so i can learn more.

 

[Mary Chipman [MSFT]]

SQL Server security is a complex topic. A good place to start is the
SQL Server security portal --
http://technet.microsoft.com/en-us/sqlserver/bb331769.aspx. Look at
the overview, best practices and considerations topics under "Database
Engine".

--Mary