Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

how to create a database with Windows credential Expand / Collapse
Author
Message
Posted Monday, October 1, 2012 5:26 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Tuesday, October 2, 2012 2:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:39 AM
Points: 5,142, Visits: 4,935
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
Posted Tuesday, October 2, 2012 10:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Wednesday, October 3, 2012 1:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:39 AM
Points: 5,142, Visits: 4,935
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.



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 #1367439
Posted Wednesday, October 3, 2012 4:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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 »

Add to briefcase

Permissions Expand / Collapse