Wednesday, March 21, 2012

problem opening data connection

Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
someone else created. I'm not very familiar with either RS or VS. When I go
into VS and load the solution (someone told me how to find the correct one)
and then in the solution explorer, I double click on the report that I want
to change. Then I click on the "Data" tab and I get this error:
"A connection cannot be made to the database. Set and test the connection
string. SQL Server does not exist or access denied." I double clicked on the
rds file under "Shared Data Sources" and looked on the General tab. This is
the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
think the contractor developed on his local machine and then deployed to the
development server. I don't have RS on my machine. Will it hurt anything if
I change the connection string to point to the development server?
Thanks,
--
Dan D.No problem check all the parameters and most importantly select the server
and database and user / password. it should work..
Amarnath
"Dan D." wrote:
> Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> someone else created. I'm not very familiar with either RS or VS. When I go
> into VS and load the solution (someone told me how to find the correct one)
> and then in the solution explorer, I double click on the report that I want
> to change. Then I click on the "Data" tab and I get this error:
> "A connection cannot be made to the database. Set and test the connection
> string. SQL Server does not exist or access denied." I double clicked on the
> rds file under "Shared Data Sources" and looked on the General tab. This is
> the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> think the contractor developed on his local machine and then deployed to the
> development server. I don't have RS on my machine. Will it hurt anything if
> I change the connection string to point to the development server?
> Thanks,
>
> --
> Dan D.|||Thanks.
If I create a new data source and a new report in the same solution, how do
I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
files and upload them to the reports folder? Or is the rds file incorporated
in the rdl file and I just have to upload the rdl file?
Thanks,
--
Dan D.
"Amarnath" wrote:
> No problem check all the parameters and most importantly select the server
> and database and user / password. it should work..
> Amarnath
>
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > someone else created. I'm not very familiar with either RS or VS. When I go
> > into VS and load the solution (someone told me how to find the correct one)
> > and then in the solution explorer, I double click on the report that I want
> > to change. Then I click on the "Data" tab and I get this error:
> > "A connection cannot be made to the database. Set and test the connection
> > string. SQL Server does not exist or access denied." I double clicked on the
> > rds file under "Shared Data Sources" and looked on the General tab. This is
> > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > think the contractor developed on his local machine and then deployed to the
> > development server. I don't have RS on my machine. Will it hurt anything if
> > I change the connection string to point to the development server?
> >
> > Thanks,
> >
> >
> > --
> > Dan D.|||If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
hasn't been deployed before. The default is not to allow deployed rds to be
overwritten.
You can also deploy both the rds and rdl by uploading from the Report Manager.
HTH,
magendo_man
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||If you have VS 2003 that's well and good since it does everything for you,
when you just click "deploy". When you deploy all the details are stored in
tables in an encrypted form so just copying is not the solution.. Other way
is through scripts. using RS.exe
Let me know if you require it or just go to sample.RSS at
\Samples\Reporting Services\Script Samples and select publishsample report.
Just see how to publish a report and you can change accordingly.
Amarnath
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||Thanks.
--
Dan D.
"magendo_man" wrote:
> If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
> hasn't been deployed before. The default is not to allow deployed rds to be
> overwritten.
> You can also deploy both the rds and rdl by uploading from the Report Manager.
> HTH,
> magendo_man
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.|||I was able to make a change to the report and deploy it using the browser. I
didn't need to make a change to the rds file so I didn't need to redeploy it.
Thanks,
--
Dan D.
"Amarnath" wrote:
> If you have VS 2003 that's well and good since it does everything for you,
> when you just click "deploy". When you deploy all the details are stored in
> tables in an encrypted form so just copying is not the solution.. Other way
> is through scripts. using RS.exe
> Let me know if you require it or just go to sample.RSS at
> \Samples\Reporting Services\Script Samples and select publishsample report.
> Just see how to publish a report and you can change accordingly.
> Amarnath
>
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.sql

No comments:

Post a Comment