I have this dilbert kinda boss. He wants to know if there is a tool for
taking part of a transaction log and load testing the server from a remote
location. We are trying to get around some licensing issues by the use of
only one centralized database. I do not have access to the source for the
application so I can not optimize it for use over a wan. It makes no use of
the server everything is clientside. So to make a long story short the
pointy head boss wants to know if he can run tests here, take the trans log
to a remote destination and be able to run those transactions from the
remote site.
whew,
jcNot the transaction log, but you can run a trace using profiler and =then replay the trace at a remote site.
Mike John
"John Cantley" <kayjohn59@.sbcglobal.net> wrote in message =news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> I have this dilbert kinda boss. He wants to know if there is a tool =for > taking part of a transaction log and load testing the server from a =remote > location. We are trying to get around some licensing issues by the use =of > only one centralized database. I do not have access to the source for =the > application so I can not optimize it for use over a wan. It makes no =use of > the server everything is clientside. So to make a long story short the =
> pointy head boss wants to know if he can run tests here, take the =trans log > to a remote destination and be able to run those transactions from the =
> remote site.
> > whew,
> jc > >|||Just adding to Mike's suggestion a little..
It's actually better to use profiler than any log analysis tool as the log
doesn't give you the selects - it only gives you the updates to the database
which is of course, only part of the load testing you're trying to perform.
Profiler gives you the selects as well, so it's necessarily a better
approach than analysing the log..
Regards,
Greg Linwood
SQL Server MVP
"Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
news:OTYeqYxJEHA.1096@.TK2MSFTNGP10.phx.gbl...
Not the transaction log, but you can run a trace using profiler and then
replay the trace at a remote site.
Mike John
"John Cantley" <kayjohn59@.sbcglobal.net> wrote in message
news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> I have this dilbert kinda boss. He wants to know if there is a tool for
> taking part of a transaction log and load testing the server from a remote
> location. We are trying to get around some licensing issues by the use of
> only one centralized database. I do not have access to the source for the
> application so I can not optimize it for use over a wan. It makes no use
of
> the server everything is clientside. So to make a long story short the
> pointy head boss wants to know if he can run tests here, take the trans
log
> to a remote destination and be able to run those transactions from the
> remote site.
> whew,
> jc
>|||And just to add a tiny bit to that:
The log only contains the effect of the modification statements. Not the statements themselves. You can have a
DELETE which modifies 1000 rows. This will be logged as 1000 delete log records in the transaction log.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Greg Linwood" <g_linwoodQhotmail.com> wrote in message news:uS6GxizJEHA.3276@.TK2MSFTNGP12.phx.gbl...
> Just adding to Mike's suggestion a little..
> It's actually better to use profiler than any log analysis tool as the log
> doesn't give you the selects - it only gives you the updates to the database
> which is of course, only part of the load testing you're trying to perform.
> Profiler gives you the selects as well, so it's necessarily a better
> approach than analysing the log..
> Regards,
> Greg Linwood
> SQL Server MVP
> "Mike John" <Mike.John@.knowledgepool.spamtrap.com> wrote in message
> news:OTYeqYxJEHA.1096@.TK2MSFTNGP10.phx.gbl...
> Not the transaction log, but you can run a trace using profiler and then
> replay the trace at a remote site.
> Mike John
> "John Cantley" <kayjohn59@.sbcglobal.net> wrote in message
> news:u1any%23wJEHA.1192@.TK2MSFTNGP11.phx.gbl...
> > I have this dilbert kinda boss. He wants to know if there is a tool for
> > taking part of a transaction log and load testing the server from a remote
> > location. We are trying to get around some licensing issues by the use of
> > only one centralized database. I do not have access to the source for the
> > application so I can not optimize it for use over a wan. It makes no use
> of
> > the server everything is clientside. So to make a long story short the
> > pointy head boss wants to know if he can run tests here, take the trans
> log
> > to a remote destination and be able to run those transactions from the
> > remote site.
> >
> > whew,
> > jc
> >
> >
>
Showing posts with label remote. Show all posts
Showing posts with label remote. Show all posts
Monday, March 26, 2012
Monday, February 20, 2012
Please Help!How to get directories list for remote machine?
Hello,
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
Pola
Pola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery =
new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =
3");
using (ManagementObjectSearcher searcher =
new ManagementObjectSearcher(localDiskQuery))
{
searcher.Scope =
new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
Pola
Pola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery =
new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =
3");
using (ManagementObjectSearcher searcher =
new ManagementObjectSearcher(localDiskQuery))
{
searcher.Scope =
new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
Please Help!How to get directories list for remote machine?
Hello,
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
PolaPola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery =
new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =
3");
using (ManagementObjectSearcher searcher =
new ManagementObjectSearcher(localDiskQuery)
)
{
searcher.Scope =
new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
PolaPola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery =
new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =
3");
using (ManagementObjectSearcher searcher =
new ManagementObjectSearcher(localDiskQuery)
)
{
searcher.Scope =
new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
Please Help!How to get directories list for remote machine?
Hello,
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
PolaPola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery = new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =3");
using (ManagementObjectSearcher searcher = new ManagementObjectSearcher(localDiskQuery))
{
searcher.Scope = new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
We are developing appl. Backup/Restore database using SQLServerAgent.
In my appl. I want to do the same as in the SQL Enterprise(2000),
when I select server for backup, Enterprise display brower list (hard
disks>dir...) for selected machine.
How I can get the browser(Hards>dirs) for selected machine?
Thanks in advance,
PolaPola
How does your question relate to SQL Server? Perhaps some controls provided
with .NET technology may help you.
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>|||Rather than using SQL Server, I suggest you consider WMI queries to
enumerate remote resources. C# example:
//System.Management rreference required
ObjectQuery localDiskQuery = new ObjectQuery("SELECT Name FROM Win32_LogicalDisk WHERE DriveType =3");
using (ManagementObjectSearcher searcher = new ManagementObjectSearcher(localDiskQuery))
{
searcher.Scope = new ManagementScope(string.Format(@."//{0}/root/cimv2",
ServerName));
foreach (ManagementObject logicalDisk in searcher.Get())
{
Console.WriteLine(WriteLine(logicalDisk["Name"].ToString());
}
}
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Pola" <Pola@.discussions.microsoft.com> wrote in message
news:05C7D6B8-E7A0-4545-90E2-4B4B36C87663@.microsoft.com...
> Hello,
> We are developing appl. Backup/Restore database using SQLServerAgent.
> In my appl. I want to do the same as in the SQL Enterprise(2000),
> when I select server for backup, Enterprise display brower list (hard
> disks>dir...) for selected machine.
> How I can get the browser(Hards>dirs) for selected machine?
> Thanks in advance,
> Pola
>
PLEASE HELP! Unable to connect to SQL Database from Report Man
Hi,
I am working with SQL Reporting services 2000... The report is unable to
connect to a remote datasource as I try to preview it. The database uses both
SQL and Windows Auth.
1. Created a shared datasource in my project
2. Deployed it on the server. Used OverwriteDataSource = false
3. Create a new shared datasource on the server. Gave a connection string
with no username and password.
4. Selected "Credentials stored securely in the report server" and then
entered the SQL server login and passoword there.
5. Changed the report properties in the manager to use this datasource.
6. While trying to "View" via report manager, I am getting the error message
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
Get Online Help
SQL Server does not exist or access denied.
CAN SOMEONE PLEASE HELP ME!!!!!!I too had this problem. The way that I fixed it was by making sure that I
could connect to the SQL server in question from the server that hosted the
reporting services website. It was the that I realized two very important
things.
1. The user profile that reporting services uses to run as a service needs
SQL server access.
2. The user profile that I entered as the login for the report needed to be
qualified with a domain name if it was a windows account.
These may not be your problem, but they were mine. I hope this helps
"PV" wrote:
> Hi,
> I am working with SQL Reporting services 2000... The report is unable to
> connect to a remote datasource as I try to preview it. The database uses both
> SQL and Windows Auth.
> 1. Created a shared datasource in my project
> 2. Deployed it on the server. Used OverwriteDataSource = false
> 3. Create a new shared datasource on the server. Gave a connection string
> with no username and password.
> 4. Selected "Credentials stored securely in the report server" and then
> entered the SQL server login and passoword there.
> 5. Changed the report properties in the manager to use this datasource.
> 6. While trying to "View" via report manager, I am getting the error message
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> Get Online Help
> SQL Server does not exist or access denied.
>
> CAN SOMEONE PLEASE HELP ME!!!!!!|||I confirmed this... Found out that I could connect from the Reporting
services machine to my SQL Server using the same SQL credentials...
Also gave access to the DB to the user that the Report Manager runs under...
But this still occurs.
"Nikolai Sonin" wrote:
> I too had this problem. The way that I fixed it was by making sure that I
> could connect to the SQL server in question from the server that hosted the
> reporting services website. It was the that I realized two very important
> things.
> 1. The user profile that reporting services uses to run as a service needs
> SQL server access.
> 2. The user profile that I entered as the login for the report needed to be
> qualified with a domain name if it was a windows account.
> These may not be your problem, but they were mine. I hope this helps
>
> "PV" wrote:
> > Hi,
> > I am working with SQL Reporting services 2000... The report is unable to
> > connect to a remote datasource as I try to preview it. The database uses both
> > SQL and Windows Auth.
> >
> > 1. Created a shared datasource in my project
> > 2. Deployed it on the server. Used OverwriteDataSource = false
> > 3. Create a new shared datasource on the server. Gave a connection string
> > with no username and password.
> > 4. Selected "Credentials stored securely in the report server" and then
> > entered the SQL server login and passoword there.
> > 5. Changed the report properties in the manager to use this datasource.
> > 6. While trying to "View" via report manager, I am getting the error message
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> > Get Online Help
> > SQL Server does not exist or access denied.
> >
> >
> > CAN SOMEONE PLEASE HELP ME!!!!!!|||I'm having a very similar problem, but I have two reports using the
datascource and rendering no problem and a third that gets the
rsErrorOpeningConnection error. This report previews just fine in VS, but
when not when deployed to the server. Anyone know if RS is does some sort of
credential caching?
"PV" wrote:
> I confirmed this... Found out that I could connect from the Reporting
> services machine to my SQL Server using the same SQL credentials...
> Also gave access to the DB to the user that the Report Manager runs under...
> But this still occurs.
>
> "Nikolai Sonin" wrote:
> > I too had this problem. The way that I fixed it was by making sure that I
> > could connect to the SQL server in question from the server that hosted the
> > reporting services website. It was the that I realized two very important
> > things.
> > 1. The user profile that reporting services uses to run as a service needs
> > SQL server access.
> > 2. The user profile that I entered as the login for the report needed to be
> > qualified with a domain name if it was a windows account.
> > These may not be your problem, but they were mine. I hope this helps
> >
> >
> > "PV" wrote:
> >
> > > Hi,
> > > I am working with SQL Reporting services 2000... The report is unable to
> > > connect to a remote datasource as I try to preview it. The database uses both
> > > SQL and Windows Auth.
> > >
> > > 1. Created a shared datasource in my project
> > > 2. Deployed it on the server. Used OverwriteDataSource = false
> > > 3. Create a new shared datasource on the server. Gave a connection string
> > > with no username and password.
> > > 4. Selected "Credentials stored securely in the report server" and then
> > > entered the SQL server login and passoword there.
> > > 5. Changed the report properties in the manager to use this datasource.
> > > 6. While trying to "View" via report manager, I am getting the error message
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> > > Get Online Help
> > > SQL Server does not exist or access denied.
> > >
> > >
> > > CAN SOMEONE PLEASE HELP ME!!!!!!|||There is no credential caching between data sources. Often this is some sort
of network name resolution issue.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leef" <Leef@.discussions.microsoft.com> wrote in message
news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@.microsoft.com...
> I'm having a very similar problem, but I have two reports using the
> datascource and rendering no problem and a third that gets the
> rsErrorOpeningConnection error. This report previews just fine in VS, but
> when not when deployed to the server. Anyone know if RS is does some sort
> of
> credential caching?
> "PV" wrote:
>> I confirmed this... Found out that I could connect from the Reporting
>> services machine to my SQL Server using the same SQL credentials...
>> Also gave access to the DB to the user that the Report Manager runs
>> under...
>> But this still occurs.
>>
>> "Nikolai Sonin" wrote:
>> > I too had this problem. The way that I fixed it was by making sure
>> > that I
>> > could connect to the SQL server in question from the server that hosted
>> > the
>> > reporting services website. It was the that I realized two very
>> > important
>> > things.
>> > 1. The user profile that reporting services uses to run as a service
>> > needs
>> > SQL server access.
>> > 2. The user profile that I entered as the login for the report needed
>> > to be
>> > qualified with a domain name if it was a windows account.
>> > These may not be your problem, but they were mine. I hope this helps
>> >
>> >
>> > "PV" wrote:
>> >
>> > > Hi,
>> > > I am working with SQL Reporting services 2000... The report is
>> > > unable to
>> > > connect to a remote datasource as I try to preview it. The database
>> > > uses both
>> > > SQL and Windows Auth.
>> > >
>> > > 1. Created a shared datasource in my project
>> > > 2. Deployed it on the server. Used OverwriteDataSource = false
>> > > 3. Create a new shared datasource on the server. Gave a connection
>> > > string
>> > > with no username and password.
>> > > 4. Selected "Credentials stored securely in the report server" and
>> > > then
>> > > entered the SQL server login and passoword there.
>> > > 5. Changed the report properties in the manager to use this
>> > > datasource.
>> > > 6. While trying to "View" via report manager, I am getting the error
>> > > message
>> > >
>> > > An error has occurred during report processing. (rsProcessingAborted)
>> > > Get
>> > > Online Help
>> > > Cannot create a connection to data source 'xxxx'.
>> > > (rsErrorOpeningConnection)
>> > > Get Online Help
>> > > SQL Server does not exist or access denied.
>> > >
>> > >
>> > > CAN SOMEONE PLEASE HELP ME!!!!!!|||Thanks! I finally figure it out.
It was a permissions problem, but was masked because I thought it was using
the shared datasource. Instead it was using a report specific datasource that
had the same name. The way I discovered this was by going and taking a look
at the XML code of the problem report.
"Brian Welcker [MSFT]" wrote:
> There is no credential caching between data sources. Often this is some sort
> of network name resolution issue.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Leef" <Leef@.discussions.microsoft.com> wrote in message
> news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@.microsoft.com...
> > I'm having a very similar problem, but I have two reports using the
> > datascource and rendering no problem and a third that gets the
> > rsErrorOpeningConnection error. This report previews just fine in VS, but
> > when not when deployed to the server. Anyone know if RS is does some sort
> > of
> > credential caching?
> >
> > "PV" wrote:
> >
> >> I confirmed this... Found out that I could connect from the Reporting
> >> services machine to my SQL Server using the same SQL credentials...
> >>
> >> Also gave access to the DB to the user that the Report Manager runs
> >> under...
> >>
> >> But this still occurs.
> >>
> >>
> >>
> >> "Nikolai Sonin" wrote:
> >>
> >> > I too had this problem. The way that I fixed it was by making sure
> >> > that I
> >> > could connect to the SQL server in question from the server that hosted
> >> > the
> >> > reporting services website. It was the that I realized two very
> >> > important
> >> > things.
> >> > 1. The user profile that reporting services uses to run as a service
> >> > needs
> >> > SQL server access.
> >> > 2. The user profile that I entered as the login for the report needed
> >> > to be
> >> > qualified with a domain name if it was a windows account.
> >> > These may not be your problem, but they were mine. I hope this helps
> >> >
> >> >
> >> > "PV" wrote:
> >> >
> >> > > Hi,
> >> > > I am working with SQL Reporting services 2000... The report is
> >> > > unable to
> >> > > connect to a remote datasource as I try to preview it. The database
> >> > > uses both
> >> > > SQL and Windows Auth.
> >> > >
> >> > > 1. Created a shared datasource in my project
> >> > > 2. Deployed it on the server. Used OverwriteDataSource = false
> >> > > 3. Create a new shared datasource on the server. Gave a connection
> >> > > string
> >> > > with no username and password.
> >> > > 4. Selected "Credentials stored securely in the report server" and
> >> > > then
> >> > > entered the SQL server login and passoword there.
> >> > > 5. Changed the report properties in the manager to use this
> >> > > datasource.
> >> > > 6. While trying to "View" via report manager, I am getting the error
> >> > > message
> >> > >
> >> > > An error has occurred during report processing. (rsProcessingAborted)
> >> > > Get
> >> > > Online Help
> >> > > Cannot create a connection to data source 'xxxx'.
> >> > > (rsErrorOpeningConnection)
> >> > > Get Online Help
> >> > > SQL Server does not exist or access denied.
> >> > >
> >> > >
> >> > > CAN SOMEONE PLEASE HELP ME!!!!!!
>
>
I am working with SQL Reporting services 2000... The report is unable to
connect to a remote datasource as I try to preview it. The database uses both
SQL and Windows Auth.
1. Created a shared datasource in my project
2. Deployed it on the server. Used OverwriteDataSource = false
3. Create a new shared datasource on the server. Gave a connection string
with no username and password.
4. Selected "Credentials stored securely in the report server" and then
entered the SQL server login and passoword there.
5. Changed the report properties in the manager to use this datasource.
6. While trying to "View" via report manager, I am getting the error message
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
Get Online Help
SQL Server does not exist or access denied.
CAN SOMEONE PLEASE HELP ME!!!!!!I too had this problem. The way that I fixed it was by making sure that I
could connect to the SQL server in question from the server that hosted the
reporting services website. It was the that I realized two very important
things.
1. The user profile that reporting services uses to run as a service needs
SQL server access.
2. The user profile that I entered as the login for the report needed to be
qualified with a domain name if it was a windows account.
These may not be your problem, but they were mine. I hope this helps
"PV" wrote:
> Hi,
> I am working with SQL Reporting services 2000... The report is unable to
> connect to a remote datasource as I try to preview it. The database uses both
> SQL and Windows Auth.
> 1. Created a shared datasource in my project
> 2. Deployed it on the server. Used OverwriteDataSource = false
> 3. Create a new shared datasource on the server. Gave a connection string
> with no username and password.
> 4. Selected "Credentials stored securely in the report server" and then
> entered the SQL server login and passoword there.
> 5. Changed the report properties in the manager to use this datasource.
> 6. While trying to "View" via report manager, I am getting the error message
> An error has occurred during report processing. (rsProcessingAborted) Get
> Online Help
> Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> Get Online Help
> SQL Server does not exist or access denied.
>
> CAN SOMEONE PLEASE HELP ME!!!!!!|||I confirmed this... Found out that I could connect from the Reporting
services machine to my SQL Server using the same SQL credentials...
Also gave access to the DB to the user that the Report Manager runs under...
But this still occurs.
"Nikolai Sonin" wrote:
> I too had this problem. The way that I fixed it was by making sure that I
> could connect to the SQL server in question from the server that hosted the
> reporting services website. It was the that I realized two very important
> things.
> 1. The user profile that reporting services uses to run as a service needs
> SQL server access.
> 2. The user profile that I entered as the login for the report needed to be
> qualified with a domain name if it was a windows account.
> These may not be your problem, but they were mine. I hope this helps
>
> "PV" wrote:
> > Hi,
> > I am working with SQL Reporting services 2000... The report is unable to
> > connect to a remote datasource as I try to preview it. The database uses both
> > SQL and Windows Auth.
> >
> > 1. Created a shared datasource in my project
> > 2. Deployed it on the server. Used OverwriteDataSource = false
> > 3. Create a new shared datasource on the server. Gave a connection string
> > with no username and password.
> > 4. Selected "Credentials stored securely in the report server" and then
> > entered the SQL server login and passoword there.
> > 5. Changed the report properties in the manager to use this datasource.
> > 6. While trying to "View" via report manager, I am getting the error message
> >
> > An error has occurred during report processing. (rsProcessingAborted) Get
> > Online Help
> > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> > Get Online Help
> > SQL Server does not exist or access denied.
> >
> >
> > CAN SOMEONE PLEASE HELP ME!!!!!!|||I'm having a very similar problem, but I have two reports using the
datascource and rendering no problem and a third that gets the
rsErrorOpeningConnection error. This report previews just fine in VS, but
when not when deployed to the server. Anyone know if RS is does some sort of
credential caching?
"PV" wrote:
> I confirmed this... Found out that I could connect from the Reporting
> services machine to my SQL Server using the same SQL credentials...
> Also gave access to the DB to the user that the Report Manager runs under...
> But this still occurs.
>
> "Nikolai Sonin" wrote:
> > I too had this problem. The way that I fixed it was by making sure that I
> > could connect to the SQL server in question from the server that hosted the
> > reporting services website. It was the that I realized two very important
> > things.
> > 1. The user profile that reporting services uses to run as a service needs
> > SQL server access.
> > 2. The user profile that I entered as the login for the report needed to be
> > qualified with a domain name if it was a windows account.
> > These may not be your problem, but they were mine. I hope this helps
> >
> >
> > "PV" wrote:
> >
> > > Hi,
> > > I am working with SQL Reporting services 2000... The report is unable to
> > > connect to a remote datasource as I try to preview it. The database uses both
> > > SQL and Windows Auth.
> > >
> > > 1. Created a shared datasource in my project
> > > 2. Deployed it on the server. Used OverwriteDataSource = false
> > > 3. Create a new shared datasource on the server. Gave a connection string
> > > with no username and password.
> > > 4. Selected "Credentials stored securely in the report server" and then
> > > entered the SQL server login and passoword there.
> > > 5. Changed the report properties in the manager to use this datasource.
> > > 6. While trying to "View" via report manager, I am getting the error message
> > >
> > > An error has occurred during report processing. (rsProcessingAborted) Get
> > > Online Help
> > > Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)
> > > Get Online Help
> > > SQL Server does not exist or access denied.
> > >
> > >
> > > CAN SOMEONE PLEASE HELP ME!!!!!!|||There is no credential caching between data sources. Often this is some sort
of network name resolution issue.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Leef" <Leef@.discussions.microsoft.com> wrote in message
news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@.microsoft.com...
> I'm having a very similar problem, but I have two reports using the
> datascource and rendering no problem and a third that gets the
> rsErrorOpeningConnection error. This report previews just fine in VS, but
> when not when deployed to the server. Anyone know if RS is does some sort
> of
> credential caching?
> "PV" wrote:
>> I confirmed this... Found out that I could connect from the Reporting
>> services machine to my SQL Server using the same SQL credentials...
>> Also gave access to the DB to the user that the Report Manager runs
>> under...
>> But this still occurs.
>>
>> "Nikolai Sonin" wrote:
>> > I too had this problem. The way that I fixed it was by making sure
>> > that I
>> > could connect to the SQL server in question from the server that hosted
>> > the
>> > reporting services website. It was the that I realized two very
>> > important
>> > things.
>> > 1. The user profile that reporting services uses to run as a service
>> > needs
>> > SQL server access.
>> > 2. The user profile that I entered as the login for the report needed
>> > to be
>> > qualified with a domain name if it was a windows account.
>> > These may not be your problem, but they were mine. I hope this helps
>> >
>> >
>> > "PV" wrote:
>> >
>> > > Hi,
>> > > I am working with SQL Reporting services 2000... The report is
>> > > unable to
>> > > connect to a remote datasource as I try to preview it. The database
>> > > uses both
>> > > SQL and Windows Auth.
>> > >
>> > > 1. Created a shared datasource in my project
>> > > 2. Deployed it on the server. Used OverwriteDataSource = false
>> > > 3. Create a new shared datasource on the server. Gave a connection
>> > > string
>> > > with no username and password.
>> > > 4. Selected "Credentials stored securely in the report server" and
>> > > then
>> > > entered the SQL server login and passoword there.
>> > > 5. Changed the report properties in the manager to use this
>> > > datasource.
>> > > 6. While trying to "View" via report manager, I am getting the error
>> > > message
>> > >
>> > > An error has occurred during report processing. (rsProcessingAborted)
>> > > Get
>> > > Online Help
>> > > Cannot create a connection to data source 'xxxx'.
>> > > (rsErrorOpeningConnection)
>> > > Get Online Help
>> > > SQL Server does not exist or access denied.
>> > >
>> > >
>> > > CAN SOMEONE PLEASE HELP ME!!!!!!|||Thanks! I finally figure it out.
It was a permissions problem, but was masked because I thought it was using
the shared datasource. Instead it was using a report specific datasource that
had the same name. The way I discovered this was by going and taking a look
at the XML code of the problem report.
"Brian Welcker [MSFT]" wrote:
> There is no credential caching between data sources. Often this is some sort
> of network name resolution issue.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Leef" <Leef@.discussions.microsoft.com> wrote in message
> news:D69B9ED5-00A6-4ECF-9501-C269709E90B8@.microsoft.com...
> > I'm having a very similar problem, but I have two reports using the
> > datascource and rendering no problem and a third that gets the
> > rsErrorOpeningConnection error. This report previews just fine in VS, but
> > when not when deployed to the server. Anyone know if RS is does some sort
> > of
> > credential caching?
> >
> > "PV" wrote:
> >
> >> I confirmed this... Found out that I could connect from the Reporting
> >> services machine to my SQL Server using the same SQL credentials...
> >>
> >> Also gave access to the DB to the user that the Report Manager runs
> >> under...
> >>
> >> But this still occurs.
> >>
> >>
> >>
> >> "Nikolai Sonin" wrote:
> >>
> >> > I too had this problem. The way that I fixed it was by making sure
> >> > that I
> >> > could connect to the SQL server in question from the server that hosted
> >> > the
> >> > reporting services website. It was the that I realized two very
> >> > important
> >> > things.
> >> > 1. The user profile that reporting services uses to run as a service
> >> > needs
> >> > SQL server access.
> >> > 2. The user profile that I entered as the login for the report needed
> >> > to be
> >> > qualified with a domain name if it was a windows account.
> >> > These may not be your problem, but they were mine. I hope this helps
> >> >
> >> >
> >> > "PV" wrote:
> >> >
> >> > > Hi,
> >> > > I am working with SQL Reporting services 2000... The report is
> >> > > unable to
> >> > > connect to a remote datasource as I try to preview it. The database
> >> > > uses both
> >> > > SQL and Windows Auth.
> >> > >
> >> > > 1. Created a shared datasource in my project
> >> > > 2. Deployed it on the server. Used OverwriteDataSource = false
> >> > > 3. Create a new shared datasource on the server. Gave a connection
> >> > > string
> >> > > with no username and password.
> >> > > 4. Selected "Credentials stored securely in the report server" and
> >> > > then
> >> > > entered the SQL server login and passoword there.
> >> > > 5. Changed the report properties in the manager to use this
> >> > > datasource.
> >> > > 6. While trying to "View" via report manager, I am getting the error
> >> > > message
> >> > >
> >> > > An error has occurred during report processing. (rsProcessingAborted)
> >> > > Get
> >> > > Online Help
> >> > > Cannot create a connection to data source 'xxxx'.
> >> > > (rsErrorOpeningConnection)
> >> > > Get Online Help
> >> > > SQL Server does not exist or access denied.
> >> > >
> >> > >
> >> > > CAN SOMEONE PLEASE HELP ME!!!!!!
>
>
Subscribe to:
Posts (Atom)