authentication Mode

I am developing a client/server application using sql server as the back end
.
This app must allow for two login scenarios other than the usual one
user/one workstation. First, the app must allow users to log in from any
machine on the network even when using a machine running under a different
users login. Second, the app must be available to someone that does not hav
e
a windows login, eg a field worker that needs to access the app occasioniall
y
using a machine running under a different users login. For these reasons, I
have been using mixed mode authentication which does the job. Since all the
documentation seems to recommend Windows authentication mode and mixed mode
is for backward compability, am I missing something here? Can I handle the
two scenarios, particularly the second using Windows Authentication?
JBConsider using an Application Role rather than user level security.
Look in Books Online for "Establishing Application Security and Application
Roles".
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"JB" <JB@.discussions.microsoft.com> wrote in message
news:AA8A22DC-D007-4CBE-BFF8-758693B9FCC0@.microsoft.com...
>I am developing a client/server application using sql server as the back
>end.
> This app must allow for two login scenarios other than the usual one
> user/one workstation. First, the app must allow users to log in from any
> machine on the network even when using a machine running under a different
> users login. Second, the app must be available to someone that does not
> have
> a windows login, eg a field worker that needs to access the app
> occasionially
> using a machine running under a different users login. For these reasons,
> I
> have been using mixed mode authentication which does the job. Since all
> the
> documentation seems to recommend Windows authentication mode and mixed
> mode
> is for backward compability, am I missing something here? Can I handle
> the
> two scenarios, particularly the second using Windows Authentication?
> JB|||That's hard to say as this line doesn't make sense:
"Second, the app must be available to someone that does not
have a windows login, eg a field worker that needs to
access the app occasionially using a machine running under
a different users login"
So what login is the "different users login" - but the user
doesn't have a login?
It really depends on what login is being used, if the field
work is accessing a machine in a domain, if it's multiple
domains, depends on trusts that may or may not be setup,
etc.
In terms of the other issue, Machines and logins are two
different things. If I have my windows login setup for
access to a SQL Server box in my domain, it doesn't matter
what machine I use. If I login into the network, that's the
credentials that are used no matter what machine I may be
logged into.
If users are logging into the domain with all different
logins, accessing network resources with various logins then
you have a security mess at the network level which will
lead to security messes in SQL Server as well when
implementing Windows authentication.
-Sue
On Fri, 22 Sep 2006 10:17:01 -0700, JB
<JB@.discussions.microsoft.com> wrote:

>I am developing a client/server application using sql server as the back en
d.
> This app must allow for two login scenarios other than the usual one
>user/one workstation. First, the app must allow users to log in from any
>machine on the network even when using a machine running under a different
>users login. Second, the app must be available to someone that does not ha
ve
>a windows login, eg a field worker that needs to access the app occasionial
ly
>using a machine running under a different users login. For these reasons,
I
>have been using mixed mode authentication which does the job. Since all th
e
>documentation seems to recommend Windows authentication mode and mixed mode
>is for backward compability, am I missing something here? Can I handle the
>two scenarios, particularly the second using Windows Authentication?
>JB

Audit Failures whenever I start the SQL Enterprise Manager

Hi,
When ever I start the Enterprise manger client from my laptop(Client), I see
the Failure Audit in the Security Eventlog. I registered all the servers
using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
Here is one of the error:
Unprotection of auditable protected data.
Data Description: SQL Server Registration
Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
Protected Data Flags: 0x0
Protection Algorithms: 3DES-168 , SHA1-160
Failure Reason: 0x8009000B
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Can anybody having the fix for this, because my securtiy Auditing team
questioning these failures.
Thanks
rb
1. Do you have encryption enabled on the client or server?
2. When this happens is the laptop connected to the network?
3. Do you have any IPSec rules setup for the SQL Server?
"rb" <srbssr@.yahoo.com> wrote in message
news:efxp4cN9EHA.2600@.TK2MSFTNGP09.phx.gbl...
> Hi,
> When ever I start the Enterprise manger client from my laptop(Client), I
see
> the Failure Audit in the Security Eventlog. I registered all the servers
> using sql authentication. I am running SQL Enterprisemanger on Windows Xp.
> Here is one of the error:
> Unprotection of auditable protected data.
> Data Description: SQL Server Registration
> Key Identifier: 1f3ba71a-6f52-4e58-8007-43ced74242b4
> Protected Data Flags: 0x0
> Protection Algorithms: 3DES-168 , SHA1-160
> Failure Reason: 0x8009000B
>
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> Can anybody having the fix for this, because my securtiy Auditing team
> questioning these failures.
> Thanks
> rb
>

Attribute relationship doestn't exisits between

I am using SSAS 2005 (64bit)
i have client table
Dimension is
ClientShortCode (First letter of clientcode)
ClientCode
ClientName
In Dataview
Related clientcode to clientcode in fact table.
Before SP2 installation works fine, when i browse the dimension it looks like
A
ACC
Axxxx (name of client)
ABI
Abi....
....
....
....
L
LUJACK
LUMBERJACKS
After installing SP2, it give warning message
Attribute relationship doestn't exisits between one or more levels in this
hierachy
Is there any thing we need to do after installing SP2
any soultions or idea
Thanks in advance
kk
Well, did you check the atribute relationships in the dimension?
MC
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:43D2E6FA-B462-4132-9336-944AA350F07A@.microsoft.com...
> I am using SSAS 2005 (64bit)
> i have client table
> Dimension is
> ClientShortCode (First letter of clientcode)
> ClientCode
> ClientName
>
>
> In Dataview
> Related clientcode to clientcode in fact table.
>
> Before SP2 installation works fine, when i browse the dimension it looks
> like
>
> A
> ACC
> Axxxx (name of client)
> ABI
> Abi....
> ....
> ....
> ....
>
> L
> LUJACK
> LUMBERJACKS
>
>
> After installing SP2, it give warning message
> Attribute relationship doestn't exisits between one or more levels in this
> hierachy
>
> Is there any thing we need to do after installing SP2
> any soultions or idea
>
> Thanks in advance
> kk
|||I gave relationship in data view, can you explain me how to check
atribute relationships in the dimension?
Thanks
Kalyan
"MC" wrote:

> Well, did you check the atribute relationships in the dimension?
>
> MC
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:43D2E6FA-B462-4132-9336-944AA350F07A@.microsoft.com...
>
>
|||You need to go to the dimension editor in BIDS and check on the atribute
relationships for the atributes involved.
MC
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:D993701D-45E5-454A-A28D-84D33EE515B0@.microsoft.com...[vbcol=seagreen]
> I gave relationship in data view, can you explain me how to check
> atribute relationships in the dimension?
> Thanks
> Kalyan
> "MC" wrote:

Attribute relationship doestn't exisits between

I am using SSAS 2005 (64bit)
i have client table
Dimension is
ClientShortCode (First letter of clientcode)
ClientCode
ClientName
In Dataview
Related clientcode to clientcode in fact table.
Before SP2 installation works fine, when i browse the dimension it looks lik
e
A
ACC
Axxxx (name of client)
ABI
Abi....
...
...
...
L
LUJACK
LUMBERJACKS
After installing SP2, it give warning message
Attribute relationship doestn't exisits between one or more levels in this
hierachy
Is there any thing we need to do after installing SP2
any soultions or idea
Thanks in advance
kkWell, did you check the atribute relationships in the dimension?
MC
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:43D2E6FA-B462-4132-9336-944AA350F07A@.microsoft.com...
> I am using SSAS 2005 (64bit)
> i have client table
> Dimension is
> ClientShortCode (First letter of clientcode)
> ClientCode
> ClientName
>
>
> In Dataview
> Related clientcode to clientcode in fact table.
>
> Before SP2 installation works fine, when i browse the dimension it looks
> like
>
> A
> ACC
> Axxxx (name of client)
> ABI
> Abi....
> ....
> ....
> ....
>
> L
> LUJACK
> LUMBERJACKS
>
>
> After installing SP2, it give warning message
> Attribute relationship doestn't exisits between one or more levels in this
> hierachy
>
> Is there any thing we need to do after installing SP2
> any soultions or idea
>
> Thanks in advance
> kk|||I gave relationship in data view, can you explain me how to check
atribute relationships in the dimension?
Thanks
Kalyan
"MC" wrote:

> Well, did you check the atribute relationships in the dimension?
>
> MC
>
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:43D2E6FA-B462-4132-9336-944AA350F07A@.microsoft.com...
>
>|||You need to go to the dimension editor in BIDS and check on the atribute
relationships for the atributes involved.
MC
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:D993701D-45E5-454A-A28D-84D33EE515B0@.microsoft.com...[vbcol=seagreen]
> I gave relationship in data view, can you explain me how to check
> atribute relationships in the dimension?
> Thanks
> Kalyan
> "MC" wrote:
>

attaching to msdb db

Hello there
On the business i;m working on, I've installed MSDE on my client computer.
So far i've worked with SQL sever 2000
now i transfered to sql server 2005.
and i tried to attach one of my files. It gave me Error because my DB i;m
trying to attach is bigger then 2GB (which is not possible according to
microsoft Licence)
now what can i do,
if i instead of detach and attach i do backup and restore it allow me to do
that?Roy
SQL Server 2005 Express Edition has 4GB limited .Or do you try to attach
SQL Server 2005 to MSDE database?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:umkvw3UGHHA.4116@.TK2MSFTNGP05.phx.gbl...
> Hello there
> On the business i;m working on, I've installed MSDE on my client computer.
> So far i've worked with SQL sever 2000
> now i transfered to sql server 2005.
> and i tried to attach one of my files. It gave me Error because my DB i;m
> trying to attach is bigger then 2GB (which is not possible according to
> microsoft Licence)
> now what can i do,
> if i instead of detach and attach i do backup and restore it allow me to
> do that?
>

attaching to msdb db

Hello there
On the business i;m working on, I've installed MSDE on my client computer.
So far i've worked with SQL sever 2000
now i transfered to sql server 2005.
and i tried to attach one of my files. It gave me Error because my DB i;m
trying to attach is bigger then 2GB (which is not possible according to
microsoft Licence)
now what can i do,
if i instead of detach and attach i do backup and restore it allow me to do
that?
Roy
SQL Server 2005 Express Edition has 4GB limited .Or do you try to attach
SQL Server 2005 to MSDE database?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:umkvw3UGHHA.4116@.TK2MSFTNGP05.phx.gbl...
> Hello there
> On the business i;m working on, I've installed MSDE on my client computer.
> So far i've worked with SQL sever 2000
> now i transfered to sql server 2005.
> and i tried to attach one of my files. It gave me Error because my DB i;m
> trying to attach is bigger then 2GB (which is not possible according to
> microsoft Licence)
> now what can i do,
> if i instead of detach and attach i do backup and restore it allow me to
> do that?
>
|||Maybe one of the following will help you:
1. If the db has a lot of free space, see if shrinking will reduce the size.
2. Move some tables into a new database, then shrink and attach both.
3. Delete and/or move some of your older data into a new database, then
shrink and attach both.

attaching to msdb db

Hello there
On the business i;m working on, I've installed MSDE on my client computer.
So far i've worked with SQL sever 2000
now i transfered to sql server 2005.
and i tried to attach one of my files. It gave me Error because my DB i;m
trying to attach is bigger then 2GB (which is not possible according to
microsoft Licence)
now what can i do,
if i instead of detach and attach i do backup and restore it allow me to do
that?Roy
SQL Server 2005 Express Edition has 4GB limited .Or do you try to attach
SQL Server 2005 to MSDE database?
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:umkvw3UGHHA.4116@.TK2MSFTNGP05.phx.gbl...
> Hello there
> On the business i;m working on, I've installed MSDE on my client computer.
> So far i've worked with SQL sever 2000
> now i transfered to sql server 2005.
> and i tried to attach one of my files. It gave me Error because my DB i;m
> trying to attach is bigger then 2GB (which is not possible according to
> microsoft Licence)
> now what can i do,
> if i instead of detach and attach i do backup and restore it allow me to
> do that?
>|||Maybe one of the following will help you:
1. If the db has a lot of free space, see if shrinking will reduce the size.
2. Move some tables into a new database, then shrink and attach both.
3. Delete and/or move some of your older data into a new database, then
shrink and attach both.

Attaching a mdf to a SQL Express instance during installation

Hi,

Im working in a proyect where i need to attach a mdf database to the client's SQL express instance. How can i accomplish during installation and without getting the user involved.

Any help will be greatly appretiated

I've been trying the following procedure:

Server svr = new Server(@."(local)\SQLEXPRESS");

System.Collections.Specialized.StringCollection sc = new System.Collections.Specialized.StringCollection();

sc.Add("c:\\Tester.mdf");

svr.AttachDatabase("Tester", sc);

But im getting the followin Error :

Exception has been thrown by the target of an invocation.

Any ideas?

|||

Hi,

could you please post the whole error message you are getting ? The problem is probably that the install process is using an account which is not priviledged to either access the files or attaching a database. if you want to use a special account to connect to the server you should use one of the other constructors of the server objects, specifying a special user or a connection string. if you have any further problems, come back with the whole error messages please.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks for answering Jens,

Here is the whole error Im getting:

Exception has been thrown by the target of an invocation.
StackTrace:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.runTryCode(Object userData)
at System.Runtime.CompilerServices.RuntimeHelpers.ExecuteCodeWithGuaranteedCleanup(TryCode code, CleanupCode backoutCode, Object userData)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at System.Windows.Forms.Form.ShowDialog()
at Casa.it.MainForm.MainForm_Load(Object sender, EventArgs e) in C:\CS_Proyects\Casa.it\Casa.it\MainForm.cs:line 50
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.SendMessage(HandleRef hWnd, Int32 msg, Int32 wParam, Int32 lParam)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.Run(Form mainForm)
at Casa.it.Program.Main() in C:\CS_Proyects\Casa.it\Casa.it\Program.cs:line 19
Source:
mscorlib

Hope it helps.

attaching a .mdf file to the MSSQL 2000 using commandline

Hi ,

we have a requirement to create a database of our application in client's system. and we assume that already MS Sql server is installed.

we have a .mdf file of our database. Is there any way I can attach .mdf file to the database using command line. so that I can write a batch file and run that batch to create the database in our client's system.

-regards

GRK

you can use SQL scripting method. If it is sql server 2005 then use SQLCMD -q and if it is sql server 2000 then use OSQL -q option.

Madhu

|||

Look in Books Online about the usage of [ sp_attach_single_file ].

|||

thanks Arnie,

its working. I used the [sp_attach_single_file] with osql from the command prompt and created a database.

-regards

GRK

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
Al
Hi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/default...en-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>
|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>

Attach/Detach database

I need to copy my SQL Server 2000 database from my development machine to
the server of one of the client. By using Enterprise Manager I was going to
detach db from my server, create a database with the same name on a new
server, detach it, replace files on the new server with my copies and attach
both databases on both servers back.
Unfortunately my server displays Attach Database entry only in popup menu. I
have nothing to attach yet.
I did this operation several times and had no problem before. Probably I
detached some of the unimportant databases and forgot to attach it back.
How can I refresh (clean up whatever) Enterprise Manager memory about last
operation in order to have the ability to use Detach feature?
Thank you
AlHi
I would recommend that you do this from Query Analyser, there is no need to
create the database first.
http://support.microsoft.com/defaul...ben-us%3b224071
John
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
> I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>|||The detach option is context-sensitive so you need to first select the
desired database in the tree.
You should not create a new database before attaching. Detach the database
and copy the files to the new server. In the Attach database dialog,
specify the mdf file, click Verify and specify the desired database name in
the 'Attach As' box. You can change the locations of the other files in the
list, if needed.
You might also consider using the sp_attach_db and sp_detach_db stored
procedures. See the Books Online for more information.
Hope this helps.
Dan Guzman
SQL Server MVP
"vul" <aaa@.optonline.net> wrote in message
news:enYHb8trEHA.3900@.TK2MSFTNGP10.phx.gbl...
>I need to copy my SQL Server 2000 database from my development machine to
> the server of one of the client. By using Enterprise Manager I was going
> to
> detach db from my server, create a database with the same name on a new
> server, detach it, replace files on the new server with my copies and
> attach
> both databases on both servers back.
> Unfortunately my server displays Attach Database entry only in popup menu.
> I
> have nothing to attach yet.
> I did this operation several times and had no problem before. Probably I
> detached some of the unimportant databases and forgot to attach it back.
> How can I refresh (clean up whatever) Enterprise Manager memory about last
> operation in order to have the ability to use Detach feature?
> Thank you
> Al
>