Hi,
I have some (OLD) college notes that say if I type
Describe tablename;
Name NOT NULL? Type
in my SQL code window in access once run it will give me the structure of the table.
When I try to run I get a Invalid SQL statement error 'DELETE', 'INSERT'...
Where am I going wrong.
Thanksoh, it's simple, your old notes are wrong, access doesn't support that commandsql
Showing posts with label run. Show all posts
Showing posts with label run. Show all posts
Thursday, March 29, 2012
Desc as column name
Hi,
When I run the following sql statement
CREATE TABLE t1 (Desc varchar(50))
I get an error saying Incorrect syntax near keyword Desc.
However, I can run the same command on other database engines.
Where can I find situations like this where an sql statement will work
on other databases but not SqlServer?
The statement
CREATE TABLE t1 ([Desc] varchar(50))
works fine.
Do you suggest that I enclose column names in square brackets ([]) for
all sql statements (select, insert, update, create, delete etc)?
Regards,
PrakashSince you mention other database engines, you should get into the habit of using the ANSI SQL
compliant way to delimit identifiers: double-quotes and not square brackets.
There's a list in Books Online of all the reserved keywords.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<prakash_bande@.hotmail.com> wrote in message
news:1189098048.395246.253570@.w3g2000hsg.googlegroups.com...
> Hi,
> When I run the following sql statement
> CREATE TABLE t1 (Desc varchar(50))
> I get an error saying Incorrect syntax near keyword Desc.
> However, I can run the same command on other database engines.
> Where can I find situations like this where an sql statement will work
> on other databases but not SqlServer?
> The statement
> CREATE TABLE t1 ([Desc] varchar(50))
> works fine.
> Do you suggest that I enclose column names in square brackets ([]) for
> all sql statements (select, insert, update, create, delete etc)?
>
> Regards,
> Prakash
>|||Desc is a reserved keyword in SQL Server. It's short for 'descending' and is
used in syntax such as ORDER BY column_name DESC. If you want to use
reserved words as object or column names, you must delimit the name by
either using [ ] as you show below are by using double quotes " ". Keep in
mind that you will need to delimit this name in every statement in which you
reference the name. You might consider just choosing a longer (and more
descriptive) name such as "Description".
For a list of reserved keywords, see this Books Online topic:
http://msdn2.microsoft.com/en-us/library/ms189822.aspx
For more information about delimiting names see this Books Online topic
http://msdn2.microsoft.com/en-us/library/ms176027.aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
<prakash_bande@.hotmail.com> wrote in message
news:1189098048.395246.253570@.w3g2000hsg.googlegroups.com...
> Hi,
> When I run the following sql statement
> CREATE TABLE t1 (Desc varchar(50))
> I get an error saying Incorrect syntax near keyword Desc.
> However, I can run the same command on other database engines.
> Where can I find situations like this where an sql statement will work
> on other databases but not SqlServer?
> The statement
> CREATE TABLE t1 ([Desc] varchar(50))
> works fine.
> Do you suggest that I enclose column names in square brackets ([]) for
> all sql statements (select, insert, update, create, delete etc)?
>
> Regards,
> Prakash
>sql
When I run the following sql statement
CREATE TABLE t1 (Desc varchar(50))
I get an error saying Incorrect syntax near keyword Desc.
However, I can run the same command on other database engines.
Where can I find situations like this where an sql statement will work
on other databases but not SqlServer?
The statement
CREATE TABLE t1 ([Desc] varchar(50))
works fine.
Do you suggest that I enclose column names in square brackets ([]) for
all sql statements (select, insert, update, create, delete etc)?
Regards,
PrakashSince you mention other database engines, you should get into the habit of using the ANSI SQL
compliant way to delimit identifiers: double-quotes and not square brackets.
There's a list in Books Online of all the reserved keywords.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<prakash_bande@.hotmail.com> wrote in message
news:1189098048.395246.253570@.w3g2000hsg.googlegroups.com...
> Hi,
> When I run the following sql statement
> CREATE TABLE t1 (Desc varchar(50))
> I get an error saying Incorrect syntax near keyword Desc.
> However, I can run the same command on other database engines.
> Where can I find situations like this where an sql statement will work
> on other databases but not SqlServer?
> The statement
> CREATE TABLE t1 ([Desc] varchar(50))
> works fine.
> Do you suggest that I enclose column names in square brackets ([]) for
> all sql statements (select, insert, update, create, delete etc)?
>
> Regards,
> Prakash
>|||Desc is a reserved keyword in SQL Server. It's short for 'descending' and is
used in syntax such as ORDER BY column_name DESC. If you want to use
reserved words as object or column names, you must delimit the name by
either using [ ] as you show below are by using double quotes " ". Keep in
mind that you will need to delimit this name in every statement in which you
reference the name. You might consider just choosing a longer (and more
descriptive) name such as "Description".
For a list of reserved keywords, see this Books Online topic:
http://msdn2.microsoft.com/en-us/library/ms189822.aspx
For more information about delimiting names see this Books Online topic
http://msdn2.microsoft.com/en-us/library/ms176027.aspx
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
<prakash_bande@.hotmail.com> wrote in message
news:1189098048.395246.253570@.w3g2000hsg.googlegroups.com...
> Hi,
> When I run the following sql statement
> CREATE TABLE t1 (Desc varchar(50))
> I get an error saying Incorrect syntax near keyword Desc.
> However, I can run the same command on other database engines.
> Where can I find situations like this where an sql statement will work
> on other databases but not SqlServer?
> The statement
> CREATE TABLE t1 ([Desc] varchar(50))
> works fine.
> Do you suggest that I enclose column names in square brackets ([]) for
> all sql statements (select, insert, update, create, delete etc)?
>
> Regards,
> Prakash
>sql
Thursday, March 22, 2012
Deployment Utility error
I am getting the following error when trying to run a deployment utility. The server only has .net framework 2.0 and sql server 2005 (rtm) installed.
If it's any help, this server was recently upgraded from the june ctp to rtm.
This is a production server, so a solution involving as little disturbance to it's current state would be preferrable.
Thanks in advance for any suggestions.
-Jeremy
TITLE: Package Installation Wizard
Unexpected error occurred.
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
BUTTONS:
OK
If it's any help, this server was recently upgraded from the june ctp to rtm.
This is a production server, so a solution involving as little disturbance to it's current state would be preferrable.
Thanks in advance for any suggestions.
-Jeremy
TITLE: Package Installation Wizard
Unexpected error occurred.
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
BUTTONS:
OK
Looks like the SSIS is not corectly installed on the machine. Can you uninstall SQL Server and reinstall it?
HTH,
Ovidiu
We're having the exact same issue with a WinForm app deployed via ClickOnce.
What's the deal here?
Deployment Utility error
I am getting the following error when trying to run a deployment utility. The server only has .net framework 2.0 and sql server 2005 (rtm) installed.
If it's any help, this server was recently upgraded from the june ctp to rtm.
This is a production server, so a solution involving as little disturbance to it's current state would be preferrable.
Thanks in advance for any suggestions.
-Jeremy
TITLE: Package Installation Wizard
Unexpected error occurred.
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
BUTTONS:
OK
If it's any help, this server was recently upgraded from the june ctp to rtm.
This is a production server, so a solution involving as little disturbance to it's current state would be preferrable.
Thanks in advance for any suggestions.
-Jeremy
TITLE: Package Installation Wizard
Unexpected error occurred.
ADDITIONAL INFORMATION:
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
Retrieving the COM class factory for component with CLSID {E44847F1-FD8C-4251-B5DA-B04BB22E236E} failed due to the following error: 80040154. (Microsoft.SqlServer.ManagedDTS)
BUTTONS:
OK
Looks like the SSIS is not corectly installed on the machine. Can you uninstall SQL Server and reinstall it?
HTH,
Ovidiu
We're having the exact same issue with a WinForm app deployed via ClickOnce.
What's the deal here?
Deployment Server Properties
I am just starting into using the SQL 2005 tools and was trying to run my first model. I set up the Data sources and Data Source Views and Created a decision tree mining structure.
The properties for the deployment have the server as (local) and the database name that is valid. I am running SQLServer Express on my local PC and have verified that it is up and running.
When I try and do a Build and deploy, I get the following error:
"The project could not be deployed to the '(local)' server because of the following connection problems: A connection cannot be made. Enssure the server is running...."
Any idea what I'm doing wrong? I can deploy if I change the deployment to look at the server the data is on (a remote SQL 2005 server), but I would rather have it on my local machine. Maybe that is not a good idea. If not, please tell me.
Thanks in advance.
-Frank
Your mining model and associated objects need to be deployed to an Analysis Services 2005 instance, not to the relational database server. Since SQL Server 2005 Express does not include Analysis Services, you'll need to deploy to another server that's running Standard Edition or above and has a running instance of Analysis Services.|||Ahh, that makes sense. Thanks.
-Frank
Wednesday, March 21, 2012
Deployment Error
After creating a my project which has several dts packages.
I want to deploy and place them in different sql servers to run automatically.
I do the following:
After building my project.I select project ->properties ->deployment utility->i set create deployment to true.
Then within deployment folder i double click .projectdeploymentmanifest file
where package installation i select sql server instead of file system.
and i get the following error.
TITLE: Package Installation Wizard
Could not save the package "C:\Program Files\Microsoft SQL Server\SSIS\bin\Deployment\Procedure.dtsx" to SQL Server "SQL-DEV".
ADDITIONAL INFORMATION:
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.
BUTTONS:
OK
It would be great if some one guides me with this.Is this anything to deal with security.please let me know
Open up Management Studio and try to connect to "Integration Services" on SQL-DEV.|||It says Access Denied.
Do i need to be under sysadmin role to do this?
Please let me know.
Thanks
|||
See this link from my blog:
http://www.ssistalk.com/2007/04/13/ssis-access-is-denied-when-connection-to-remote-ssis-service/
|||
I have worked with the steps from this site.I still have the same problem.
Access denied when i connect to integration services on a particular server from i local machine.
Do i have any other options?
|||The answers are all right there, but need to be done on the server, not the local machine.|||
Thanks,I was working on my local machine instead of server.
Deployment + XML Config file problem
Hello
I am using XML config file to store the values e.g. Server name.... it runs fine with BIDS (Development enviroment)... but when I deploy and run it to test that XML config files values are being read by e.g. giving the wrong server name, it runs fine (may be retrieving some old values). then I come bak and test it again in the development enviroment to test, it fails ( as it supposed to be caz server name is wrong in config file)
can ne one tell me wr is the problem?
ur help and support is appreciated
regards,
Anas
Sorry to bother you but that was the problem with my config file...
it is so pathetic that package running does not show ne error or warning that's y wasted a lot of time.... fortunately i was able to solve the problem b4 I go on my holidays... i big sigh of reliefs...
regards,
Anas
Monday, March 19, 2012
Deploying sub-reports
I have many reports that are compiled as embedded resources in my ClickOnce
application. All of the reports work on my dev computer when run from Visual
Studio or when installed via ClickOnce on my dev computer.
On client computers, the reports with sub-reports fail. The following error
message is shown where the sub-report should be:
"Error: Subreport could not be shown"
Since the reports work on my dev computer, the problem seems to be a
difference between the Visual Studio report viewer and the redistributable
report viewer.
Has anyone else seen this problem? Can you give me any advice?I had a problem like this before and found it to be a problem with the
regional settings on the client running the report.
"John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
>I have many reports that are compiled as embedded resources in my ClickOnce
> application. All of the reports work on my dev computer when run from
> Visual
> Studio or when installed via ClickOnce on my dev computer.
> On client computers, the reports with sub-reports fail. The following
> error
> message is shown where the sub-report should be:
> "Error: Subreport could not be shown"
> Since the reports work on my dev computer, the problem seems to be a
> difference between the Visual Studio report viewer and the redistributable
> report viewer.
> Has anyone else seen this problem? Can you give me any advice?|||Immy, thanks for the reply. Regional settings do not seem to be the problem
in my case -- my dev computer and the clients are all using "English
(Canada)".
I may try to deploy the .rdlc files directly instead of embedding them in a
report dll.
"Immy" wrote:
> I had a problem like this before and found it to be a problem with the
> regional settings on the client running the report.
> "John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
> news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
> >I have many reports that are compiled as embedded resources in my ClickOnce
> > application. All of the reports work on my dev computer when run from
> > Visual
> > Studio or when installed via ClickOnce on my dev computer.
> >
> > On client computers, the reports with sub-reports fail. The following
> > error
> > message is shown where the sub-report should be:
> >
> > "Error: Subreport could not be shown"
> >
> > Since the reports work on my dev computer, the problem seems to be a
> > difference between the Visual Studio report viewer and the redistributable
> > report viewer.
> >
> > Has anyone else seen this problem? Can you give me any advice?
>
>
application. All of the reports work on my dev computer when run from Visual
Studio or when installed via ClickOnce on my dev computer.
On client computers, the reports with sub-reports fail. The following error
message is shown where the sub-report should be:
"Error: Subreport could not be shown"
Since the reports work on my dev computer, the problem seems to be a
difference between the Visual Studio report viewer and the redistributable
report viewer.
Has anyone else seen this problem? Can you give me any advice?I had a problem like this before and found it to be a problem with the
regional settings on the client running the report.
"John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
>I have many reports that are compiled as embedded resources in my ClickOnce
> application. All of the reports work on my dev computer when run from
> Visual
> Studio or when installed via ClickOnce on my dev computer.
> On client computers, the reports with sub-reports fail. The following
> error
> message is shown where the sub-report should be:
> "Error: Subreport could not be shown"
> Since the reports work on my dev computer, the problem seems to be a
> difference between the Visual Studio report viewer and the redistributable
> report viewer.
> Has anyone else seen this problem? Can you give me any advice?|||Immy, thanks for the reply. Regional settings do not seem to be the problem
in my case -- my dev computer and the clients are all using "English
(Canada)".
I may try to deploy the .rdlc files directly instead of embedding them in a
report dll.
"Immy" wrote:
> I had a problem like this before and found it to be a problem with the
> regional settings on the client running the report.
> "John Van Vliet" <JohnVanVliet@.discussions.microsoft.com> wrote in message
> news:D023E225-A809-4491-9C79-F7024DA0E905@.microsoft.com...
> >I have many reports that are compiled as embedded resources in my ClickOnce
> > application. All of the reports work on my dev computer when run from
> > Visual
> > Studio or when installed via ClickOnce on my dev computer.
> >
> > On client computers, the reports with sub-reports fail. The following
> > error
> > message is shown where the sub-report should be:
> >
> > "Error: Subreport could not be shown"
> >
> > Since the reports work on my dev computer, the problem seems to be a
> > difference between the Visual Studio report viewer and the redistributable
> > report viewer.
> >
> > Has anyone else seen this problem? Can you give me any advice?
>
>
Sunday, March 11, 2012
Deploying reports
Dear Experts,
Is there an executable file which we could run and deploy reports?
This tool would ask which reports to deploy, where, using which datasources,
etc and it would deploy them.
Manually deploying reports through visual studio is inconvient for us and we
want anybody to do it. If there is no tool that is part of SQL 2005, can you
give us VB script, or open source code that does this?
Thanks,
Bojan NikicOn Sep 21, 4:24 pm, bojannikic <bojanni...@.discussions.microsoft.com>
wrote:
> Dear Experts,
> Is there an executable file which we could run and deploy reports?
> This tool would ask which reports to deploy, where, using which datasources,
> etc and it would deploy them.
> Manually deploying reports through visual studio is inconvient for us and we
> want anybody to do it. If there is no tool that is part of SQL 2005, can you
> give us VB script, or open source code that does this?
> Thanks,
> Bojan Nikic
The rs.exe utility should accomplish what you are looking for. This
link might be helpful.
http://weblogs.sqlteam.com/tarad/archive/2005/01/05/3944.aspx
Regards,
Enrique Martinez
Sr. Software Consultant
Is there an executable file which we could run and deploy reports?
This tool would ask which reports to deploy, where, using which datasources,
etc and it would deploy them.
Manually deploying reports through visual studio is inconvient for us and we
want anybody to do it. If there is no tool that is part of SQL 2005, can you
give us VB script, or open source code that does this?
Thanks,
Bojan NikicOn Sep 21, 4:24 pm, bojannikic <bojanni...@.discussions.microsoft.com>
wrote:
> Dear Experts,
> Is there an executable file which we could run and deploy reports?
> This tool would ask which reports to deploy, where, using which datasources,
> etc and it would deploy them.
> Manually deploying reports through visual studio is inconvient for us and we
> want anybody to do it. If there is no tool that is part of SQL 2005, can you
> give us VB script, or open source code that does this?
> Thanks,
> Bojan Nikic
The rs.exe utility should accomplish what you are looking for. This
link might be helpful.
http://weblogs.sqlteam.com/tarad/archive/2005/01/05/3944.aspx
Regards,
Enrique Martinez
Sr. Software Consultant
Saturday, February 25, 2012
Deployed reports have javascript errors?
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.Solution!
The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.
There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.
This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||
What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?
This is on a clean install of SQL 2k5 on Server 2k3 SP1.
Thanks.
|||On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"
Thanks again;)
|||Anyone found a solution for this ?|||If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.
After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".
<location path="Reserved.ReportViewerWebControl.axd">
<system.web>
<authorization>
<allow roles="RoleA, RoleB">
</allow>
</authorization>
</system.web>
</location>
Deployed reports have javascript errors?
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.
Solution!
The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.
There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.
This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||
What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?
This is on a clean install of SQL 2k5 on Server 2k3 SP1.
Thanks.
|||On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"
Thanks again;)
|||Anyone found a solution for this ?|||If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.
After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".
<location path="Reserved.ReportViewerWebControl.axd">
<system.web>
<authorization>
<allow roles="RoleA, RoleB">
</allow>
</authorization>
</system.web>
</location>
Deployed reports have javascript errors?
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.
Solution!
The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.
There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.
This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||
What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?
This is on a clean install of SQL 2k5 on Server 2k3 SP1.
Thanks.
|||On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"
Thanks again;)
|||Anyone found a solution for this ?|||If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.
After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".
<location path="Reserved.ReportViewerWebControl.axd">
<system.web>
<authorization>
<allow roles="RoleA, RoleB">
</allow>
</authorization>
</system.web>
</location>
Deployed reports have javascript errors?
Hello-
I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.
Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'
I get these errors also when invoking these reports through a form post.
It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.
Thanks.Solution!
The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.
There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.
This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||
What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?
This is on a clean install of SQL 2k5 on Server 2k3 SP1.
Thanks.
|||On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"
Thanks again;)
|||Anyone found a solution for this ?|||If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.
After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".
<location path="Reserved.ReportViewerWebControl.axd">
<system.web>
<authorization>
<allow roles="RoleA, RoleB">
</allow>
</authorization>
</system.web>
</location>
deployed report, reverting to old report
I have since modified a deployed report by putting a pie chart on it. I run
the report on my develpoment PC and it shows fine, i deploy the new reoprt
and it is not showing the updated information. I have tried deleting the the
old report and uploading the new report, but still i get the old report
format.
I have uploaded the report to another directory and it shows the updated
report. I have tried moving the report from this directory to the directory i
want it in but still it does not show the updated format.Close(exit) IE and open up a new one.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> I have since modified a deployed report by putting a pie chart on it. I
run
> the report on my develpoment PC and it shows fine, i deploy the new reoprt
> and it is not showing the updated information. I have tried deleting the
the
> old report and uploading the new report, but still i get the old report
> format.
> I have uploaded the report to another directory and it shows the updated
> report. I have tried moving the report from this directory to the
directory i
> want it in but still it does not show the updated format.|||If using URL access you can also append the following to the URL to force RS
to render the report with session:
&rs:ClearSession=true
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OL%23OUwy9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
>> I have since modified a deployed report by putting a pie chart on it. I
> run
>> the report on my develpoment PC and it shows fine, i deploy the new
>> reoprt
>> and it is not showing the updated information. I have tried deleting the
> the
>> old report and uploading the new report, but still i get the old report
>> format.
>> I have uploaded the report to another directory and it shows the updated
>> report. I have tried moving the report from this directory to the
> directory i
>> want it in but still it does not show the updated format.
>|||thanks that worked.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>|||I get the same issue when trying to deploy from VStudio...Sometimes I have to
delete the reports and deploy 4 or 5 times before the change appears
Regards,
Dean Nero
Momentum Healthware Inc.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>
the report on my develpoment PC and it shows fine, i deploy the new reoprt
and it is not showing the updated information. I have tried deleting the the
old report and uploading the new report, but still i get the old report
format.
I have uploaded the report to another directory and it shows the updated
report. I have tried moving the report from this directory to the directory i
want it in but still it does not show the updated format.Close(exit) IE and open up a new one.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> I have since modified a deployed report by putting a pie chart on it. I
run
> the report on my develpoment PC and it shows fine, i deploy the new reoprt
> and it is not showing the updated information. I have tried deleting the
the
> old report and uploading the new report, but still i get the old report
> format.
> I have uploaded the report to another directory and it shows the updated
> report. I have tried moving the report from this directory to the
directory i
> want it in but still it does not show the updated format.|||If using URL access you can also append the following to the URL to force RS
to render the report with session:
&rs:ClearSession=true
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OL%23OUwy9EHA.3756@.TK2MSFTNGP14.phx.gbl...
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
>> I have since modified a deployed report by putting a pie chart on it. I
> run
>> the report on my develpoment PC and it shows fine, i deploy the new
>> reoprt
>> and it is not showing the updated information. I have tried deleting the
> the
>> old report and uploading the new report, but still i get the old report
>> format.
>> I have uploaded the report to another directory and it shows the updated
>> report. I have tried moving the report from this directory to the
> directory i
>> want it in but still it does not show the updated format.
>|||thanks that worked.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>|||I get the same issue when trying to deploy from VStudio...Sometimes I have to
delete the reports and deploy 4 or 5 times before the change appears
Regards,
Dean Nero
Momentum Healthware Inc.
"Bruce L-C [MVP]" wrote:
> Close(exit) IE and open up a new one.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Shaun Longhurst" <ShaunLonghurst@.discussions.microsoft.com> wrote in
> message news:8D96956A-A190-4985-8883-87BEE0D7E603@.microsoft.com...
> > I have since modified a deployed report by putting a pie chart on it. I
> run
> > the report on my develpoment PC and it shows fine, i deploy the new reoprt
> > and it is not showing the updated information. I have tried deleting the
> the
> > old report and uploading the new report, but still i get the old report
> > format.
> >
> > I have uploaded the report to another directory and it shows the updated
> > report. I have tried moving the report from this directory to the
> directory i
> > want it in but still it does not show the updated format.
>
>
Deployed Report
Hello,
When I run Build=> Deploy , where does the report go, I check Virtual Directory of ReportServer which is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer in my case and I do not see any file related to my report.
Thanks,
It depends on the Target URL specified under project in VS.NetDeployed custom assembly doesn't call web service
Hi,
I've got a custom assembly used in Rptsvcs that calls a web service on the
local host. When run in Report Designer, it works as planned, but when run
in Report Server, it doesn't call the web service. I have a
HelloWorld-method in the custom assembly that works, so the assembly is
working but it can't call the web service.
I have modified RSReportServer.config as follows:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1">
<ConnectAccess>
<URI uri="$OriginHost$"/>
</ConnectAccess>
</IPermission>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
And the policy file rssrvpolicy.config is also modified:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="cmcs.wsclient"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program Files/Microsoft SQL
Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
</CodeGroup>
Any tips?
JonasI forgot to mention that I make an assert in code before the call to the web
service:
WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
webPerm.Assert();
TIA
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've got a custom assembly used in Rptsvcs that calls a web service on the
> local host. When run in Report Designer, it works as planned, but when run
> in Report Server, it doesn't call the web service. I have a
> HelloWorld-method in the custom assembly that works, so the assembly is
> working but it can't call the web service.
> I have modified RSReportServer.config as follows:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1">
> <ConnectAccess>
> <URI uri="$OriginHost$"/>
> </ConnectAccess>
> </IPermission>
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
>
> And the policy file rssrvpolicy.config is also modified:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
> Name="cmcs.wsclient"
> Description="Codegroup generated by the .NET Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program Files/Microsoft SQL
> Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> </CodeGroup>
> Any tips?
> Jonas
>
>|||After some more investigation, I found out that it is the following
statement
ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
I need this to get the web services to use the callers identity. The
exception thrown is:
Request for the permission of type
System.Security.Permissions.EnvironmentPermission
As before, it works in Report Designer so the code is alright, it is the
security configuration that fails somewhere.
/Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> I forgot to mention that I make an assert in code before the call to the
web
> service:
> WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> webPerm.Assert();
> TIA
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've got a custom assembly used in Rptsvcs that calls a web service on
the
> > local host. When run in Report Designer, it works as planned, but when
run
> > in Report Server, it doesn't call the web service. I have a
> > HelloWorld-method in the custom assembly that works, so the assembly is
> > working but it can't call the web service.
> >
> > I have modified RSReportServer.config as follows:
> >
> > <CustomAssemblies>
> > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> > PublicKeyToken=xxx">
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution, Assertion"
> > />
> > <IPermission class="System.Security.Permissions.WebPermission"
> > version="1">
> > <ConnectAccess>
> > <URI uri="$OriginHost$"/>
> > </ConnectAccess>
> > </IPermission>
> > </PermissionSet>
> > </Assembly>
> >
> > <Default>
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution"
> > />
> > </PermissionSet>
> > </Default>
> > </CustomAssemblies>
> >
> >
> > And the policy file rssrvpolicy.config is also modified:
> >
> > <CodeGroup class="UnionCodeGroup"
> > version="1"
> > PermissionSetName="FullTrust"
> > Attributes="LevelFinal"
> > Name="cmcs.wsclient"
> > Description="Codegroup generated by the .NET Configuration
tool">
> > <IMembershipCondition class="UrlMembershipCondition"
> > version="1"
> > Url="file://C:/Program Files/Microsoft SQL
> > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > </CodeGroup>
> >
> > Any tips?
> >
> > Jonas
> >
> >
> >
>|||I've finally gotten the report to run in Report Server, but it took a while
and a nasty config to do it. It seems that the only way to get this to work
is to change the PermissionSet for Report_Expressions_Default_Permissions in
rssrvpolicy.config to FullTrust. I've tried to create a custom PermissionSet
with CASPOL where I ended up adding all permissions and setting them to
Unrestricted="true" thinking that I could then remove one at a time to
finally get a lower priviliege permission set, but the only thing that works
is FullTrust.
Is there someone else that have experienced the same thing?
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
> After some more investigation, I found out that it is the following
> statement
> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
> I need this to get the web services to use the callers identity. The
> exception thrown is:
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission
> As before, it works in Report Designer so the code is alright, it is the
> security configuration that fails somewhere.
> /Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> > I forgot to mention that I make an assert in code before the call to the
> web
> > service:
> >
> > WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> > webPerm.Assert();
> > TIA
> >
> > Jonas
> >
> > "Jonas" <Jonas@.nospam.pl> wrote in message
> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've got a custom assembly used in Rptsvcs that calls a web service on
> the
> > > local host. When run in Report Designer, it works as planned, but when
> run
> > > in Report Server, it doesn't call the web service. I have a
> > > HelloWorld-method in the custom assembly that works, so the assembly
is
> > > working but it can't call the web service.
> > >
> > > I have modified RSReportServer.config as follows:
> > >
> > > <CustomAssemblies>
> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
Culture=neutral,
> > > PublicKeyToken=xxx">
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution, Assertion"
> > > />
> > > <IPermission
class="System.Security.Permissions.WebPermission"
> > > version="1">
> > > <ConnectAccess>
> > > <URI uri="$OriginHost$"/>
> > > </ConnectAccess>
> > > </IPermission>
> > > </PermissionSet>
> > > </Assembly>
> > >
> > > <Default>
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution"
> > > />
> > > </PermissionSet>
> > > </Default>
> > > </CustomAssemblies>
> > >
> > >
> > > And the policy file rssrvpolicy.config is also modified:
> > >
> > > <CodeGroup class="UnionCodeGroup"
> > > version="1"
> > > PermissionSetName="FullTrust"
> > > Attributes="LevelFinal"
> > > Name="cmcs.wsclient"
> > > Description="Codegroup generated by the .NET Configuration
> tool">
> > > <IMembershipCondition class="UrlMembershipCondition"
> > > version="1"
> > > Url="file://C:/Program Files/Microsoft SQL
> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > > </CodeGroup>
> > >
> > > Any tips?
> > >
> > > Jonas
> > >
> > >
> > >
> >
> >
>|||Yes, I also had a heck of a time with this. We are calling a web service to
translate English to Spanish.
I ended up going the FullTrust route myself, still haven't tested on a clean
machine all the install and config steps I took.
Steve
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ejM$u7RIGHA.376@.TK2MSFTNGP12.phx.gbl...
> I've finally gotten the report to run in Report Server, but it took a
> while
> and a nasty config to do it. It seems that the only way to get this to
> work
> is to change the PermissionSet for Report_Expressions_Default_Permissions
> in
> rssrvpolicy.config to FullTrust. I've tried to create a custom
> PermissionSet
> with CASPOL where I ended up adding all permissions and setting them to
> Unrestricted="true" thinking that I could then remove one at a time to
> finally get a lower priviliege permission set, but the only thing that
> works
> is FullTrust.
> Is there someone else that have experienced the same thing?
> Brgds
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
>> After some more investigation, I found out that it is the following
>> statement
>> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
>> I need this to get the web services to use the callers identity. The
>> exception thrown is:
>> Request for the permission of type
>> System.Security.Permissions.EnvironmentPermission
>> As before, it works in Report Designer so the code is alright, it is the
>> security configuration that fails somewhere.
>> /Jonas
>> "Jonas" <Jonas@.nospam.pl> wrote in message
>> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> > I forgot to mention that I make an assert in code before the call to
>> > the
>> web
>> > service:
>> >
>> > WebPermission webPerm = new
>> > WebPermission(PermissionState.Unrestricted);
>> > webPerm.Assert();
>> > TIA
>> >
>> > Jonas
>> >
>> > "Jonas" <Jonas@.nospam.pl> wrote in message
>> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
>> > > Hi,
>> > >
>> > > I've got a custom assembly used in Rptsvcs that calls a web service
>> > > on
>> the
>> > > local host. When run in Report Designer, it works as planned, but
>> > > when
>> run
>> > > in Report Server, it doesn't call the web service. I have a
>> > > HelloWorld-method in the custom assembly that works, so the assembly
> is
>> > > working but it can't call the web service.
>> > >
>> > > I have modified RSReportServer.config as follows:
>> > >
>> > > <CustomAssemblies>
>> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
> Culture=neutral,
>> > > PublicKeyToken=xxx">
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution, Assertion"
>> > > />
>> > > <IPermission
> class="System.Security.Permissions.WebPermission"
>> > > version="1">
>> > > <ConnectAccess>
>> > > <URI uri="$OriginHost$"/>
>> > > </ConnectAccess>
>> > > </IPermission>
>> > > </PermissionSet>
>> > > </Assembly>
>> > >
>> > > <Default>
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution"
>> > > />
>> > > </PermissionSet>
>> > > </Default>
>> > > </CustomAssemblies>
>> > >
>> > >
>> > > And the policy file rssrvpolicy.config is also modified:
>> > >
>> > > <CodeGroup class="UnionCodeGroup"
>> > > version="1"
>> > > PermissionSetName="FullTrust"
>> > > Attributes="LevelFinal"
>> > > Name="cmcs.wsclient"
>> > > Description="Codegroup generated by the .NET Configuration
>> tool">
>> > > <IMembershipCondition class="UrlMembershipCondition"
>> > > version="1"
>> > > Url="file://C:/Program Files/Microsoft SQL
>> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
>> > > </CodeGroup>
>> > >
>> > > Any tips?
>> > >
>> > > Jonas
>> > >
>> > >
>> > >
>> >
>> >
>>
>|||When the report is deployed and run from the web server it runs under a
different set of user credentials to when it is in debug, (Probably "Local
System" or "Network Service", which ever user is configured to run the
reporting services?).
Try explicitly setting the network credentials like so..
ws.Credentials = new NetworkCredential(Username, Password, Domain);
I actually store my username/password/domain in a Settings file, to allow it
to be changed easliy.
This works for me when calling the reporting services web service, I am using:
1. Explicit credentials of a domain user that can access the web service,
2. set the rssrvpolicy.config, Report_Expressions_Default_Permissions -->
Full_Trust
Note I am running my assembly in the gac.
Hope this helps
John
I've got a custom assembly used in Rptsvcs that calls a web service on the
local host. When run in Report Designer, it works as planned, but when run
in Report Server, it doesn't call the web service. I have a
HelloWorld-method in the custom assembly that works, so the assembly is
working but it can't call the web service.
I have modified RSReportServer.config as follows:
<CustomAssemblies>
<Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
PublicKeyToken=xxx">
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution, Assertion"
/>
<IPermission class="System.Security.Permissions.WebPermission"
version="1">
<ConnectAccess>
<URI uri="$OriginHost$"/>
</ConnectAccess>
</IPermission>
</PermissionSet>
</Assembly>
<Default>
<PermissionSet class="System.Security.PermissionSet">
<IPermission
class="System.Security.Permissions.SecurityPermission"
version="1"
Flags="Execution"
/>
</PermissionSet>
</Default>
</CustomAssemblies>
And the policy file rssrvpolicy.config is also modified:
<CodeGroup class="UnionCodeGroup"
version="1"
PermissionSetName="FullTrust"
Attributes="LevelFinal"
Name="cmcs.wsclient"
Description="Codegroup generated by the .NET Configuration tool">
<IMembershipCondition class="UrlMembershipCondition"
version="1"
Url="file://C:/Program Files/Microsoft SQL
Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
</CodeGroup>
Any tips?
JonasI forgot to mention that I make an assert in code before the call to the web
service:
WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
webPerm.Assert();
TIA
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I've got a custom assembly used in Rptsvcs that calls a web service on the
> local host. When run in Report Designer, it works as planned, but when run
> in Report Server, it doesn't call the web service. I have a
> HelloWorld-method in the custom assembly that works, so the assembly is
> working but it can't call the web service.
> I have modified RSReportServer.config as follows:
> <CustomAssemblies>
> <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> PublicKeyToken=xxx">
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution, Assertion"
> />
> <IPermission class="System.Security.Permissions.WebPermission"
> version="1">
> <ConnectAccess>
> <URI uri="$OriginHost$"/>
> </ConnectAccess>
> </IPermission>
> </PermissionSet>
> </Assembly>
> <Default>
> <PermissionSet class="System.Security.PermissionSet">
> <IPermission
> class="System.Security.Permissions.SecurityPermission"
> version="1"
> Flags="Execution"
> />
> </PermissionSet>
> </Default>
> </CustomAssemblies>
>
> And the policy file rssrvpolicy.config is also modified:
> <CodeGroup class="UnionCodeGroup"
> version="1"
> PermissionSetName="FullTrust"
> Attributes="LevelFinal"
> Name="cmcs.wsclient"
> Description="Codegroup generated by the .NET Configuration tool">
> <IMembershipCondition class="UrlMembershipCondition"
> version="1"
> Url="file://C:/Program Files/Microsoft SQL
> Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> </CodeGroup>
> Any tips?
> Jonas
>
>|||After some more investigation, I found out that it is the following
statement
ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
I need this to get the web services to use the callers identity. The
exception thrown is:
Request for the permission of type
System.Security.Permissions.EnvironmentPermission
As before, it works in Report Designer so the code is alright, it is the
security configuration that fails somewhere.
/Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> I forgot to mention that I make an assert in code before the call to the
web
> service:
> WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> webPerm.Assert();
> TIA
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I've got a custom assembly used in Rptsvcs that calls a web service on
the
> > local host. When run in Report Designer, it works as planned, but when
run
> > in Report Server, it doesn't call the web service. I have a
> > HelloWorld-method in the custom assembly that works, so the assembly is
> > working but it can't call the web service.
> >
> > I have modified RSReportServer.config as follows:
> >
> > <CustomAssemblies>
> > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx, Culture=neutral,
> > PublicKeyToken=xxx">
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution, Assertion"
> > />
> > <IPermission class="System.Security.Permissions.WebPermission"
> > version="1">
> > <ConnectAccess>
> > <URI uri="$OriginHost$"/>
> > </ConnectAccess>
> > </IPermission>
> > </PermissionSet>
> > </Assembly>
> >
> > <Default>
> > <PermissionSet class="System.Security.PermissionSet">
> > <IPermission
> > class="System.Security.Permissions.SecurityPermission"
> > version="1"
> > Flags="Execution"
> > />
> > </PermissionSet>
> > </Default>
> > </CustomAssemblies>
> >
> >
> > And the policy file rssrvpolicy.config is also modified:
> >
> > <CodeGroup class="UnionCodeGroup"
> > version="1"
> > PermissionSetName="FullTrust"
> > Attributes="LevelFinal"
> > Name="cmcs.wsclient"
> > Description="Codegroup generated by the .NET Configuration
tool">
> > <IMembershipCondition class="UrlMembershipCondition"
> > version="1"
> > Url="file://C:/Program Files/Microsoft SQL
> > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > </CodeGroup>
> >
> > Any tips?
> >
> > Jonas
> >
> >
> >
>|||I've finally gotten the report to run in Report Server, but it took a while
and a nasty config to do it. It seems that the only way to get this to work
is to change the PermissionSet for Report_Expressions_Default_Permissions in
rssrvpolicy.config to FullTrust. I've tried to create a custom PermissionSet
with CASPOL where I ended up adding all permissions and setting them to
Unrestricted="true" thinking that I could then remove one at a time to
finally get a lower priviliege permission set, but the only thing that works
is FullTrust.
Is there someone else that have experienced the same thing?
Brgds
Jonas
"Jonas" <Jonas@.nospam.pl> wrote in message
news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
> After some more investigation, I found out that it is the following
> statement
> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
> I need this to get the web services to use the callers identity. The
> exception thrown is:
> Request for the permission of type
> System.Security.Permissions.EnvironmentPermission
> As before, it works in Report Designer so the code is alright, it is the
> security configuration that fails somewhere.
> /Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
> > I forgot to mention that I make an assert in code before the call to the
> web
> > service:
> >
> > WebPermission webPerm = new WebPermission(PermissionState.Unrestricted);
> > webPerm.Assert();
> > TIA
> >
> > Jonas
> >
> > "Jonas" <Jonas@.nospam.pl> wrote in message
> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > >
> > > I've got a custom assembly used in Rptsvcs that calls a web service on
> the
> > > local host. When run in Report Designer, it works as planned, but when
> run
> > > in Report Server, it doesn't call the web service. I have a
> > > HelloWorld-method in the custom assembly that works, so the assembly
is
> > > working but it can't call the web service.
> > >
> > > I have modified RSReportServer.config as follows:
> > >
> > > <CustomAssemblies>
> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
Culture=neutral,
> > > PublicKeyToken=xxx">
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution, Assertion"
> > > />
> > > <IPermission
class="System.Security.Permissions.WebPermission"
> > > version="1">
> > > <ConnectAccess>
> > > <URI uri="$OriginHost$"/>
> > > </ConnectAccess>
> > > </IPermission>
> > > </PermissionSet>
> > > </Assembly>
> > >
> > > <Default>
> > > <PermissionSet class="System.Security.PermissionSet">
> > > <IPermission
> > > class="System.Security.Permissions.SecurityPermission"
> > > version="1"
> > > Flags="Execution"
> > > />
> > > </PermissionSet>
> > > </Default>
> > > </CustomAssemblies>
> > >
> > >
> > > And the policy file rssrvpolicy.config is also modified:
> > >
> > > <CodeGroup class="UnionCodeGroup"
> > > version="1"
> > > PermissionSetName="FullTrust"
> > > Attributes="LevelFinal"
> > > Name="cmcs.wsclient"
> > > Description="Codegroup generated by the .NET Configuration
> tool">
> > > <IMembershipCondition class="UrlMembershipCondition"
> > > version="1"
> > > Url="file://C:/Program Files/Microsoft SQL
> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
> > > </CodeGroup>
> > >
> > > Any tips?
> > >
> > > Jonas
> > >
> > >
> > >
> >
> >
>|||Yes, I also had a heck of a time with this. We are calling a web service to
translate English to Spanish.
I ended up going the FullTrust route myself, still haven't tested on a clean
machine all the install and config steps I took.
Steve
"Jonas" <Jonas@.nospam.pl> wrote in message
news:ejM$u7RIGHA.376@.TK2MSFTNGP12.phx.gbl...
> I've finally gotten the report to run in Report Server, but it took a
> while
> and a nasty config to do it. It seems that the only way to get this to
> work
> is to change the PermissionSet for Report_Expressions_Default_Permissions
> in
> rssrvpolicy.config to FullTrust. I've tried to create a custom
> PermissionSet
> with CASPOL where I ended up adding all permissions and setting them to
> Unrestricted="true" thinking that I could then remove one at a time to
> finally get a lower priviliege permission set, but the only thing that
> works
> is FullTrust.
> Is there someone else that have experienced the same thing?
> Brgds
> Jonas
> "Jonas" <Jonas@.nospam.pl> wrote in message
> news:%23YQR7hPIGHA.2212@.TK2MSFTNGP15.phx.gbl...
>> After some more investigation, I found out that it is the following
>> statement
>> ws.Credentials = System.Net.CredentialCache.DefaultCredentials;
>> I need this to get the web services to use the callers identity. The
>> exception thrown is:
>> Request for the permission of type
>> System.Security.Permissions.EnvironmentPermission
>> As before, it works in Report Designer so the code is alright, it is the
>> security configuration that fails somewhere.
>> /Jonas
>> "Jonas" <Jonas@.nospam.pl> wrote in message
>> news:ewR3eFOIGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> > I forgot to mention that I make an assert in code before the call to
>> > the
>> web
>> > service:
>> >
>> > WebPermission webPerm = new
>> > WebPermission(PermissionState.Unrestricted);
>> > webPerm.Assert();
>> > TIA
>> >
>> > Jonas
>> >
>> > "Jonas" <Jonas@.nospam.pl> wrote in message
>> > news:%23Na2whMIGHA.376@.TK2MSFTNGP12.phx.gbl...
>> > > Hi,
>> > >
>> > > I've got a custom assembly used in Rptsvcs that calls a web service
>> > > on
>> the
>> > > local host. When run in Report Designer, it works as planned, but
>> > > when
>> run
>> > > in Report Server, it doesn't call the web service. I have a
>> > > HelloWorld-method in the custom assembly that works, so the assembly
> is
>> > > working but it can't call the web service.
>> > >
>> > > I have modified RSReportServer.config as follows:
>> > >
>> > > <CustomAssemblies>
>> > > <Assembly Name="cmcs.wsclient, Version=1.0.xxx.xxxx,
> Culture=neutral,
>> > > PublicKeyToken=xxx">
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution, Assertion"
>> > > />
>> > > <IPermission
> class="System.Security.Permissions.WebPermission"
>> > > version="1">
>> > > <ConnectAccess>
>> > > <URI uri="$OriginHost$"/>
>> > > </ConnectAccess>
>> > > </IPermission>
>> > > </PermissionSet>
>> > > </Assembly>
>> > >
>> > > <Default>
>> > > <PermissionSet class="System.Security.PermissionSet">
>> > > <IPermission
>> > > class="System.Security.Permissions.SecurityPermission"
>> > > version="1"
>> > > Flags="Execution"
>> > > />
>> > > </PermissionSet>
>> > > </Default>
>> > > </CustomAssemblies>
>> > >
>> > >
>> > > And the policy file rssrvpolicy.config is also modified:
>> > >
>> > > <CodeGroup class="UnionCodeGroup"
>> > > version="1"
>> > > PermissionSetName="FullTrust"
>> > > Attributes="LevelFinal"
>> > > Name="cmcs.wsclient"
>> > > Description="Codegroup generated by the .NET Configuration
>> tool">
>> > > <IMembershipCondition class="UrlMembershipCondition"
>> > > version="1"
>> > > Url="file://C:/Program Files/Microsoft SQL
>> > > Server/MSSQL/Reporting Services/ReportServer/bin/cmcs.wsclient.dll"/>
>> > > </CodeGroup>
>> > >
>> > > Any tips?
>> > >
>> > > Jonas
>> > >
>> > >
>> > >
>> >
>> >
>>
>|||When the report is deployed and run from the web server it runs under a
different set of user credentials to when it is in debug, (Probably "Local
System" or "Network Service", which ever user is configured to run the
reporting services?).
Try explicitly setting the network credentials like so..
ws.Credentials = new NetworkCredential(Username, Password, Domain);
I actually store my username/password/domain in a Settings file, to allow it
to be changed easliy.
This works for me when calling the reporting services web service, I am using:
1. Explicit credentials of a domain user that can access the web service,
2. set the rssrvpolicy.config, Report_Expressions_Default_Permissions -->
Full_Trust
Note I am running my assembly in the gac.
Hope this helps
John
Friday, February 24, 2012
Deploy Package Problem
I have a package that runs fine on my dev box. I deploy it to another server and run it by right-clicking and choosing run. I get an error saying it was unable to log in to the server.(Log in failed for user 'myuser') I am using sql authenication and the connection string says persist security info = true. So where is that password stored? Did I miss something when I deployed?
(I have other connections in the package that are windows auth and they work fine)
Data Source=myserver;User ID=myuser;Initial Catalog=Staging;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False;
(I am just trying to get it to run on the other server, I know I may have other issues when I try to run it under sql agent)
Thx
Who is it package running as on the second server and what is the Package's protection level?|||Thanks for the reply jaegd.
It is running under my id but I am using sql authentication to connect to a remote server and that is where my problem is not with the local server. The part of the package that connects locally under my id works fine, it's only when trying to connect to the remote sever that the password is not being used, I think it is trying to log in with a blank pwd.
Package protection is : EncryptSensitiveWithUserKey
|||I had the same issue. Even on my own machine, no matter how many times I checked "[ ] Save my Password" it would continue to forget it and fail the connections (all 100+).
I finally have resorted to Windows Authentication which I've heard now from several sources is the preferred / encouraged method. Once I switched all my OLE DB connections over to it, it worked fine. Problem is, you have to have permission on the remote server.
I call BUG.
|||Found this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193221&SiteID=1
Which basically says to set your package protection level to DontSaveSensitive and use package configurations for storing passwords, server names, etc.
Simple works for me, only small concern is the passwords are not encrypted (maybe they can be somehow through SSIS) but I can live with it..
Sunday, February 19, 2012
Deploy Integration Service
Hi All,
I had created a Intergration Service on my workstation computer, run as well.
now i want to set a scheduling and run that Intergration Service on server, so should i deploy my Intergration Service to the server?
i had try to use my workstation computer,
open the "SQL Server Management Studio" connect as "Intergration Services", and Import the dtsx file (Package file) in it. but if i had some modify on that dtsx file, i need import the dtsx file on the server again?
any another way to deploy my Intergration Service?
Thx a lot.
Laputa
Have you tried the deployment tool that is provided with SSIS?
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/0f5fc7be-e37e-4ecd-ba99-697c8ae3436f.htm
-Jamie
|||This is a good reference.Thank your very much.
Tuesday, February 14, 2012
Deny Builtin Administrators
I have denied the Builtin Administrators group with SQL Server, now I don't
have access to recover. Everything seems to run okay, but I don't have
permission to do anything anymore. I don't know the password to the sa
account. This is on an Active Directory domain.
Now I can't start backup exec, b\c of dependencies.
Any help would be greatly appreciated.
Thanks in advance.You're pretty well out of luck if you don't know the SA password and don't
have another administrator. The only thing I can think of is to install
again from scratch and then attach the databases - and write down the SA
password this time.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>I have denied the Builtin Administrators group with SQL Server, now I don't
> have access to recover. Everything seems to run okay, but I don't have
> permission to do anything anymore. I don't know the password to the sa
> account. This is on an Active Directory domain.
> Now I can't start backup exec, b\c of dependencies.
> Any help would be greatly appreciated.
> Thanks in advance.|||Okay. Another Administrator meaning...? Domain Admin?
THanks for the prompt reply.
"Roger Wolter[MSFT]" wrote:
> You're pretty well out of luck if you don't know the SA password and don't
> have another administrator. The only thing I can think of is to install
> again from scratch and then attach the databases - and write down the SA
> password this time.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>
>|||Another administrator meaning a user who can log in who has admin privileges
in the database. You eliminated all Windows admins already unless you have
specifically granted permissions to a particular user before you denied
Windows admins and forgot the sa password.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...[vbcol=seagreen]
> Okay. Another Administrator meaning...? Domain Admin?
> THanks for the prompt reply.
> "Roger Wolter[MSFT]" wrote:
>|||Yes, I was sure that's what you meant, but just wanted to confirm. Thanks
for your help Roger.
"Roger Wolter[MSFT]" wrote:
> Another administrator meaning a user who can log in who has admin privileg
es
> in the database. You eliminated all Windows admins already unless you hav
e
> specifically granted permissions to a particular user before you denied
> Windows admins and forgot the sa password.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...
>
>
have access to recover. Everything seems to run okay, but I don't have
permission to do anything anymore. I don't know the password to the sa
account. This is on an Active Directory domain.
Now I can't start backup exec, b\c of dependencies.
Any help would be greatly appreciated.
Thanks in advance.You're pretty well out of luck if you don't know the SA password and don't
have another administrator. The only thing I can think of is to install
again from scratch and then attach the databases - and write down the SA
password this time.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>I have denied the Builtin Administrators group with SQL Server, now I don't
> have access to recover. Everything seems to run okay, but I don't have
> permission to do anything anymore. I don't know the password to the sa
> account. This is on an Active Directory domain.
> Now I can't start backup exec, b\c of dependencies.
> Any help would be greatly appreciated.
> Thanks in advance.|||Okay. Another Administrator meaning...? Domain Admin?
THanks for the prompt reply.
"Roger Wolter[MSFT]" wrote:
> You're pretty well out of luck if you don't know the SA password and don't
> have another administrator. The only thing I can think of is to install
> again from scratch and then attach the databases - and write down the SA
> password this time.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:17A2CB2B-73F2-4DAA-8B18-FC4C636AC714@.microsoft.com...
>
>|||Another administrator meaning a user who can log in who has admin privileges
in the database. You eliminated all Windows admins already unless you have
specifically granted permissions to a particular user before you denied
Windows admins and forgot the sa password.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"dusty" <dusty@.discussions.microsoft.com> wrote in message
news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...[vbcol=seagreen]
> Okay. Another Administrator meaning...? Domain Admin?
> THanks for the prompt reply.
> "Roger Wolter[MSFT]" wrote:
>|||Yes, I was sure that's what you meant, but just wanted to confirm. Thanks
for your help Roger.
"Roger Wolter[MSFT]" wrote:
> Another administrator meaning a user who can log in who has admin privileg
es
> in the database. You eliminated all Windows admins already unless you hav
e
> specifically granted permissions to a particular user before you denied
> Windows admins and forgot the sa password.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "dusty" <dusty@.discussions.microsoft.com> wrote in message
> news:5727AD5D-34FD-4FDC-A917-E6B1E237B0A5@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)