how to create a database with Windows credential

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » how to create a database with Windows...

how to create a database with Windows credential

Rate Topic

Display Mode

Topic Options

Author

Message

Jane Fu

Posted Monday, October 01, 2012 5:26 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, October 22, 2012 2:51 PM
Points: 12, Visits: 11

I was assgined a windows credentials (a user name and password), which only has the permission create a database.

But how can I create a DB with it? What is the syntax?

Please help!!!!

Thanks a bunch.

Post #1366833

anthony.green

Posted Tuesday, October 02, 2012 2:20 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

CREATE DATABASE

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1366895

Jane Fu

Posted Tuesday, October 02, 2012 10:45 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, October 22, 2012 2:51 PM
Points: 12, Visits: 11

Maybe I didn't explain my problem clearly------

I was given a windows user name and password. The only permission this user has is to create a database. With this user name, I am not able to remote in the Windows server which has SQL Server installed. And I am not able to connect to the SQL server with the SQL Management Studio.

How to create a DB with it?

Help!

Post #1367169

anthony.green

Posted Wednesday, October 03, 2012 1:37 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

from your local machine, login as that user, then run a command line tool called SQLCMD passing in the parameters needed along with your create database statement.

Post #1367439

Jane Fu

Posted Wednesday, October 03, 2012 4:21 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, October 22, 2012 2:51 PM
Points: 12, Visits: 11

Thanks. It works.

>sqlcmd -S myservername -E
>go

Post #1368086

« Prev Topic | Next Topic »

Permissions