active/active sql node

Hello,
This is my time to setup active/active SQL on two nodes cluster environment.
I am very familiar with active/passive in which setup one virtual name such
as virtualsql01 and publish to user. For active/active, it seems to me that
system does not allow me to have something like virtualsql01 and
virtualsql02 but it forces to key-in instant name like virtualsql01\xxxx.
My question is that how can we have something like virtualsql01 and
virtualsql02 in the same cluster environment. I believe it will be easy for
everyone in my place to call db server in this way.
Thanks.
Your VirtualSQL01 is the default instance for the cluster. Like a
stand-alone server, you only get one default instance, except it is per
cluster, not per node. I avoid the whole default name on a cluster and use
only named instances. That way, I don't have to explain to the developers
why the names look different.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
> environment. I am very familiar with active/passive in which setup one
> virtual name such as virtualsql01 and publish to user. For active/active,
> it seems to me that system does not allow me to have something like
> virtualsql01 and virtualsql02 but it forces to key-in instant name like
> virtualsql01\xxxx. My question is that how can we have something like
> virtualsql01 and virtualsql02 in the same cluster environment. I believe
> it will be easy for everyone in my place to call db server in this way.
> Thanks.
>
|||Just want to add that if you already have virutalsql01 in a cluster, you
can't have virtualsql01\xxx in that same cluster. In other words, there can
be only a single SQL instance per virtual server.
Suffice it to say that you are not the only person puzzled by this peculiar
design choice. I for one would much prefer what you wanted, i.e. simply
virtualsql01, virutalsql02, and so on for different SQL instances in a
cluster.
But if you are willing to explicitly use port numbers, you don't have to
force your users to use the format of virtualserver\sqlinstance. Instead,
they can use <fqdn>,<port number> (e.g. nycsql01.nyc.myfirm.com,9876) to
connect. Some people consider using an explicit port number in a connection
string not to be best practice, I should note.
Linchi
"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
> environment. I am very familiar with active/passive in which setup one
> virtual name such as virtualsql01 and publish to user. For active/active,
> it seems to me that system does not allow me to have something like
> virtualsql01 and virtualsql02 but it forces to key-in instant name like
> virtualsql01\xxxx. My question is that how can we have something like
> virtualsql01 and virtualsql02 in the same cluster environment. I believe
> it will be easy for everyone in my place to call db server in this way.
> Thanks.
>
|||Normally, on a stand-alone system, you would get 1 ServerName (default
instance) and then possibly several named instances ServerName\Instance1,
ServerName\Instance2, . . ., ServerName\Instance15, up to 15 named and 1
default, or 16 namedactually, you can have many more, but Microsoft only
supporting up to 16 total instances, named or default.
The problem with clusters is that each participating node looks like a stand
alone server in that each may host all instances; thus, the binaries and the
naming convention above still applies; however, for a cluster, you have to
create a virtual server resource group for each instance to support the Disk
(which is the critical factor), IP, and Network Name. It is the Network
Name, which knows nothing of SQL Server instances, that must each be unique
within the cluster installation.
So, you end up with unique network names because of clustering, which is a
restriction even before SQL Server is installed, and unique instance names
because of multiple concurrent SQL Server hosting on any one failover node.
Sincerely,
Anthony Thomas

"naruphon" <naruphon@.hotmail.com> wrote in message
news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> Hello,
> This is my time to setup active/active SQL on two nodes cluster
environment.
> I am very familiar with active/passive in which setup one virtual name
such
> as virtualsql01 and publish to user. For active/active, it seems to me
that
> system does not allow me to have something like virtualsql01 and
> virtualsql02 but it forces to key-in instant name like virtualsql01\xxxx.
> My question is that how can we have something like virtualsql01 and
> virtualsql02 in the same cluster environment. I believe it will be easy
for
> everyone in my place to call db server in this way.
> Thanks.
>
|||Thanks to everyone, very straight to the point, keen and concise.
Naruphon
"Anthony Thomas" <ALThomas@.kc.rr.com> wrote in message
news:%23AOg2vi2FHA.1576@.TK2MSFTNGP15.phx.gbl...
> Normally, on a stand-alone system, you would get 1 ServerName (default
> instance) and then possibly several named instances ServerName\Instance1,
> ServerName\Instance2, . . ., ServerName\Instance15, up to 15 named and 1
> default, or 16 namedactually, you can have many more, but Microsoft only
> supporting up to 16 total instances, named or default.
> The problem with clusters is that each participating node looks like a
> stand
> alone server in that each may host all instances; thus, the binaries and
> the
> naming convention above still applies; however, for a cluster, you have to
> create a virtual server resource group for each instance to support the
> Disk
> (which is the critical factor), IP, and Network Name. It is the Network
> Name, which knows nothing of SQL Server instances, that must each be
> unique
> within the cluster installation.
> So, you end up with unique network names because of clustering, which is a
> restriction even before SQL Server is installed, and unique instance names
> because of multiple concurrent SQL Server hosting on any one failover
> node.
> Sincerely,
>
> Anthony Thomas
>
> --
> "naruphon" <naruphon@.hotmail.com> wrote in message
> news:O5OnMwY2FHA.3416@.tk2msftngp13.phx.gbl...
> environment.
> such
> that
> for
>

Active/Active or Active/Passive

Hello,
We are going to design our SQL Server databases on either Active/Active or
Active/Passive of Windows 2003 clusters.
Has any one seen real time risk and their real experiences of using
Active/Active clusters?
Thanks, John
The only real issue is when one node dies and its SQL instance(s)
failover to the other node so a single node has multiple instances
running on it. You just need to make sure each node has enough
resources (CPU and memory primarily and to a lesser extent NIC
throughput and SCSI controller (or SAN HBA) capacity) to support both
instances simultaneously.
It also depends on whether it's acceptable to your business to run both
SQL instances at a degraded performance level until you can get the dead
node back on its feet (assuming the business doesn't want to fork out
the cash to have more CPU & memory in each node in order to adequately
run both instances on one node).
Personally, where I work we run 4 production clusters (each with 2 SQL
instances on it) and an off-site DR cluster (with 2 SQL instances on
it). I can't remember a problem in the last 5 years that we've had on
any instance on our clusters that wouldn't have also happened if we'd
only had a single instance on each cluster (the issue were all OS level
or hardware level issues - to be honest, our stand-alone SQL boxes were
always more stable but obviously didn't have the failover capacity if
something went wrong). However, we tend to run cluster nodes with a
little resource overhead in them in case of a failover.
*mike hodgson*
http://sqlnerd.blogspot.com
John wrote:

>Hello,
>We are going to design our SQL Server databases on either Active/Active or
>Active/Passive of Windows 2003 clusters.
>Has any one seen real time risk and their real experiences of using
>Active/Active clusters?
>Thanks, John
>

Active Directory and Stored Procedures

I have a need to access the active directory from a stored

procedure. I am certain that CLR is the answer but I am having a

hard time finding and example and I am a true newbie to AD and CLR.

Has anyone ever attempted to do this? I would love to see an example in VB if possible.It's certainly feasible to use SQLCLR to access AD. However, depending on how you plan to use the data coming from AD, it's not necessarily the most convenient approach. Instead of connecting to AD from managed code, you might want to consider linking to your AD store from
within SQL Server (see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/joining_heterogeneous_data.asp,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/creating_and_executing_a_view.asp,
and http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adsi/adsi/creating_a_heterogeneous_join_between_sql_server_and_active_directory.asp for details). This would allow you to create joins directly to AD-sourced views, which may better suit your use of AD data from a stored procedure.|||Thank you, I had seen the first link and had started working with it.

I now have to find a way to convert the SID from a byte array so I can

store it in my application. I am only storing the SID and will

make "round trips" to the AD for all user information.

I appreciate your help.

Rick

Account Locked out

I have a problem that i can't log on sql server as the account is lock out. I don't know why it is locked out as this is the first time i log on. Anybody has this experience? Thank you very much!Did you ask your dba what is going on?|||Locked out?

What message are you getting and what's the login you are using?

Tell me it's sa|||i am using administrator account to log in.|||your dba changed the sa password...if you are a developer, you shouldn't be using sa

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
Thanks.
David
You may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David
|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:

> You may be able to use your transaction logs to do a point in time restore,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
>
>
|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
[vbcol=seagreen]
>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
point in time restore,[vbcol=seagreen]
message[vbcol=seagreen]
69D4AA671891@.microsoft.com...[vbcol=seagreen]
don't have a backup[vbcol=seagreen]
there's a way to recover
>.
>
|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:

> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> point in time restore,
> message
> 69D4AA671891@.microsoft.com...
> don't have a backup
> there's a way to recover
>
|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...[vbcol=seagreen]
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449
|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David
|||Hi David,
Saw your reply and try download the Log P.I software and this is realyl good.
The web site is www.logpi.com You can restore the deleted transactions, but make sure you follow the steps they have mentioned.
Regards
RK.
"David" wrote:

> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
> Thanks.
> David

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at
the time I deleted. Could you all tell me if there's a way to recover those
records?
Thanks.
DavidYou may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:

> You may be able to use your transaction logs to do a point in time restore
,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
>
>|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'

>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
>
point in time restore,[vbcol=seagreen]
message[vbcol=seagreen]
69D4AA671891@.microsoft.com...[vbcol=seagreen]
don't have a backup[vbcol=seagreen]
there's a way to recover[vbcol=seagreen]
>.
>|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:

> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>
> point in time restore,
> message
> 69D4AA671891@.microsoft.com...
> don't have a backup
> there's a way to recover
>|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...[vbcol=seagreen]
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
>|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Hi David,
Saw your reply and try download the Log P.I software and this is realyl good
.
The web site is www.logpi.com You can restore the deleted transactions, but
make sure you follow the steps they have mentioned.
Regards
RK.
"David" wrote:

> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup a
t the time I deleted. Could you all tell me if there's a way to recover thos
e records?
> Thanks.
> David

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
Thanks.
DavidYou may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:
> You may be able to use your transaction logs to do a point in time restore,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> > Hello All,
> >
> > I'm need help!
> > I have accidently deleted all record from a table. I don't have a backup
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
> >
> > Thanks.
> > David
>
>|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
>> You may be able to use your transaction logs to do a
point in time restore,
>> I'm not sure, but there is hope.
>> "David" <David@.discussions.microsoft.com> wrote in
message
>> news:37E4E743-B412-4BF9-BFE2-
69D4AA671891@.microsoft.com...
>> > Hello All,
>> >
>> > I'm need help!
>> > I have accidently deleted all record from a table. I
don't have a backup
>> at the time I deleted. Could you all tell me if
there's a way to recover
>> those records?
>> >
>> > Thanks.
>> > David
>>
>.
>|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:
> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >--Original Message--
> >Lyle,
> >
> >How do I do that? Could you please share some hint?
> >
> >
> >"Lyle Spencer" wrote:
> >
> >> You may be able to use your transaction logs to do a
> point in time restore,
> >> I'm not sure, but there is hope.
> >>
> >> "David" <David@.discussions.microsoft.com> wrote in
> message
> >> news:37E4E743-B412-4BF9-BFE2-
> 69D4AA671891@.microsoft.com...
> >> > Hello All,
> >> >
> >> > I'm need help!
> >> > I have accidently deleted all record from a table. I
> don't have a backup
> >> at the time I deleted. Could you all tell me if
> there's a way to recover
> >> those records?
> >> >
> >> > Thanks.
> >> > David
> >>
> >>
> >>
> >.
> >
>|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
> > YOu will need to take your full backups and apply the
> > trans logs up to the point in time you deleted the table
> > and you can then retrieve the records.
> >
> > Here's an example from BOL
> > -- Restore the database backup.
> > RESTORE DATABASE MyNwind
> > FROM MyNwind_1, MyNwind_2
> > WITH NORECOVERY
> > GO
> > RESTORE LOG MyNwind
> > FROM MyNwind_log1
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> > GO
> > RESTORE LOG MyNwind
> > FROM MyNwind_log2
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >
> > >--Original Message--
> > >Lyle,
> > >
> > >How do I do that? Could you please share some hint?
> > >
> > >
> > >"Lyle Spencer" wrote:
> > >
> > >> You may be able to use your transaction logs to do a
> > point in time restore,
> > >> I'm not sure, but there is hope.
> > >>
> > >> "David" <David@.discussions.microsoft.com> wrote in
> > message
> > >> news:37E4E743-B412-4BF9-BFE2-
> > 69D4AA671891@.microsoft.com...
> > >> > Hello All,
> > >> >
> > >> > I'm need help!
> > >> > I have accidently deleted all record from a table. I
> > don't have a backup
> > >> at the time I deleted. Could you all tell me if
> > there's a way to recover
> > >> those records?
> > >> >
> > >> > Thanks.
> > >> > David
> > >>
> > >>
> > >>
> > >.
> > >
> >|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David

Accessing SQL Server database from Crystal Reports - being prompted to log on every time?

Hello, this is my first time posting here.
I've never really worked with SQL Server much, but I'm in the process of learning. Please forgive my ignorance.
Anyways, here's my dilemma.
A user at the office uses Crystal Reports (I'm not too familiar with this program either). Crystal Reports pulls data from SQL Server. However, every single time it does so, it prompts her to log into the database.
While there is no serious problem, this has gotten very annoying. She wants to be able to work without being prompted to log on to the database every single time Crystal Reports retrieves data.
How would I go about doing this? The office has no real security issues, so I'm open to "less-than-perfectly-secure" options as well.

I assume that by the log on prompt, you mean a request to enter a password. If that's the case, then your database application is using SQL Authentication. If Crystal Reports does not provide a "remember the password" option, you have to re-enter it each time. If you could use Windows Authentication, the need for entering a password would go away, but this would require changing the application.

Thanks
Laurentiu