Post reply

how to create a database with Windows credential

  • October 1, 2012 at 5:26 pm

    #262480

    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.

  • October 2, 2012 at 2:20 am

    #1544250

    CREATE DATABASE

  • October 2, 2012 at 10:45 am

    #1544491

    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!

  • October 3, 2012 at 1:37 am

    #1544709

    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.

  • October 3, 2012 at 4:21 pm

    #1545258

    Thanks. It works.

    >sqlcmd -S myservername -E

    >go

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply