10 June, 2009
0 Comments
0 categories
If you have a development VMware image, which is not a member of the domain hosting you’re database, you can still make use of “windows authentication” by running the database script or Microsoft SQL Server Manger as a domain user.
c:\>runas /netonly /user:domain\user "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
To run a database installation bat file, that uses sqlcmd.exe to execute *.sql scripts, use:
c:\>runas /netonly /user:domain\user "cmd”
In the commandlinedialog execute you’re bat file:
C:\Projects\Test>DatabaseInstallation.cmd TestDomain\ONTW1_2008 TestDatabase TestDomain
Tags: SQL Server