mssqlcompressed-users

[Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Otis L. <oti...@go...>]

>
> Hi there,


is it possible to make a connection (and backup) with a special User and
Password to connect to the database?
I have tried several Versions but the commandline throws an error that the
UserCredentials (it takes my Windows - logincredentials)
have not the special rights to connect to the database.

Thank you and best regards!
Otis Loomgard

Some Examples would be fine.

Re: [Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Clay L. <cl...@le...>]

Otis,

The app makes two connections to SQL Server. One is a standard ADO.Net
connection where you can use SQL Logins. The second connection
receives the stream of bytes to save and only authenticates using
Windows Authentication.  It is possible to authenticate differently
with the two connections, but I'd want to hear why this would be
useful as it could lead to a brittle application that might only
partitially connect to SQL Server.

Another option is to change the app to install a Windows Service
running as a Windows user that has high SQL Server permissions to make
the second connection and receive the data, however this connection
would be responsible for writing the data and this service user may
not have the rights to write to the file especially if the file is on
a network share.

In general, I'd prefer the permissions to be simple as possible: only
one Windows user is involved and this user must have the appropriate
rights in both SQL Server and the filesystem, though I'm open to hear
how this restriction might cause problems for people.

Cheers,
Clay

On Tuesday, December 8, 2009, Otis Loomgard <oti...@go...> wrote:
> Hi there,
> is it possible to make a connection (and backup) with a special User and Password to connect to the database?
>
> I have tried several Versions but the commandline throws an error that the UserCredentials (it takes my Windows - logincredentials)have not the special rights to connect to the database.
>
>
> Thank you and best regards!Otis Loomgard
> Some Examples would be fine.
>
>

Re: [Mssqlcompressed-users] User and Passwordcredentials in Connectionstring

[Otis L. <oti...@go...>]

Hello Clay,

you are right.
I created a user on the DB with my Windows - usergroup - credentials and
gave him the sysadmin-role.
The DB runs on a Windows 2008 System, so i fire the batch in a planned task
with the Checkbox "highest  rights"
(dont know, how it is written in english (it's a german system).

here is the batch (the echos are for the test):

echo off

SET
logfile="d:\db-Dumps\NV-REP_ENTW_BACKUP_LOG-%date:~-4,4%-%date:~-7,2%-%date:~0,2%%1%.log"

echo ========================== Starting Backup Of Repository NV_REP_ENTW
================================

C:\MSSQLCompressedBackup\msbp.exe backup "db(database=NV_REP_ENTWICKLUNG)"
"zip64(level=3)" "local(path=d:\db-Dumps\NV_REP_ENTW.bak.zip)"  >> %logfile%

echo ============================= finished Backup
==============================

: end

Your application is absolutely great! especially, if you have
commandline-admins and they think that we developer will reach with
10 GB 100 years ;-)


Sorry, my english is absolutely bad...
Have a nice day and thank you very much!

Otis